1.提交答题情况

1.PracticeDetailController.java

    /*** 提交题目，每一次点下一题，都会调用这个接口*/@PostMapping(value = "/submitSubject")public Result<Boolean> submitSubject(@RequestBody SubmitSubjectDetailReq req) {try {if (log.isInfoEnabled()) {log.info("练习提交题目入参{}", JSON.toJSONString(req));}Preconditions.checkArgument(!Objects.isNull(req), "参数不能为空！");Preconditions.checkArgument(!Objects.isNull(req.getPracticeId()), "练习id不能为空！");Preconditions.checkArgument(!Objects.isNull(req.getSubjectId()), "题目id不能为空！");Preconditions.checkArgument(!Objects.isNull(req.getSubjectType()), "题目类型不能为空！");Preconditions.checkArgument(!StringUtils.isBlank(req.getTimeUse()), "用时不能为空！");Boolean result = practiceDetailService.submitSubject(req);log.info("练习提交题目出参{}", result);return Result.ok(result);} catch (IllegalArgumentException e) {log.error("参数异常！错误原因{}", e.getMessage(), e);return Result.fail(e.getMessage());} catch (Exception e) {log.error("练习提交题目异常！错误原因{}", e.getMessage(), e);return Result.fail("练习提交题目异常！");}}

2.PracticeDetailService.java

package com.sunxiansheng.practice.server.service;import com.sunxiansheng.practice.api.req.SubmitSubjectDetailReq;/*** Description:* @Author sun* @Create 2024/7/8 12:28* @Version 1.0*/
public interface PracticeDetailService {/*** 练习提交题目*/Boolean submitSubject(SubmitSubjectDetailReq req);}

3.PracticeDetailServiceImpl.java

