From 25d9d2e1a9eaa7c0b098a225dc1fcf149bac7fbe Mon Sep 17 00:00:00 2001
From: 吴学文 <wuxuewen@wuxuewendeMacBook-Pro.local>
Date: 星期一, 08 七月 2019 22:44:12 +0800
Subject: [PATCH] 修改映射管理sql配置 key 加入引号问题
---
java110-db/src/main/resources/mapper/mapping/MappingServiceDaoImplMapper.xml | 9 +++++----
1 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/java110-db/src/main/resources/mapper/mapping/MappingServiceDaoImplMapper.xml b/java110-db/src/main/resources/mapper/mapping/MappingServiceDaoImplMapper.xml
index 4b157d2..6106823 100644
--- a/java110-db/src/main/resources/mapper/mapping/MappingServiceDaoImplMapper.xml
+++ b/java110-db/src/main/resources/mapper/mapping/MappingServiceDaoImplMapper.xml
@@ -7,7 +7,7 @@
<!-- 淇濆瓨鏄犲皠淇℃伅 add by wuxw 2018-07-03 -->
<insert id="saveMappingInfo" parameterType="Map">
insert into c_mapping(
-domain,name,remark,id,value,key
+domain,name,remark,id,value,`key`
) values (
#{domain},#{name},#{remark},#{id},#{value},#{key}
)
@@ -38,7 +38,7 @@
and t.value= #{value}
</if>
<if test="key !=null and key != ''">
- and t.key= #{key}
+ and t.`key`= #{key}
</if>
</select>
@@ -101,7 +101,8 @@
</if>
<if test="key !=null and key != ''">
and t.key= #{key}
-</if>
+</if>
+ order by t.create_time desc
<if test="page != -1 and page != null ">
limit #{page}, #{row}
</if>
@@ -128,7 +129,7 @@
, t.value= #{value}
</if>
<if test="key !=null and key != ''">
-, t.key= #{key}
+, t.`key`= #{key}
</if>
where 1=1 <if test="id !=null and id != ''">
and t.id= #{id}
--
Gitblit v1.8.0