From 42f43646d73c7e573c52a782f72a78cc53bc5ab3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 24 三月 2023 09:41:53 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/data/DownloadMapper.xml | 2 +-
src/main/resources/mapper/show/PublishMapper.xml | 6 +++---
src/main/resources/mapper/sys/MetaDownMapper.xml | 4 ++--
src/main/resources/mapper/sys/MsgMapper.xml | 4 ++--
src/main/resources/mapper/sys/ResOpMapper.xml | 4 ++--
src/main/resources/mapper/show/ModelMapper.xml | 4 ++--
src/main/resources/mapper/sys/LayerMapper.xml | 4 +++-
src/main/resources/mapper/sys/AttachMapper.xml | 4 ++--
8 files changed, 17 insertions(+), 15 deletions(-)
diff --git a/src/main/resources/mapper/data/DownloadMapper.xml b/src/main/resources/mapper/data/DownloadMapper.xml
index da81a01..6d5eac0 100644
--- a/src/main/resources/mapper/data/DownloadMapper.xml
+++ b/src/main/resources/mapper/data/DownloadMapper.xml
@@ -44,7 +44,7 @@
</select>
<select id="selectAll" resultType="com.lf.server.entity.data.DownloadEntity">
- select * from lf.sys_download order by id;
+ select * from lf.sys_download order by id desc;
</select>
<select id="selectById" resultType="com.lf.server.entity.data.DownloadEntity">
diff --git a/src/main/resources/mapper/show/ModelMapper.xml b/src/main/resources/mapper/show/ModelMapper.xml
index 7eafbe6..a2f69c2 100644
--- a/src/main/resources/mapper/show/ModelMapper.xml
+++ b/src/main/resources/mapper/show/ModelMapper.xml
@@ -17,12 +17,12 @@
layerid = #{layerid}
</if>
</where>
- order by id
+ order by id desc
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="com.lf.server.entity.show.ModelEntity">
- select * from lf.sys_model order by id;
+ select * from lf.sys_model order by id desc;
</select>
<select id="selectById" resultType="com.lf.server.entity.show.ModelEntity">
diff --git a/src/main/resources/mapper/show/PublishMapper.xml b/src/main/resources/mapper/show/PublishMapper.xml
index 3e56c00..e1e74a6 100644
--- a/src/main/resources/mapper/show/PublishMapper.xml
+++ b/src/main/resources/mapper/show/PublishMapper.xml
@@ -62,12 +62,12 @@
upper(name) like #{name}
</if>
</where>
- order by id
+ order by id desc
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="com.lf.server.entity.data.PublishEntity">
- select * from lf.sys_publish order by id;
+ select * from lf.sys_publish order by id desc;
</select>
<select id="selectById" resultType="com.lf.server.entity.data.PublishEntity">
@@ -77,7 +77,7 @@
</select>
<select id="selectByIds" resultType="com.lf.server.entity.data.PublishEntity">
- select * from lf.sys_publish where id in (${ids});
+ select * from lf.sys_publish where id in (${ids}) order by id desc;
</select>
<insert id="insert" parameterType="com.lf.server.entity.data.PublishEntity">
diff --git a/src/main/resources/mapper/sys/AttachMapper.xml b/src/main/resources/mapper/sys/AttachMapper.xml
index 637fb48..d38fb6d 100644
--- a/src/main/resources/mapper/sys/AttachMapper.xml
+++ b/src/main/resources/mapper/sys/AttachMapper.xml
@@ -17,12 +17,12 @@
upper(name) like #{name}
</if>
</where>
- order by id
+ order by id desc
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="com.lf.server.entity.sys.AttachEntity">
- select * from lf.sys_attach order by id;
+ select * from lf.sys_attach order by id desc;
</select>
<select id="selectById" resultType="com.lf.server.entity.sys.AttachEntity">
diff --git a/src/main/resources/mapper/sys/LayerMapper.xml b/src/main/resources/mapper/sys/LayerMapper.xml
index 429625b..12106fc 100644
--- a/src/main/resources/mapper/sys/LayerMapper.xml
+++ b/src/main/resources/mapper/sys/LayerMapper.xml
@@ -22,7 +22,9 @@
</select>
<select id="selectAll" resultType="com.lf.server.entity.sys.LayerEntity">
- select (select ns from lf.sys_dict b where b.field = 'gid' and b.tab = a.en_name) "ns", a.* from lf.sys_layer a order by id;
+ select (select ns from lf.sys_dict b where b.field = 'gid' and b.tab = a.en_name) "ns", a.*
+ from lf.sys_layer a
+ order by id;
</select>
<select id="selectById" resultType="com.lf.server.entity.sys.LayerEntity">
diff --git a/src/main/resources/mapper/sys/MetaDownMapper.xml b/src/main/resources/mapper/sys/MetaDownMapper.xml
index e1c5c49..c64a5e2 100644
--- a/src/main/resources/mapper/sys/MetaDownMapper.xml
+++ b/src/main/resources/mapper/sys/MetaDownMapper.xml
@@ -17,12 +17,12 @@
metaid = #{metaid}
</if>
</where>
- order by id
+ order by id desc
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="com.lf.server.entity.sys.MetaDownEntity">
- select * from lf.sys_meta_down order by id;
+ select * from lf.sys_meta_down order by id desc;
</select>
<select id="selectById" resultType="com.lf.server.entity.sys.MetaDownEntity">
diff --git a/src/main/resources/mapper/sys/MsgMapper.xml b/src/main/resources/mapper/sys/MsgMapper.xml
index 9703938..96a47fa 100644
--- a/src/main/resources/mapper/sys/MsgMapper.xml
+++ b/src/main/resources/mapper/sys/MsgMapper.xml
@@ -17,12 +17,12 @@
upper(title) like #{title}
</if>
</where>
- order by id
+ order by id desc
limit #{limit} offset #{offset}
</select>
<select id="selectAll" resultType="com.lf.server.entity.sys.MsgEntity">
- select * from lf.sys_msg order by id;
+ select * from lf.sys_msg order by id desc;
</select>
<select id="selectById" resultType="com.lf.server.entity.sys.MsgEntity">
diff --git a/src/main/resources/mapper/sys/ResOpMapper.xml b/src/main/resources/mapper/sys/ResOpMapper.xml
index 1712ddc..da98015 100644
--- a/src/main/resources/mapper/sys/ResOpMapper.xml
+++ b/src/main/resources/mapper/sys/ResOpMapper.xml
@@ -37,12 +37,12 @@
and a.optime <= #{end}
</if>
</where>
- order by a.id
+ order by a.id desc
limit #{limit} offset #{offset}
</select>
<select id="selectResOpAll" resultType="com.lf.server.entity.sys.ResOpEntity">
- select * from lf.sys_res_op order by id;
+ select * from lf.sys_res_op order by id desc;
</select>
<select id="selectResOp" resultType="com.lf.server.entity.sys.ResOpEntity">
--
Gitblit v1.9.3