From 4d2b88284dae05b7acb2134b4ddbbd11b1586952 Mon Sep 17 00:00:00 2001 From: luohairen <3399054449@qq.com> Date: 星期四, 31 十月 2024 15:09:22 +0800 Subject: [PATCH] 优化题目查询 --- src/main/resources/mapper/QuestionMapper.xml | 3 +++ src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java | 2 ++ src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java | 2 ++ 3 files changed, 7 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java b/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java index 06e0450..e05f891 100644 --- a/src/main/java/com/ycl/jxkg/controller/admin/QuestionController.java +++ b/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(); diff --git a/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java b/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java index 7a3eefe..fc34d2c 100644 --- a/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java +++ b/src/main/java/com/ycl/jxkg/domain/vo/admin/question/QuestionPageRequestVO.java @@ -19,4 +19,6 @@ private String content; + private String title; + } diff --git a/src/main/resources/mapper/QuestionMapper.xml b/src/main/resources/mapper/QuestionMapper.xml index 59076e6..69b64af 100644 --- a/src/main/resources/mapper/QuestionMapper.xml +++ b/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> -- Gitblit v1.8.0