From 6605f552718a6c6b27ddd6bcf9b4adfe2816686f Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期四, 09 二月 2023 17:44:51 +0800
Subject: [PATCH] fix(quartz): 111
---
src/main/java/com/integrated/zyyt/service/ZyytService.java | 120 ++++++++++++++++++++++++++++++-----------------------------
1 files changed, 61 insertions(+), 59 deletions(-)
diff --git a/src/main/java/com/integrated/zyyt/service/ZyytService.java b/src/main/java/com/integrated/zyyt/service/ZyytService.java
index d209d64..bac63d1 100644
--- a/src/main/java/com/integrated/zyyt/service/ZyytService.java
+++ b/src/main/java/com/integrated/zyyt/service/ZyytService.java
@@ -86,65 +86,68 @@
StationInfo stationInfo = stationInfoListCopy.get(i);
// log.info("stationInfo==> {}", JSON.toJSONString(stationInfo));
- ps.setObject(1, stationInfo.getVJgbh());
+ ps.setString(1, stationInfo.getVJgbh());
- ps.setObject(2, stationInfo.getVSfmc());
- ps.setObject(3, stationInfo.getVSfdm());
- ps.setObject(4, stationInfo.getVDsdm());
- ps.setObject(5, stationInfo.getVDsmc());
- ps.setObject(6, stationInfo.getVQxdm());
- ps.setObject(7, stationInfo.getVXsmc());
- ps.setObject(8, stationInfo.getVTdjgbh());
- ps.setObject(9, stationInfo.getVTdjgmc());
- ps.setObject(10, stationInfo.getVJgmc());
- ps.setObject(11, stationInfo.getVLxrxm());
- ps.setObject(12, stationInfo.getVLxdh());
- ps.setObject(13, stationInfo.getVSjhm());
- ps.setObject(14, stationInfo.getVLxdz());
- ps.setObject(15, stationInfo.getIscountry());
- ps.setObject(16, stationInfo.getCWdlx());
- ps.setObject(17, stationInfo.getCYzbm());
- ps.setObject(18, stationInfo.getVYywdbh());
- ps.setObject(19, stationInfo.getVYywdmc());
- ps.setObject(20, stationInfo.getVGpsjd());
- ps.setObject(21, stationInfo.getVGpswd());
- ps.setObject(22, stationInfo.getYlgzdid());
- ps.setObject(23, stationInfo.getYlgzdmc());
- ps.setObject(24, stationInfo.getVStatus());
- ps.setDate(25, new Date(stationInfo.getDSqrq().getTime()));
-// ps.setObject(25, stationInfo.getDSqrq());
-// ps.setObject(26, stationInfo.getDSprq());
- ps.setDate(26, new Date(stationInfo.getDSprq().getTime()));
+ ps.setString(2, stationInfo.getVSfmc());
+ ps.setString(3, stationInfo.getVSfdm());
+ ps.setString(4, stationInfo.getVDsdm());
+ ps.setString(5, stationInfo.getVDsmc());
+ ps.setString(6, stationInfo.getVQxdm());
+ ps.setString(7, stationInfo.getVXsmc());
+ ps.setString(8, stationInfo.getVTdjgbh());
+ ps.setString(9, stationInfo.getVTdjgmc());
+ ps.setString(10, stationInfo.getVJgmc());
+ ps.setString(11, stationInfo.getVLxrxm());
+ ps.setString(12, stationInfo.getVLxdh());
+ ps.setString(13, stationInfo.getVSjhm());
+ ps.setString(14, stationInfo.getVLxdz());
+ ps.setString(15, stationInfo.getIscountry());
+ ps.setShort(16, stationInfo.getCWdlx());
+ ps.setString(17, stationInfo.getCYzbm());
+ ps.setString(18, stationInfo.getVYywdbh());
+ ps.setString(19, stationInfo.getVYywdmc());
+ ps.setString(20, stationInfo.getVGpsjd());
+ ps.setString(21, stationInfo.getVGpswd());
+ ps.setString(22, stationInfo.getYlgzdid());
+ ps.setString(23, stationInfo.getYlgzdmc());
+ ps.setString(24, stationInfo.getVStatus());
+// ps.setDate(25, new Date(stationInfo.getDSqrq().getTime()));
+ ps.setDate(25,
+ stationInfo.getDSqrq() == null ? null :
+ new Date(stationInfo.getDSqrq().getTime()));
+// ps.setString(25, stationInfo.getDSqrq());
+// ps.setString(26, stationInfo.getDSprq());
+ ps.setDate(26, stationInfo.getDSprq() == null ? null :
+ new Date(stationInfo.getDSprq().getTime()));
- ps.setObject(27, stationInfo.getVSfmc());
- ps.setObject(28, stationInfo.getVSfdm());
- ps.setObject(29, stationInfo.getVDsdm());
- ps.setObject(30, stationInfo.getVDsmc());
- ps.setObject(31, stationInfo.getVQxdm());
- ps.setObject(32, stationInfo.getVXsmc());
- ps.setObject(33, stationInfo.getVTdjgbh());
- ps.setObject(34, stationInfo.getVTdjgmc());
- ps.setObject(35, stationInfo.getVJgbh());
- ps.setObject(36, stationInfo.getVJgmc());
- ps.setObject(37, stationInfo.getVLxrxm());
- ps.setObject(38, stationInfo.getVLxdh());
- ps.setObject(39, stationInfo.getVSjhm());
- ps.setObject(40, stationInfo.getVLxdz());
- ps.setObject(41, stationInfo.getIscountry());
- ps.setObject(42, stationInfo.getCWdlx());
- ps.setObject(43, stationInfo.getCYzbm());
- ps.setObject(44, stationInfo.getVYywdbh());
- ps.setObject(45, stationInfo.getVYywdmc());
- ps.setObject(46, stationInfo.getVGpsjd());
- ps.setObject(47, stationInfo.getVGpswd());
- ps.setObject(48, stationInfo.getYlgzdid());
- ps.setObject(49, stationInfo.getYlgzdmc());
- ps.setObject(50, stationInfo.getVStatus());
-// ps.setObject(51, stationInfo.getDSqrq());
- ps.setDate(51, new Date(stationInfo.getDSqrq().getTime()));
+ ps.setString(27, stationInfo.getVSfmc());
+ ps.setString(28, stationInfo.getVSfdm());
+ ps.setString(29, stationInfo.getVDsdm());
+ ps.setString(30, stationInfo.getVDsmc());
+ ps.setString(31, stationInfo.getVQxdm());
+ ps.setString(32, stationInfo.getVXsmc());
+ ps.setString(33, stationInfo.getVTdjgbh());
+ ps.setString(34, stationInfo.getVTdjgmc());
+ ps.setString(35, stationInfo.getVJgbh());
+ ps.setString(36, stationInfo.getVJgmc());
+ ps.setString(37, stationInfo.getVLxrxm());
+ ps.setString(38, stationInfo.getVLxdh());
+ ps.setString(39, stationInfo.getVSjhm());
+ ps.setString(40, stationInfo.getVLxdz());
+ ps.setString(41, stationInfo.getIscountry());
+ ps.setShort(42, stationInfo.getCWdlx());
+ ps.setString(43, stationInfo.getCYzbm());
+ ps.setString(44, stationInfo.getVYywdbh());
+ ps.setString(45, stationInfo.getVYywdmc());
+ ps.setString(46, stationInfo.getVGpsjd());
+ ps.setString(47, stationInfo.getVGpswd());
+ ps.setString(48, stationInfo.getYlgzdid());
+ ps.setString(49, stationInfo.getYlgzdmc());
+ ps.setString(50, stationInfo.getVStatus());
+// ps.setString(51, stationInfo.getDSqrq());
+ ps.setDate(51, stationInfo.getDSqrq() == null ? null : new Date(stationInfo.getDSqrq().getTime()));
- ps.setObject(52, stationInfo.getDSprq());
- ps.setDate(52, new Date(stationInfo.getDSprq().getTime()));
+ ps.setDate(52, stationInfo.getDSprq() == null ? null : new Date(stationInfo.getDSprq().getTime()));
}
@Override
@@ -279,8 +282,7 @@
item.getReserved2(),
item.getReserved3(),
item.getReserved4(),
- item.getBatchNo()
- });
+ batchNo});
});
jdbcTemplate.batchUpdate(batchInsertSql, insertShkdrbList);
} catch (Exception e) {
@@ -376,7 +378,7 @@
item.getNSjzje(),
item.getNTksr(),
item.getNBksr(),
- item.getBatchNo()
+ batchNo
});
});
jdbcTemplate.batchUpdate(batchInsertSql, insertShkdrbList);
--
Gitblit v1.9.1