From 80202ba459f8c11bf62e35832d829bfcfcf0ee48 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 24 三月 2023 09:28:41 +0800
Subject: [PATCH] 1
---
JavaCode/SysTemplate/Mapper.xml | 8 +++-----
ExportMap/Web.config | 3 ++-
2 files changed, 5 insertions(+), 6 deletions(-)
diff --git a/ExportMap/Web.config b/ExportMap/Web.config
index 7ecd34d..9151ed8 100644
--- a/ExportMap/Web.config
+++ b/ExportMap/Web.config
@@ -13,7 +13,8 @@
<add key="sgDB" value="E:\soft\SGConfig\catalog.db"/>
<!-- PG杩炴帴 -->
<!--<add key="pgConn" value="Server=127.0.0.1;Port=5433;Database=langfang;User Id=postgres;Password=postgres;"/>-->
- <add key="pgConn" value="Server=192.168.20.205;Port=5433;Database=langfang;User Id=postgres;Password=Postgres!_14_Lf;"/>
+ <!--<add key="pgConn" value="Server=192.168.20.205;Port=5433;Database=langfang;User Id=postgres;Password=Postgres!_14_Lf;"/>-->
+ <add key="pgConn" value="Server=103.85.165.99;Port=5433;Database=langfang;User Id=postgres;Password=Postgres!_14_Lf;"/>
<add key="webpages:Version" value="3.0.0.0"/>
<add key="webpages:Enabled" value="false"/>
<add key="ClientValidationEnabled" value="true"/>
diff --git a/JavaCode/SysTemplate/Mapper.xml b/JavaCode/SysTemplate/Mapper.xml
index 35fe795..73202d7 100644
--- a/JavaCode/SysTemplate/Mapper.xml
+++ b/JavaCode/SysTemplate/Mapper.xml
@@ -17,12 +17,12 @@
{testWhere}
</if>
</where>
- order by id
+ order by id desc
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="{entityNS}.{entityName}">
- select * from {tabName} order by id;
+ select * from {tabName} order by id desc;
</select>
<select id="selectById" resultType="{entityNS}.{entityName}">
@@ -65,9 +65,7 @@
<update id="updates">
<foreach collection="list" item="item" index="index" separator=";">
update {tabName}
- <set>
- {updateVals}
- </set>
+ set {updateVals}
where id = #{item.id}
</foreach>
</update>
--
Gitblit v1.9.3