From 47a3d00f047369c9102dc1836f4f57a2257df821 Mon Sep 17 00:00:00 2001
From: liriming <1343021927@qq.com>
Date: 星期四, 19 六月 2025 15:28:32 +0800
Subject: [PATCH] syncEmsTask修改
---
ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java | 16 ++++++++++------
1 files changed, 10 insertions(+), 6 deletions(-)
diff --git a/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java b/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java
index 253c87d..e133291 100644
--- a/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java
+++ b/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/SyncEmsTask.java
@@ -57,12 +57,10 @@
// 执行查询并处理结果
ResultSet rs = pstmt.executeQuery();
- boolean colCount = rs.next();
- if(!colCount){
+ if(!rs.isBeforeFirst()){
pstmt.setString(1, lastMonth);
rs = pstmt.executeQuery();
- colCount = rs.next();
- if(!colCount){
+ if(!rs.isBeforeFirst()){
pstmt.setString(1, upMonth);
rs = pstmt.executeQuery();
remark = "上月数据为空，同步上上月数据成功";
@@ -71,7 +69,7 @@
}
}
byqlzAdsService.delete(yearMonth);
- while (colCount) {
+ while (rs.next()) {
ByqlzAdsEntity entity = new ByqlzAdsEntity();
// 映射基础字段
@@ -131,11 +129,17 @@
syncLogService.save(remark);
// 输出结果
resultList.forEach(System.out::println);
-
+ resultList.clear();
} catch (SQLException e) {
logger.error("SyncEmsTask运行异常");
e.printStackTrace();
}
logger.info("SyncEmsTask运行完成");
}
+
+ public static void main(String[] args) {
+ SyncEmsTask syncEmsTask = new SyncEmsTask();
+ String params = "";
+ syncEmsTask.run(params);
+ }
}
--
Gitblit v1.9.3