查询考试绑定的对应题目

zengh

2021-07-18 0562ec1e83520d3a0fea4a61dca7e259a9c51da7

查询考试绑定的对应题目

 src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java

@@ -137,4 +137,13 @@
        return R.data(detail);
    }

    /**
     * 查询试卷包含的题目
     */
    @GetMapping("/getEexPaperChoices")
    public R<IPage<ExamSubjectChoicesVO>> getEexPaperChoices(ExamSubjectChoicesVO examSubjectChoices, Query query) {
        IPage<ExamSubjectChoicesVO> pages = examSubjectChoicesService.getEexPaperChoices(Condition.getPage(query), examSubjectChoices);
        return R.data(pages);
    }

}

 src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java

@@ -25,6 +25,14 @@
    List<ExamSubjectChoicesVO> selectExamSubjectChoicesPage(IPage page, @Param("examSubjectChoices") ExamSubjectChoicesVO examSubjectChoices);

    /**
     * 查询试卷题目
     * @param page
     * @param examSubjectChoices
     * @return
     */
    List<ExamSubjectChoicesVO> getEexPaperChoices(IPage page, ExamSubjectChoicesVO examSubjectChoices);

    /**
     * 详情
     *
     * @param examSubjectChoices 选择题信息对象

 src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml

@@ -18,6 +18,20 @@
        </if>
    </select>

    <!--查询试卷绑定的题目-->
    <select id="getEexPaperChoices" resultType="org.springblade.modules.exam.vo.ExamSubjectChoicesVO">
        SELECT
            esc.*
        FROM
            exam_subject_choices esc
        LEFT JOIN exam_examination_subject exa ON esc.id = exa.subject_id
        WHERE
            1=1
        <if test="examSubjectChoices.id!=null and  examSubjectChoices.id!=''">
            and exa.examination_id = #{examSubjectChoices.id}
        </if>
    </select>


    <!--ExamSubjectChoicesInfoMap 多表联查 一对多查询 -->
    <resultMap id="ExamSubjectChoicesInfoMap" type="org.springblade.modules.exam.vo.ExamSubjectChoicesVO">

 src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java

@@ -20,6 +20,14 @@
    IPage<ExamSubjectChoicesVO> selectExamSubjectChoicesPage(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices);

    /**
     * 查询试卷题目
     * @param page
     * @param examSubjectChoices
     * @return
     */
    IPage<ExamSubjectChoicesVO> getEexPaperChoices(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices);

    /**
     * 详情
     * @param examSubjectChoices 选择题信息对象
     */

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

@@ -21,6 +21,11 @@
        return page.setRecords(baseMapper.selectExamSubjectChoicesPage(page, examSubjectChoices));
    }

    @Override
    public IPage<ExamSubjectChoicesVO> getEexPaperChoices(IPage<ExamSubjectChoicesVO> page, ExamSubjectChoicesVO examSubjectChoices) {
        return page.setRecords(baseMapper.getEexPaperChoices(page, examSubjectChoices));
    }

    /**
     * 详情
     * @param examSubjectChoices 选择题信息对象