StudentServiceImpl.java
5.6 KB
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
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<>();
}
}
if(result.size()>0){
studentMapper.insertBatch(result);
}
return 1 ;
}
@Override
public Student selectStudent(int analyseId, String schoolName, String studentNumber) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setStudentNumber(studentNumber);
return studentMapper.selectStudent(student);
}
@Override
public List<Student> selectBySchoolName(int analyseId , List<String> league , String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
return studentMapper.selectByStudent(student);
}
@Override
public List<Student> selectByClassName(int analyseId, String schoolName, String className) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setClassName(className);
return studentMapper.selectByStudent(student);
}
@Override
public int selectCountByScore(int analyseId, List<String> league , String schoolName, double begin, double end) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setBegin(begin);
student.setEnd(end);
student.setSchoolNames(league);
return studentMapper.selectCountByScore(student);
}
@Override
public int selectCountBySchoolScore(int analyseId, String schoolName, String className, double begin, double end) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setClassName(className);
student.setBegin(begin);
student.setEnd(end);
return studentMapper.selectCountByScore(student); }
@Override
public List<String> selectClassNameBySchool(int analyseId, String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
return studentMapper.selectClassNameBySchool(student);
}
@Override
public List<String> selectSchoolNameByAnalyse(int analyseId) {
return studentMapper.selectSchoolNameByAnalyse(analyseId);
}
@Override
public Double selectClassMaxScore(int analyseId, String schoolName, String className) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setClassName(className);
return studentMapper.selectMaxScore(student);
}
@Override
public Double selectMaxScore(int analyseId,List<String> league , String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
return studentMapper.selectMaxScore(student);
}
@Override
public Double selectMinScore(int analyseId, List<String> league ,String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
return studentMapper.selectMinScore(student);
}
@Override
public Double selectAvgScore(int analyseId,List<String> league , String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
return studentMapper.selectAvgScore(student);
}
@Override
public Double selectModeNumber(int analyseId,List<String> league , String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
List<Double> list = studentMapper.selectModeNumber(student);
if(list.size() > 1){
return null ;
}else {
return list.get(0);
}
}
@Override
public Double selectMedian(int analyseId,List<String> league , String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
return studentMapper.selectMedian(student);
}
@Override
public Double selectStdev(int analyseId,List<String> league , String schoolName) {
Student student = new Student();
student.setAnalyseId(analyseId);
student.setSchoolName(schoolName);
student.setSchoolNames(league);
return studentMapper.selectStdev(student);
}
}