From 68e52d440a946e78f83cc0db5b92f9aa0a949ef0 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 01 八月 2023 21:38:17 +0800
Subject: [PATCH] 1
---
src/main/resources/mapper/data/TaskMapper.xml | 2 +-
src/main/resources/application.yml | 4 ++--
src/main/resources/mapper/data/PublishMapper.xml | 2 +-
3 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 886faff..aa3cbe2 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -42,8 +42,8 @@
datasource:
name: prod
# JDBC 鍩烘湰閰嶇疆 ¤tSchema=public
- #url: jdbc:postgresql://103.85.165.99:5433/langfang?useAffectedRows=true
- url: jdbc:postgresql://192.168.20.205:5433/langfang?useAffectedRows=true
+ url: jdbc:postgresql://103.85.165.99:5433/langfang?useAffectedRows=true
+ #url: jdbc:postgresql://192.168.20.205:5433/langfang?useAffectedRows=true
#url: jdbc:postgresql://127.0.0.1:5433/langfang?useAffectedRows=true
username : postgres
password: Postgres!_14_Lf
diff --git a/src/main/resources/mapper/data/PublishMapper.xml b/src/main/resources/mapper/data/PublishMapper.xml
index d46b0e6..00dec42 100644
--- a/src/main/resources/mapper/data/PublishMapper.xml
+++ b/src/main/resources/mapper/data/PublishMapper.xml
@@ -76,7 +76,7 @@
and ${type}
</if>
</where>
- order by a.update_time desc, a.create_time desc
+ order by a.create_time desc
limit #{limit} offset #{offset}
</select>
diff --git a/src/main/resources/mapper/data/TaskMapper.xml b/src/main/resources/mapper/data/TaskMapper.xml
index 55b568d..26fc647 100644
--- a/src/main/resources/mapper/data/TaskMapper.xml
+++ b/src/main/resources/mapper/data/TaskMapper.xml
@@ -32,7 +32,7 @@
and type = #{type}
</if>
</where>
- order by a.update_time desc, a.create_time desc
+ order by a.create_time desc
limit #{limit} offset #{offset}
</select>
--
Gitblit v1.9.3