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