| | |
| | | <!--考试成绩分页信息--> |
| | | <select id="selectExamScorePage" resultType="org.springblade.modules.exam.vo.ExamScoreVO"> |
| | | SELECT |
| | | * |
| | | id,candidate_no candidateNo,theory_grade theoryGrade,isnull(learn_grade,-1) learnGrade,all_grade, |
| | | exam_name examName,security_name securityName,exam_type examType,company,exam_time examTime, |
| | | all_score allScore,exam_end_time examEndTime,qualified |
| | | FROM |
| | | exam_score |
| | | WHERE |
| | |
| | | <!--考试成绩详情信息--> |
| | | <select id="selectExamScoreInfo" resultType="org.springblade.modules.exam.vo.ExamScoreVO"> |
| | | SELECT |
| | | * |
| | | id,candidate_no candidateNo,theory_grade theoryGrade,isnull(learn_grade,-1) learnGrade,all_grade, |
| | | exam_name examName,security_name securityName,exam_type examType,company,exam_time examTime, |
| | | all_score allScore,exam_end_time examEndTime,qualified |
| | | FROM |
| | | exam_score |
| | | WHERE |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | //对比题目id |
| | | if (examResultVO.getSubjectChoicesId().equals(examExaminationSubject.getExamSubjectChoices().getId())) { |
| | | //对比答案 |
| | | if (examResultVO.getValue().equals(examExaminationSubject.getExamSubjectChoices().getAnswer())) { |
| | | //处理多选题的答案排序 |
| | | String[] split = examResultVO.getValue().split(","); |
| | | StringBuilder builder = new StringBuilder(); |
| | | for (String s : split) { |
| | | builder.append(s); |
| | | } |
| | | char[] arrayCh = builder.toString().toCharArray(); |
| | | //利用数组帮助类自动排序 |
| | | Arrays.sort(arrayCh); |
| | | String sub0 = Arrays.toString(arrayCh); |
| | | String sub = sub0.substring(1,sub0.length()-1).replaceAll(" ",""); |
| | | if (sub.equals(examExaminationSubject.getExamSubjectChoices().getAnswer())) { |
| | | theoryGrade += examResultVO.getGrade(); |
| | | } |
| | | //移除当前试卷题目答案对象 |