package com.jevon.service.impl; import com.jevon.mapper.StudentDetailMapper; import com.jevon.model.StudentDetail; import com.jevon.service.StudentDetailService; 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 13:47 */ @Service public class StudentDetailServiceImpl implements StudentDetailService { @Autowired StudentDetailMapper studentDetailMapper; @Override public int insertBatch(List list) { int i = 0 ; List result = new ArrayList<>(); for(StudentDetail studentDetail :list){ i++ ; result.add(studentDetail); if(i % 100 == 0){ studentDetailMapper.insertBatch(result); result = new ArrayList<>(); } } studentDetailMapper.insertBatch(result); return 1 ; } @Override public Double selectSumScore(int analyseId, List league , String schoolName, String examNumber) { StudentDetail studentDetail = new StudentDetail(); studentDetail.setAnalyseId(analyseId); studentDetail.setSchoolName(schoolName); studentDetail.setExamNumber(examNumber); studentDetail.setSchoolNames(league); return studentDetailMapper.selectSumScore(studentDetail); } @Override public int selectTrueByExamNumber(int analyseId,List league , String schoolName, String examNumber, List studentNumbers , Double score) { StudentDetail studentDetail = new StudentDetail(); studentDetail.setAnalyseId(analyseId); studentDetail.setSchoolName(schoolName); studentDetail.setExamNumber(examNumber); studentDetail.setScore(score); studentDetail.setStudentNumbers(studentNumbers); studentDetail.setSchoolNames(league); return studentDetailMapper.selectTrueByExamNumber(studentDetail); } }