From 5f800e667f66b912b1ae984269a0d4c3c0258fa9 Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期二, 19 一月 2021 16:41:48 +0800
Subject: [PATCH] bug
---
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
index f0f7215..df667b6 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
@@ -107,8 +107,10 @@
"u.user_id,\n" +
"u.account,\n" +
"u.`name`,\n" +
+ "u.`password`,\n" +
"u.phone,\n" +
"e.role_name,\n" +
+ "e.role_id ,\n" +
"u.`status`,\n" +
"u.create_at,\n" +
"u.last_login_time \n" +
@@ -124,13 +126,13 @@
"AND u.community_id = #{administratorsUserVO.communityId} \n" +
" </if> " +
"<if test='administratorsUserVO.name != null and administratorsUserVO.name.trim() != ""'>" +
- "AND u.name = #{administratorsUserVO.name} \n" +
+ "AND u.name like concat (#{administratorsUserVO.name},'%') \n" +
" </if> " +
"<if test='administratorsUserVO.phone != null and administratorsUserVO.phone.trim() != ""'>" +
- "AND u.phone = #{administratorsUserVO.phone}" +
+ "AND u.phone like concat(#{administratorsUserVO.phone},'%') " +
" </if> " +
"<if test='administratorsUserVO.account != null and administratorsUserVO.account.trim() != ""'>" +
- "AND u.account = #{administratorsUserVO.account}" +
+ "AND u.account like concat(#{administratorsUserVO.account},'%') " +
" </if> " +
" </where>" +
"</script>")
--
Gitblit v1.7.1