package com.sunxiansheng.practice.server.service.impl;import com.sunxiansheng.practice.api.enums.SubjectInfoTypeEnum;
import com.sunxiansheng.practice.api.req.SubmitSubjectDetailReq;
import com.sunxiansheng.practice.server.dao.*;
import com.sunxiansheng.practice.server.entity.dto.SubjectDTO;
import com.sunxiansheng.practice.server.entity.po.PracticeDetailPO;
import com.sunxiansheng.practice.server.entity.po.PracticePO;
import com.sunxiansheng.practice.server.entity.po.SubjectMultiplePO;
import com.sunxiansheng.practice.server.entity.po.SubjectRadioPO;
import com.sunxiansheng.practice.server.service.PracticeDetailService;
import com.sunxiansheng.practice.server.util.LoginUtil;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;import javax.annotation.Resource;
import java.util.Collections;
import java.util.Date;
import java.util.List;
import java.util.Objects;/*** Description:* @Author sun* @Create 2024/6/25 17:08* @Version 1.0*/
@Service
@Slf4j
public class PracticeDetailServiceImpl implements PracticeDetailService {@Resourceprivate PracticeDao practiceDao;@Resourceprivate SubjectDao subjectDao;@Resourceprivate SubjectRadioDao subjectRadioDao;@Resourceprivate SubjectMultipleDao subjectMultipleDao;@Resourceprivate PracticeDetailDao practiceDetailDao;@Override@Transactional(rollbackFor = Exception.class)public Boolean submitSubject(SubmitSubjectDetailReq req) {// 获取req的信息Long practiceId = req.getPracticeId();Long subjectId = req.getSubjectId();List<Integer> answerContents = req.getAnswerContents();Integer subjectType = req.getSubjectType();String timeUse = req.getTimeUse();// ============================== 处理用时 ==============================if (timeUse.equals("0")) {timeUse = "000000";}String hour = timeUse.substring(0, 2);String minute = timeUse.substring(2, 4);String second = timeUse.substring(4, 6);// ============================== 处理用时 ==============================// ============================== 根据id更新时间 ==============================PracticePO practicePO = new PracticePO();practicePO.setId(practiceId);practicePO.setTimeUse(hour + ":" + minute + ":" + second);practicePO.setSubmitTime(new Date());practiceDao.update(practicePO);// ============================== 根据id更新时间 ==============================// ============================== 给练习的细节插入一条记录 ==============================PracticeDetailPO practiceDetailPO = new PracticeDetailPO();// 基本信息填充practiceDetailPO.setPracticeId(practiceId);practiceDetailPO.setSubjectId(subjectId);practiceDetailPO.setSubjectType(subjectType);String loginId = LoginUtil.getLoginId();practiceDetailPO.setCreatedBy(loginId);practiceDetailPO.setCreatedTime(new Date());practiceDetailPO.setIsDeleted(0);// 修改答案数组，将答案变成1,2,3...这种格式的String answerContent = getAnswerContent(answerContents);practiceDetailPO.setAnswerContent(answerContent);// 从数据库中获取正确答案，并判断答案是否正确SubjectDTO subjectDTO = new SubjectDTO();subjectDTO.setSubjectId(req.getSubjectId());subjectDTO.setSubjectType(req.getSubjectType());// 根据subjectId和subjectType来获取题目答案// 初始化为0Integer answerStatus = 0;StringBuffer correctAnswer = new StringBuffer();// 获得正确答案的字符串extracted(subjectType, subjectId, correctAnswer);// 如果答案正确，则答案的状态就会是1，否则是0if (Objects.equals(correctAnswer.toString(), answerContent)) {// practiceDetailPO.setAnswerStatus(1);answerStatus = 1;}practiceDetailPO.setAnswerStatus(answerStatus);// 到此练习的细节就构建完毕了// 查询练习细节是否已经存在了，如果存在就更新，不存在就插入PracticeDetailPO existDetail = practiceDetailDao.selectDetail(practiceId, subjectId, loginId);if (Objects.isNull(existDetail)) {practiceDetailDao.insertSingle(practiceDetailPO);} else {practiceDetailPO.setId(existDetail.getId());practiceDetailDao.update(practiceDetailPO);}// ============================== 给练习的细节插入一条记录 ==============================return true;}/*** 根据题目id和类型，得到正确答案的字符串* @param subjectType* @param subjectId* @param correctAnswer*/private void extracted(Integer subjectType, Long subjectId, StringBuffer correctAnswer) {// 单选if (subjectType == SubjectInfoTypeEnum.RADIO.getCode()) {// 查询单选题目细节List<SubjectRadioPO> subjectRadioPOS = subjectRadioDao.selectBySubjectId(subjectId);// 得到对的那个的选项类型subjectRadioPOS.forEach(radio -> {if (Objects.equals(radio.getIsCorrect(), 1)) {correctAnswer.append(radio.getOptionType());}});}// 多选if (subjectType == SubjectInfoTypeEnum.MULTIPLE.getCode()) {// 查询多选题目细节List<SubjectMultiplePO> subjectMultiplePOS = subjectMultipleDao.selectBySubjectId(subjectId);// 得到所有的对的选项类型subjectMultiplePOS.forEach(multiple -> {if (Objects.equals(multiple.getIsCorrect(), 1)) {correctAnswer.append(multiple.getOptionType()).append(",");}});// 去掉最后一个逗号if (correctAnswer.length() > 0) {correctAnswer.deleteCharAt(correctAnswer.length() - 1);}}// 判断if (subjectType == SubjectInfoTypeEnum.JUDGE.getCode()) {// 查询判断题目细节List<SubjectMultiplePO> subjectMultiplePOS = subjectMultipleDao.selectBySubjectId(subjectId);// 判断题只能有一条细节，所以取第一个就可以Integer isCorrect = subjectMultiplePOS.get(0).getIsCorrect();correctAnswer.append(isCorrect);}}/*** 修改答案数组，将答案变成1,2,3...这种格式的* @param answerContents* @return*/private static String getAnswerContent(List<Integer> answerContents) {String answerContent = "";// 判空if (!CollectionUtils.isEmpty(answerContents)) {// 排序Collections.sort(answerContents);// 拼接answerContent = StringUtils.join(answerContents, ",");}return answerContent;}}

4.PracticeDetailDao.java

    /*** 更新练习详情*/int update(PracticeDetailPO practiceDetailPO);

5.PracticeDetailDao.xml

