考试答题记录插入数据同步

Administrator

2021-09-30 10618adc08c91183440989ed83feb08358153d60

考试答题记录插入数据同步

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

@@ -5,6 +5,7 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.springblade.common.utils.arg;
import org.springblade.modules.FTP.FtpUtil;
import org.springblade.modules.exam.entity.ExamAnswerRecord;
import org.springblade.modules.exam.entity.ExamSubjectChoices;
import org.springblade.modules.exam.entity.ExamSubjectOption;
@@ -18,6 +19,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
@@ -350,11 +352,11 @@

    /**
     * 新增答题记录
     * @param choices
     * @param preSubJectId
     * @param preResult
     * @param scoreId
     * @param result
     * @param choices 题目
     * @param preSubJectId 上一题题目id
     * @param preResult 上一题答题结果
     * @param scoreId 成绩 id
     * @param result 答题是否正确
     */
    private void saveExamAns(ExamSubjectChoices choices, Long preSubJectId, String preResult, Long scoreId,boolean result) {
        ExamAnswerRecord examAnswerRecord = new ExamAnswerRecord();
@@ -378,5 +380,17 @@
        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);
    }
}