优化题目查询

luohairen

2024-10-31 4d2b88284dae05b7acb2134b4ddbbd11b1586952

优化题目查询

 src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java

@@ -32,6 +32,8 @@

    @RequestMapping(value = "/page", method = RequestMethod.POST)
    public Result<PageInfo<QuestionResponseVO>> pageList(@RequestBody QuestionPageRequestVO model) {
        model.setTitle(model.getContent());
        model.setContent(null);
        PageInfo<QuestionResponseVO> pageInfo = questionService.page(model);
        PageInfo<QuestionResponseVO> page = PageInfoHelper.copyMap(pageInfo, q -> {
            QuestionResponseVO vo = new QuestionResponseVO();

 src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java

@@ -19,4 +19,6 @@

    private String content;

    private String title;

}

 src/main/resources/mapper/QuestionMapper.xml

@@ -56,6 +56,9 @@
            <if test="content != null and content != ''">
                and instr(tq.content, #{content})
            </if>
            <if test="title != null and title != ''">
                and title like CONCAT('%', #{title}, '%')
            </if>
        </where>
    </select>