    <update id="update">update practice_detail<set><if test="answerStatus != null">answer_status = #{answerStatus},</if><if test="answerContent != null">answer_content = #{answerContent},</if></set>where id = #{id,jdbcType=BIGINT}</update>

6.req

SubmitSubjectDetailReq.java

package com.sunxiansheng.practice.api.req;import lombok.Data;import java.io.Serializable;
import java.util.List;@Data
public class SubmitSubjectDetailReq implements Serializable {/*** 练习id*/private Long practiceId;/*** 题目id*/private Long subjectId;/*** 题目答案*/private List<Integer> answerContents;/*** 题目类型*/private Integer subjectType;/*** 用时*/private String timeUse;}

7.dto

1.SubjectDetailDTO.java

package com.sunxiansheng.practice.server.entity.dto;import lombok.Data;import java.io.Serializable;
import java.util.List;@Data
public class SubjectDetailDTO implements Serializable {/*** 题目id*/private Long id;/*** 题目名称*/private String subjectName;/*** 判断题答案*/private Integer isCorrect;/*** 题目解析*/private String subjectParse;/*** 单选、多选、判断题目答案*/private List<SubjectOptionDTO> optionList;}

2.SubjectDTO.java

package com.sunxiansheng.practice.server.entity.dto;import lombok.Data;import java.io.Serializable;@Data
public class SubjectDTO implements Serializable {/*** 题目id*/private Long id;/*** 题目id*/private Long subjectId;/*** 题目名称*/private String subjectName;/*** 题目类型*/private Integer subjectType;}

3.SubjectOptionDTO.java

package com.sunxiansheng.practice.server.entity.dto;import lombok.Data;import java.io.Serializable;@Data
public class SubjectOptionDTO implements Serializable {/*** 答案类型*/private Integer optionType;/*** 答案内容*/private String optionContent;/*** 是否为正确答案*/private Integer isCorrect;}

8.测试

1.接口设计

2.db

1.更新提交时间和用时 practice_info

2.练习细节如果有的话就更新记录 practice_detail

3.测试遇到一个bug，即使题目正确也会插入答案状态为0，状态设置的时候有问题

2.答案解析-每题得分

1.GetScoreDetailReq.java

package com.sunxiansheng.practice.api.req;import lombok.Data;import java.io.Serializable;@Data
public class GetScoreDetailReq implements Serializable {/*** 练习id*/private Long practiceId;}

2.ScoreDetailVO.java

package com.sunxiansheng.practice.api.vo;import lombok.Data;import java.io.Serializable;@Data
public class ScoreDetailVO implements Serializable {/*** 题目id*/private Long subjectId;/*** 题目类型*/private Integer subjectType;/*** 是否正确*/private Integer isCorrect;}

3.PracticeDetailController.java

    /*** 答案解析-每题得分*/@PostMapping(value = "/getScoreDetail")public Result<List<ScoreDetailVO>> getScoreDetail(@RequestBody GetScoreDetailReq req) {try {if (log.isInfoEnabled()) {log.info("每题得分入参{}", JSON.toJSONString(req));}Preconditions.checkArgument(!Objects.isNull(req), "参数不能为空！");Preconditions.checkArgument(!Objects.isNull(req.getPracticeId()), "练习id不能为空！");List<ScoreDetailVO> list = practiceDetailService.getScoreDetail(req);if (log.isInfoEnabled()) {log.info("每题得分出参{}", JSON.toJSONString(list));}return Result.ok(list);} catch (IllegalArgumentException e) {log.error("参数异常！错误原因{}", e.getMessage(), e);return Result.fail(e.getMessage());} catch (Exception e) {log.error("每题得分异常！错误原因{}", e.getMessage(), e);return Result.fail("每题得分异常！");}}

4.PracticeDetailService.java

    /*** 每题得分详情*/List<ScoreDetailVO> getScoreDetail(GetScoreDetailReq req);

5.PracticeDetailServiceImpl.java

    @Overridepublic List<ScoreDetailVO> getScoreDetail(GetScoreDetailReq req) {// 获取练习idLong practiceId = req.getPracticeId();// 根据练习id查询题目id，题目类型，题目状态List<PracticeDetailPO> practiceDetailPOList = practiceDetailDao.selectByPracticeId(practiceId);// 判空if (CollectionUtils.isEmpty(practiceDetailPOList)) {return Collections.emptyList();}// 将其map成要返回的结果List<ScoreDetailVO> res = practiceDetailPOList.stream().map(po -> {// 将每一个practiceDetailPO都map成ScoreDetailVOScoreDetailVO scoreDetailVO = new ScoreDetailVO();scoreDetailVO.setSubjectId(po.getSubjectId());scoreDetailVO.setSubjectType(po.getSubjectType());scoreDetailVO.setIsCorrect(po.getAnswerStatus());return scoreDetailVO;}).collect(Collectors.toList());return res;}

6.PracticeDetailDao.xml

    <select id="selectByPracticeId" resultType="com.sunxiansheng.practice.server.entity.po.PracticeDetailPO">select subject_id as subjectId, subject_type as subjectType, answer_status as answerStatusfrom practice_detailwhere practice_id = #{practiceId}and is_deleted = 0</select>

7.测试