From e1d4efc4dba2849965bac02939592fe10d60d2c8 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 10 六月 2023 17:10:37 +0800
Subject: [PATCH] 解决dlg_resnt2000入库失败
---
src/main/java/com/lf/server/entity/all/StaticData.java | 2 ++
src/main/java/com/lf/server/service/data/UploadService.java | 5 ++---
data/db_cx.sql | 4 +++-
3 files changed, 7 insertions(+), 4 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 7ea959a..14933a3 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -50,8 +50,10 @@
select * from bs.s_explorationpoint where createtime < '2023-05-26 10:00:00';
select * from bs.s_surveyworksite where createtime < '2023-05-26 10:00:00';
select * from lf.sys_meta where type='cpt';
+select id,name,code from lf.sys_dir where pid=0 order by code
-
+select * from bs.dlg_resnt2000;
+alter table bs.dlg_resnt2000 alter column floors type varchar(20);
diff --git a/src/main/java/com/lf/server/entity/all/StaticData.java b/src/main/java/com/lf/server/entity/all/StaticData.java
index 336706a..3d389ca 100644
--- a/src/main/java/com/lf/server/entity/all/StaticData.java
+++ b/src/main/java/com/lf/server/entity/all/StaticData.java
@@ -44,6 +44,8 @@
public static final int I31 = 31;
+ public static final int I50 = 50;
+
public static final int I60 = 60;
public static final int I90 = 90;
diff --git a/src/main/java/com/lf/server/service/data/UploadService.java b/src/main/java/com/lf/server/service/data/UploadService.java
index 12a4530..3a39ba3 100644
--- a/src/main/java/com/lf/server/service/data/UploadService.java
+++ b/src/main/java/com/lf/server/service/data/UploadService.java
@@ -250,9 +250,8 @@
*/
private <T> int batchInserts(BasicMapper basicMapper, List<T> list) {
int rows = 0;
- int count = (int) Math.ceil(list.size() / StaticData.D100);
-
- List<List<T>> subLists = Lists.partition(list, count);
+ //int count = (int) Math.ceil(list.size() / StaticData.D100)
+ List<List<T>> subLists = Lists.partition(list, StaticData.I50);
for (List<T> sub : subLists) {
try {
rows += basicMapper.insertBatch(sub);
--
Gitblit v1.9.3