From 4d3dc99a8ec98e18609f2dca23a6a28fd25069fc Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 23 十月 2024 16:55:27 +0800
Subject: [PATCH] 用户查询优化
---
src/main/java/com/ycl/jxkg/domain/vo/admin/user/UserPageRequestVO.java | 2 +-
src/main/resources/mapper/UserMapper.xml | 4 ++--
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/ycl/jxkg/domain/vo/admin/user/UserPageRequestVO.java b/src/main/java/com/ycl/jxkg/domain/vo/admin/user/UserPageRequestVO.java
index 3d1e96d..509b1ec 100644
--- a/src/main/java/com/ycl/jxkg/domain/vo/admin/user/UserPageRequestVO.java
+++ b/src/main/java/com/ycl/jxkg/domain/vo/admin/user/UserPageRequestVO.java
@@ -6,7 +6,7 @@
@Data
public class UserPageRequestVO extends BasePage {
- private String userName;
+ private String realName;
private Integer role;
diff --git a/src/main/resources/mapper/UserMapper.xml b/src/main/resources/mapper/UserMapper.xml
index 8fc4b07..90ede01 100644
--- a/src/main/resources/mapper/UserMapper.xml
+++ b/src/main/resources/mapper/UserMapper.xml
@@ -100,8 +100,8 @@
FROM t_user
<where>
and deleted=0
- <if test="userName != null and userName != ''">
- and user_name like concat('%',#{userName},'%')
+ <if test="realName != null and realName != ''">
+ and real_name like concat('%',#{realName},'%')
</if>
<if test="role != null ">
and role= #{role}
--
Gitblit v1.8.0