feat: 成绩查询增加年龄查询返回

钟日健

2026-06-01 62eb499b0c969f246d3245d1429a97da4de1ce28

 src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java

@@ -1,6 +1,7 @@

package org.springblade.modules.exam.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.FTP.FtpUtil;
@@ -371,40 +372,66 @@
    * @param result       答题是否正确
    */
   private void saveExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long scoreId, boolean result) {
      ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
      examAnswerRecord.setScoreId(scoreId);
      examAnswerRecord.setAnswerOption(preResult);
      examAnswerRecord.setSubjectChoicesId(preSubJectId);
      examAnswerRecord.setAnswer(choices.getAnswer());
      examAnswerRecord.setSubjectChoicesType(choices.getChoicesType());
      examAnswerRecord.setAnswerTime(new Date());
      int status = 0;
      //判断题逻辑
      if (result) {
         status = 1;
         examAnswerRecord.setAnswerScore(choices.getScore());
      } else {
         status = 2;
         examAnswerRecord.setAnswerScore(0);
      }
      examAnswerRecord.setAnswerResult(status);
      //新增
      examAnswerRecordService.save(examAnswerRecord);
      // 判断是否修改了答案
      QueryWrapper<ExamAnswerRecord> wrapper = new QueryWrapper<>();
      wrapper.eq("score_id",scoreId)
         .eq("subject_choices_id",preSubJectId);
      ExamAnswerRecord one = examAnswerRecordService.getOne(wrapper);
      if (null!=one){
         // 更新
         one.setAnswerOption(preResult);
         one.setAnswer(choices.getAnswer());
         one.setSubjectChoicesType(choices.getChoicesType());
         one.setAnswerTime(new Date());
         int status = 0;
         //判断题逻辑
         if (result) {
            status = 1;
            one.setAnswerScore(choices.getScore());
         } else {
            status = 2;
            one.setAnswerScore(0);
         }
         one.setAnswerResult(status);
         //修改
         examAnswerRecordService.updateById(one);
      }else {

      //内网数据同步...
      String s = "insert into exam_answer_record(id,subject_choices_id,subject_choices_type,answer_option,answer" +
         ",answer_time,answer_score,answer_result,score_id) " +
         "values(" + "'" + examAnswerRecord.getId() + "'" +
         "," + "'" + examAnswerRecord.getSubjectChoicesId() + "'" +
         "," + "'" + examAnswerRecord.getSubjectChoicesType() + "'" +
         "," + "'" + examAnswerRecord.getAnswerOption() + "'" +
         "," + "'" + examAnswerRecord.getAnswer() + "'" +
         "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examAnswerRecord.getAnswerTime()) + "'" +
         "," + "'" + examAnswerRecord.getAnswerScore() + "'" +
         "," + "'" + examAnswerRecord.getAnswerResult() + "'" +
         "," + "'" + examAnswerRecord.getScoreId() + "'" + ")";
      //FtpUtil.sqlFileUpload(s);
      myAsyncService.dataSync(s);
         ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
         examAnswerRecord.setScoreId(scoreId);
         examAnswerRecord.setAnswerOption(preResult);
         examAnswerRecord.setSubjectChoicesId(preSubJectId);
         examAnswerRecord.setAnswer(choices.getAnswer());
         examAnswerRecord.setSubjectChoicesType(choices.getChoicesType());
         examAnswerRecord.setAnswerTime(new Date());
         int status = 0;
         //判断题逻辑
         if (result) {
            status = 1;
            examAnswerRecord.setAnswerScore(choices.getScore());
         } else {
            status = 2;
            examAnswerRecord.setAnswerScore(0);
         }
         examAnswerRecord.setAnswerResult(status);
         //新增
         examAnswerRecordService.save(examAnswerRecord);
//
//         //内网数据同步...
//         String s = "insert into exam_answer_record(id,subject_choices_id,subject_choices_type,answer_option,answer" +
//            ",answer_time,answer_score,answer_result,score_id) " +
//            "values(" + "'" + examAnswerRecord.getId() + "'" +
//            "," + "'" + examAnswerRecord.getSubjectChoicesId() + "'" +
//            "," + "'" + examAnswerRecord.getSubjectChoicesType() + "'" +
//            "," + "'" + examAnswerRecord.getAnswerOption() + "'" +
//            "," + "'" + examAnswerRecord.getAnswer() + "'" +
//            "," + "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(examAnswerRecord.getAnswerTime()) + "'" +
//            "," + "'" + examAnswerRecord.getAnswerScore() + "'" +
//            "," + "'" + examAnswerRecord.getAnswerResult() + "'" +
//            "," + "'" + examAnswerRecord.getScoreId() + "'" + ")";
//         //FtpUtil.sqlFileUpload(s);
//         myAsyncService.dataSync(s);
      }
   }

   /**