From 62eb499b0c969f246d3245d1429a97da4de1ce28 Mon Sep 17 00:00:00 2001
From: 钟日健 <arsn163@163.com>
Date: Mon, 01 Jun 2026 20:46:13 +0800
Subject: [PATCH] feat: 成绩查询增加年龄查询返回
---
src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java | 186 ++++++++++++++++++++++++++++------------------
1 files changed, 113 insertions(+), 73 deletions(-)
diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
index 6092a32..92b779a 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
+++ b/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;
@@ -15,6 +16,7 @@
import org.springblade.modules.exam.vo.ExamSubjectChoicesVO;
import org.springblade.modules.simulateexam.entity.SimulateExamAnswerRecord;
import org.springblade.modules.simulateexam.service.SimulateExamAnswerRecordService;
+import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -26,6 +28,7 @@
/**
* 选择题服务实现类
+ *
* @author zhongrj
*/
@Service
@@ -39,6 +42,8 @@
@Autowired
private SimulateExamAnswerRecordService simulateExamAnswerRecordService;
+ @Autowired
+ private MyAsyncService myAsyncService;
@Override
@@ -53,6 +58,7 @@
/**
* 详情
+ *
* @param examSubjectChoices 选择题信息对象
*/
@Override
@@ -62,11 +68,12 @@
@Override
public boolean updateChoicesValue(String id, String value) {
- return baseMapper.updateChoicesValue(id,value);
+ return baseMapper.updateChoicesValue(id, value);
}
/**
* 新增题目及选项信息
+ *
* @param examSubjectChoices 题目信息对象
* @return
*/
@@ -103,7 +110,7 @@
});
return true;
}
- }else {
+ } else {
//修改
ExamSubjectChoices subjectChoices = new ExamSubjectChoices();
subjectChoices.setId(examSubjectChoices.getId());
@@ -154,7 +161,8 @@
/**
* 题库导入
- * @param data 导入数据
+ *
+ * @param data 导入数据
* @param isCovered
*/
@Override
@@ -227,7 +235,7 @@
//多选选项新增
if (examSubjectExcel.getChoicesType() == 3) {
//1选项新增
- if (null!=examSubjectExcel.getOptionContentA() && examSubjectExcel.getOptionContentA()!="") {
+ if (null != examSubjectExcel.getOptionContentA() && examSubjectExcel.getOptionContentA() != "") {
ExamSubjectOption examSubjectOption = new ExamSubjectOption();
//选项新增
examSubjectOption.setSubjectChoicesId(subjectChoices.getId());
@@ -240,7 +248,7 @@
}
//2选项新增
- if (null!=examSubjectExcel.getOptionContentB() && examSubjectExcel.getOptionContentB()!="") {
+ if (null != examSubjectExcel.getOptionContentB() && examSubjectExcel.getOptionContentB() != "") {
ExamSubjectOption examSubjectOption1 = new ExamSubjectOption();
//选项新增
examSubjectOption1.setSubjectChoicesId(subjectChoices.getId());
@@ -253,7 +261,7 @@
}
//3选项新增
- if (null!=examSubjectExcel.getOptionContentC() && examSubjectExcel.getOptionContentC()!="") {
+ if (null != examSubjectExcel.getOptionContentC() && examSubjectExcel.getOptionContentC() != "") {
ExamSubjectOption examSubjectOption2 = new ExamSubjectOption();
//选项新增
examSubjectOption2.setSubjectChoicesId(subjectChoices.getId());
@@ -266,7 +274,7 @@
}
//4选项新增
- if (null!=examSubjectExcel.getOptionContentD() && examSubjectExcel.getOptionContentD()!="") {
+ if (null != examSubjectExcel.getOptionContentD() && examSubjectExcel.getOptionContentD() != "") {
ExamSubjectOption examSubjectOption3 = new ExamSubjectOption();
//选项新增
examSubjectOption3.setSubjectChoicesId(subjectChoices.getId());
@@ -280,7 +288,7 @@
//5选项新增
- if (null!=examSubjectExcel.getOptionContentE() && examSubjectExcel.getOptionContentE()!="") {
+ if (null != examSubjectExcel.getOptionContentE() && examSubjectExcel.getOptionContentE() != "") {
ExamSubjectOption examSubjectOption4 = new ExamSubjectOption();
//选项新增
examSubjectOption4.setSubjectChoicesId(subjectChoices.getId());
@@ -299,31 +307,32 @@
/**
* 判断当前题目的答题结果
+ *
* @param preSubJectId 题目Id
- * @param preResult 提交的结果
- * @param scoreId 成绩id
+ * @param preResult 提交的结果
+ * @param scoreId 成绩id
* @return
*/
@Override
- public Integer getAnswerResult(Long preSubJectId, String preResult,Long scoreId) {
+ public Integer getAnswerResult(Long preSubJectId, String preResult, Long scoreId) {
//查询题目信息
ExamSubjectChoices choices = this.getById(preSubJectId);
//对比答案
- if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3){
+ if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3) {
//保存答题记录
boolean result = preResult.equals(choices.getAnswer());
int status = 0;
//判断题逻辑
- if (result){
+ if (result) {
status = 1;
- }else {
+ } else {
status = 2;
}
//新增答题记录
- saveExamAns(choices,preSubJectId,preResult,scoreId,result);
+ saveExamAns(choices, preSubJectId, preResult, scoreId, result);
//返回
return status;
- }else if(choices.getChoicesType() == 0 || choices.getChoicesType() == 1){
+ } else if (choices.getChoicesType() == 0 || choices.getChoicesType() == 1) {
//处理多选题的答案排序
String[] split = preResult.split(",");
StringBuilder builder = new StringBuilder();
@@ -334,19 +343,19 @@
//利用数组帮助类自动排序
Arrays.sort(arrayCh);
String sub0 = Arrays.toString(arrayCh);
- String sub = sub0.substring(1,sub0.length()-1).replaceAll(" ","");
+ String sub = sub0.substring(1, sub0.length() - 1).replaceAll(" ", "");
//保存答题记录
boolean result = sub.equals(choices.getAnswer());
int status = 0;
//判断题逻辑
- if (result){
+ if (result) {
status = 1;
- }else {
+ } else {
status = 2;
}
//新增答题记录
- saveExamAns(choices,preSubJectId,preResult,scoreId,result);
+ saveExamAns(choices, preSubJectId, preResult, scoreId, result);
//返回
return status;
}
@@ -355,50 +364,79 @@
/**
* 新增答题记录
- * @param choices 题目
+ *
+ * @param choices 题目
* @param preSubJectId 上一题题目id
- * @param preResult 上一题答题结果
- * @param scoreId 成绩 id
- * @param result 答题是否正确
+ * @param preResult 上一题答题结果
+ * @param scoreId 成绩 id
+ * @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());
+ private void saveExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long scoreId, boolean result) {
+ // 判断是否修改了答案
+ 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 {
- 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);
+ 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);
+ }
}
/**
* 随机查询题库120道
+ *
* @return
*/
@Override
@@ -408,8 +446,9 @@
/**
* 判断当前题目的答题结果
- * @param preSubJectId 题目 id
- * @param preResult 提交的结果
+ *
+ * @param preSubJectId 题目 id
+ * @param preResult 提交的结果
* @param simulateExamId 模拟考试记录 id
* @return
*/
@@ -418,21 +457,21 @@
//查询题目信息
ExamSubjectChoices choices = this.getById(preSubJectId);
//对比答案
- if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3){
+ if (choices.getChoicesType() == 2 || choices.getChoicesType() == 3) {
//保存答题记录
boolean result = preResult.equals(choices.getAnswer());
int status = 0;
//判断题逻辑
- if (result){
+ if (result) {
status = 1;
- }else {
+ } else {
status = 2;
}
//新增模拟考试答题记录
- saveSimulateExamAns(choices,preSubJectId,preResult,simulateExamId,result);
+ saveSimulateExamAns(choices, preSubJectId, preResult, simulateExamId, result);
//返回
return status;
- }else if(choices.getChoicesType() == 0 || choices.getChoicesType() == 1){
+ } else if (choices.getChoicesType() == 0 || choices.getChoicesType() == 1) {
//处理多选题的答案排序
String[] split = preResult.split(",");
StringBuilder builder = new StringBuilder();
@@ -443,19 +482,19 @@
//利用数组帮助类自动排序
Arrays.sort(arrayCh);
String sub0 = Arrays.toString(arrayCh);
- String sub = sub0.substring(1,sub0.length()-1).replaceAll(" ","");
+ String sub = sub0.substring(1, sub0.length() - 1).replaceAll(" ", "");
//保存模拟考试答题记录
boolean result = sub.equals(choices.getAnswer());
int status = 0;
//判断题逻辑
- if (result){
+ if (result) {
status = 1;
- }else {
+ } else {
status = 2;
}
//新增模拟考试答题记录
- saveSimulateExamAns(choices,preSubJectId,preResult,simulateExamId,result);
+ saveSimulateExamAns(choices, preSubJectId, preResult, simulateExamId, result);
//返回
return status;
}
@@ -464,11 +503,12 @@
/**
* 新增模拟考试答题记录
- * @param choices 题目信息
- * @param preSubJectId 题目id
- * @param preResult 提交的答案
+ *
+ * @param choices 题目信息
+ * @param preSubJectId 题目id
+ * @param preResult 提交的答案
* @param simulateExamId 模拟考试id
- * @param result 答题的结果
+ * @param result 答题的结果
*/
private void saveSimulateExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long simulateExamId, boolean result) {
SimulateExamAnswerRecord simulateExamAnswerRecord = new SimulateExamAnswerRecord();
@@ -480,10 +520,10 @@
simulateExamAnswerRecord.setAnswerTime(new Date());
int status = 0;
//判断题逻辑
- if (result){
+ if (result) {
status = 1;
simulateExamAnswerRecord.setAnswerScore(choices.getScore());
- }else {
+ } else {
status = 2;
simulateExamAnswerRecord.setAnswerScore(0);
}
--
Gitblit v1.9.3