Blame view

src/main/java/com/jevon/service/impl/StudentServiceImpl.java 4.15 KB
ef5c16a0   陈杰   试卷导入
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
package com.jevon.service.impl;

import com.jevon.mapper.StudentMapper;
import com.jevon.model.Student;
import com.jevon.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

/**
 * @author chen
 * @version 1.0
 * @date 2019/10/18 0018 15:16
 */
@Service
public class StudentServiceImpl implements StudentService {

    @Autowired
    StudentMapper studentMapper;

    @Override
    public int insertBatch(List<Student> list) {
        int i = 0 ;
        List<Student> result = new ArrayList<>();
        for(Student student :list){
            i++ ;
            result.add(student);
            if(i % 100 == 0){
                studentMapper.insertBatch(result);
                result = new ArrayList<>();
            }
        }
1de4a428   陈杰   批量上传bug 修复
35
36
37
        studentMapper.insertBatch(result);
        return  1 ;
    }
ef5c16a0   陈杰   试卷导入
38
39
40
41

    @Override
    public List<Student> selectBySchoolName(int analyseId, String schoolName) {
        Student student = new Student();
5cba275e   陈杰   个人学情
42
43
44
45
46
47
48
49
50
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectByStudent(student);
    }

    @Override
    public List<Student> selectByClassName(int analyseId, String schoolName, String className) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
a923e3fe   陈杰   四维诊断
51
        student.setSchoolName(schoolName);
ef5c16a0   陈杰   试卷导入
52
53
54
        student.setClassName(className);
        return studentMapper.selectByStudent(student);
    }
a923e3fe   陈杰   四维诊断
55

e6e6895d   陈杰   学科考试概况
56
57
58
59
60
61
62
63
64
65
    @Override
    public int selectCountByScore(int analyseId, String schoolName, double begin, double end) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        student.setBegin(begin);
        student.setEnd(end);
        return studentMapper.selectCountByScore(student);
    }

ef5c16a0   陈杰   试卷导入
66
67
68
    @Override
    public int selectCountBySchoolScore(int analyseId, String schoolName, String className, double begin, double end) {
        Student student = new Student();
a923e3fe   陈杰   四维诊断
69
        student.setAnalyseId(analyseId);
ef5c16a0   陈杰   试卷导入
70
71
72
73
74
        student.setSchoolName(schoolName);
        student.setClassName(className);
        student.setBegin(begin);
        student.setEnd(end);
        return studentMapper.selectCountByScore(student);    }
a923e3fe   陈杰   四维诊断
75

ef5c16a0   陈杰   试卷导入
76
77
    @Override
    public List<String> selectClassNameBySchool(int analyseId, String schoolName) {
e6e6895d   陈杰   学科考试概况
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectClassNameBySchool(student);
    }

    @Override
    public Double selectMaxScore(int analyseId, String schoolName) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectMaxScore(student);
    }

    @Override
    public Double selectMinScore(int analyseId, String schoolName) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectMinScore(student);
a923e3fe   陈杰   四维诊断
98
99
100
101
102
    }

    @Override
    public Double selectAvgScore(int analyseId, String schoolName) {
        Student student = new Student();
5cba275e   陈杰   个人学情
103
104
105
106
107
108
109
110
111
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectAvgScore(student);
    }

    @Override
    public Double selectModeNumber(int analyseId, String schoolName) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
a923e3fe   陈杰   四维诊断
112
        student.setSchoolName(schoolName);
e6e6895d   陈杰   学科考试概况
113
114
115
        return studentMapper.selectModeNumber(student);
    }

a923e3fe   陈杰   四维诊断
116
    @Override
e6e6895d   陈杰   学科考试概况
117
118
119
120
    public Double selectMedian(int analyseId, String schoolName) {
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
a923e3fe   陈杰   四维诊断
121
        return studentMapper.selectMedian(student);
e6e6895d   陈杰   学科考试概况
122
123
124
    }

    @Override
a923e3fe   陈杰   四维诊断
125
    public Double selectStdev(int analyseId, String schoolName) {
e6e6895d   陈杰   学科考试概况
126
127
128
129
        Student student = new Student();
        student.setAnalyseId(analyseId);
        student.setSchoolName(schoolName);
        return studentMapper.selectStdev(student);
a923e3fe   陈杰   四维诊断
130
    }
e6e6895d   陈杰   学科考试概况
131
}
a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

a923e3fe   陈杰   四维诊断

e6e6895d   陈杰   学科考试概况

ef5c16a0   陈杰   试卷导入