From fb7ede83b597d7e22166423cc821d8a0dd4ac5b9 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 20 三月 2023 18:04:24 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/sys/OperateMapper.xml | 4 ++--
src/main/resources/mapper/sys/MsgMapper.xml | 4 ++--
src/main/resources/mapper/sys/ReportMapper.xml | 4 ++--
src/main/resources/mapper/sys/LayerMapper.xml | 4 ++--
src/main/resources/mapper/sys/ResMapper.xml | 4 ++--
src/main/resources/mapper/sys/DownlogMapper.xml | 4 ++--
src/main/resources/mapper/sys/BlacklistMapper.xml | 4 ++--
src/main/resources/mapper/sys/ResOpMapper.xml | 4 ++--
src/main/resources/mapper/sys/RoleMapper.xml | 4 ++--
src/main/resources/mapper/sys/ArgsMapper.xml | 4 ++--
src/main/resources/mapper/sys/AttachMapper.xml | 4 ++--
src/main/resources/mapper/sys/UserMapper.xml | 8 ++++----
src/main/resources/mapper/sys/LoginMapper.xml | 4 ++--
13 files changed, 28 insertions(+), 28 deletions(-)
diff --git a/src/main/resources/mapper/sys/ArgsMapper.xml b/src/main/resources/mapper/sys/ArgsMapper.xml
index 3fda786..7416549 100644
--- a/src/main/resources/mapper/sys/ArgsMapper.xml
+++ b/src/main/resources/mapper/sys/ArgsMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_args
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
</select>
@@ -14,7 +14,7 @@
select * from lf.sys_args
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
order by id
diff --git a/src/main/resources/mapper/sys/AttachMapper.xml b/src/main/resources/mapper/sys/AttachMapper.xml
index 0e8d504..637fb48 100644
--- a/src/main/resources/mapper/sys/AttachMapper.xml
+++ b/src/main/resources/mapper/sys/AttachMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_attach
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
</select>
@@ -14,7 +14,7 @@
select * from lf.sys_attach
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
order by id
diff --git a/src/main/resources/mapper/sys/BlacklistMapper.xml b/src/main/resources/mapper/sys/BlacklistMapper.xml
index 94817cb..e249adb 100644
--- a/src/main/resources/mapper/sys/BlacklistMapper.xml
+++ b/src/main/resources/mapper/sys/BlacklistMapper.xml
@@ -6,7 +6,7 @@
<where>
1 = 1
<if test="ip != null">
- and ip like #{ip}
+ and upper(ip) like #{ip}
</if>
<if test="type != null">
and type = #{type}
@@ -19,7 +19,7 @@
<where>
1 = 1
<if test="ip != null">
- and a.ip like #{ip}
+ and upper(a.ip) like #{ip}
</if>
<if test="type != null">
and a.type = #{type}
diff --git a/src/main/resources/mapper/sys/DownlogMapper.xml b/src/main/resources/mapper/sys/DownlogMapper.xml
index 7c4bba9..3eb448d 100644
--- a/src/main/resources/mapper/sys/DownlogMapper.xml
+++ b/src/main/resources/mapper/sys/DownlogMapper.xml
@@ -7,7 +7,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="type != null">
and c.type = #{type}
@@ -27,7 +27,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="type != null">
and c.type = #{type}
diff --git a/src/main/resources/mapper/sys/LayerMapper.xml b/src/main/resources/mapper/sys/LayerMapper.xml
index 131a006..429625b 100644
--- a/src/main/resources/mapper/sys/LayerMapper.xml
+++ b/src/main/resources/mapper/sys/LayerMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_layer
<where>
<if test="cnName != null">
- cn_name like #{cnName}
+ upper(cn_name) like #{cnName}
</if>
</where>
</select>
@@ -14,7 +14,7 @@
select * from lf.sys_layer
<where>
<if test="cnName != null">
- cn_name like #{cnName}
+ upper(cn_name) like #{cnName}
</if>
</where>
order by id
diff --git a/src/main/resources/mapper/sys/LoginMapper.xml b/src/main/resources/mapper/sys/LoginMapper.xml
index c9e4c22..4f96ef3 100644
--- a/src/main/resources/mapper/sys/LoginMapper.xml
+++ b/src/main/resources/mapper/sys/LoginMapper.xml
@@ -6,7 +6,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="type != null">
and a.type = #{type}
@@ -25,7 +25,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="type != null">
and a.type = #{type}
diff --git a/src/main/resources/mapper/sys/MsgMapper.xml b/src/main/resources/mapper/sys/MsgMapper.xml
index deec613..9703938 100644
--- a/src/main/resources/mapper/sys/MsgMapper.xml
+++ b/src/main/resources/mapper/sys/MsgMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_msg
<where>
<if test="title != null">
- title like #{title}
+ upper(title) like #{title}
</if>
</where>
</select>
@@ -14,7 +14,7 @@
select * from lf.sys_msg
<where>
<if test="title != null">
- title like #{title}
+ upper(title) like #{title}
</if>
</where>
order by id
diff --git a/src/main/resources/mapper/sys/OperateMapper.xml b/src/main/resources/mapper/sys/OperateMapper.xml
index 974a8f1..6967215 100644
--- a/src/main/resources/mapper/sys/OperateMapper.xml
+++ b/src/main/resources/mapper/sys/OperateMapper.xml
@@ -6,7 +6,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="type != null">
and a.type = #{type}
@@ -25,7 +25,7 @@
<where>
1 = 1
<if test="uname != null">
- and b.uname like #{uname}
+ and upper(b.uname) like #{uname}
</if>
<if test="type != null">
and a.type = #{type}
diff --git a/src/main/resources/mapper/sys/ReportMapper.xml b/src/main/resources/mapper/sys/ReportMapper.xml
index 05118c6..6ef778a 100644
--- a/src/main/resources/mapper/sys/ReportMapper.xml
+++ b/src/main/resources/mapper/sys/ReportMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_report
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
<if test="code != null">
code = #{code}
@@ -17,7 +17,7 @@
select a.*,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName from lf.sys_report a
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
<if test="code != null">
code = #{code}
diff --git a/src/main/resources/mapper/sys/ResMapper.xml b/src/main/resources/mapper/sys/ResMapper.xml
index 36ab74f..ee92178 100644
--- a/src/main/resources/mapper/sys/ResMapper.xml
+++ b/src/main/resources/mapper/sys/ResMapper.xml
@@ -5,7 +5,7 @@
select count(*) from lf.sys_res
<where>
<if test="name != null">
- name like #{name}
+ upper(name) like #{name}
</if>
</where>
</select>
@@ -14,7 +14,7 @@
select a.*,fn_rec_query(a.depid, 'dep') depName,fn_rec_query(a.dirid, 'dir') dirName,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName from lf.sys_res a
<where>
<if test="name != null">
- a.name like #{name}
+ upper(a.name) like #{name}
</if>
</where>
order by a.id desc
diff --git a/src/main/resources/mapper/sys/ResOpMapper.xml b/src/main/resources/mapper/sys/ResOpMapper.xml
index 4c6a950..1712ddc 100644
--- a/src/main/resources/mapper/sys/ResOpMapper.xml
+++ b/src/main/resources/mapper/sys/ResOpMapper.xml
@@ -6,7 +6,7 @@
<where>
1 = 1
<if test="name != null">
- and c.name like #{name}
+ and upper(c.name) like #{name}
</if>
<if test="type != null">
and a.type = #{type}
@@ -25,7 +25,7 @@
<where>
1 = 1
<if test="name != null">
- and c.name like #{name}
+ and upper(c.name) like #{name}
</if>
<if test="type != null">
and a.type = #{type}
diff --git a/src/main/resources/mapper/sys/RoleMapper.xml b/src/main/resources/mapper/sys/RoleMapper.xml
index 0f42df9..34d6b54 100644
--- a/src/main/resources/mapper/sys/RoleMapper.xml
+++ b/src/main/resources/mapper/sys/RoleMapper.xml
@@ -6,7 +6,7 @@
<where>
1=1
<if test="name != null">
- and a.name like #{name}
+ and upper(a.name) like #{name}
</if>
<if test="depid != null">
and a.depid = #{depid}
@@ -20,7 +20,7 @@
<where>
1=1
<if test="name != null">
- and a.name like #{name}
+ and upper(a.name) like #{name}
</if>
<if test="depid != null">
and a.depid = #{depid}
diff --git a/src/main/resources/mapper/sys/UserMapper.xml b/src/main/resources/mapper/sys/UserMapper.xml
index 2d1bf33..a2d2451 100644
--- a/src/main/resources/mapper/sys/UserMapper.xml
+++ b/src/main/resources/mapper/sys/UserMapper.xml
@@ -15,7 +15,7 @@
<where>
1 = 1
<if test="uname != null">
- and uname like #{uname}
+ and upper(uname) like #{uname}
</if>
<if test="depcode != null">
and depcode like #{depcode}
@@ -28,7 +28,7 @@
<where>
1 = 1
<if test="uname != null">
- and uname like #{uname}
+ and upper(uname) like #{uname}
</if>
<if test="depcode != null">
and depcode like #{depcode}
@@ -47,7 +47,7 @@
</if>
)
<if test="uname != null">
- and a.uname like #{uname}
+ and upper(a.uname) like #{uname}
</if>
<if test="depcode != null">
and depcode like #{depcode}
@@ -64,7 +64,7 @@
</if>
)
<if test="uname != null">
- and a.uname like #{uname}
+ and upper(a.uname) like #{uname}
</if>
<if test="depcode != null">
and depcode like #{depcode}
--
Gitblit v1.9.3