From aa86cb57b09c5300db3c33d75d91d8b51a4b636f Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 16 六月 2023 09:27:45 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/utils/VocParser.java | 33 +++++++++++++++++++++++++--------
1 files changed, 25 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/yssh/utils/VocParser.java b/src/main/java/com/yssh/utils/VocParser.java
index bd29fe3..85d9889 100644
--- a/src/main/java/com/yssh/utils/VocParser.java
+++ b/src/main/java/com/yssh/utils/VocParser.java
@@ -3,9 +3,11 @@
import com.github.biyanwen.impl.AbstractCsvFileParser;
import com.yssh.entity.VocVals;
import com.yssh.service.VocValsService;
-import org.apache.commons.logging.Log;
-import org.apache.commons.logging.LogFactory;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+import java.math.BigInteger;
+import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -16,22 +18,33 @@
* @date 2023-06-05
*/
public class VocParser extends AbstractCsvFileParser<VocVals> {
- protected final Log logger = LogFactory.getLog(this.getClass());
+ protected final Logger logger = LoggerFactory.getLogger(this.getClass());
+
+ private final SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHH0000");
/**
* 姣忛殧5000鏉″叆搴撲竴娆�
*/
- public static final int BATCH_COUNT = 5000;
+ public static final int BATCH_COUNT = 100000;
+
+ private BigInteger startId;
private VocValsService vocValsService;
private Date date;
- private List<VocVals> list = new ArrayList<>();
+ private List<VocVals> list = new ArrayList<>(BATCH_COUNT);
public VocParser(VocValsService vocValsService, Date date) {
this.vocValsService = vocValsService;
this.date = date;
+ this.startId = new BigInteger(format.format(date));
+ }
+
+ public BigInteger getId() {
+ startId = startId.add(BigInteger.valueOf(1));
+
+ return startId;
}
@Override
@@ -46,19 +59,23 @@
}
vv.setCreateTime(this.date);
+ vv.setId(getId());
list.add(vv);
if (list.size() >= BATCH_COUNT) {
inserts();
- list = new ArrayList<>();
+ list = new ArrayList<>(BATCH_COUNT);
}
}
private void inserts() {
try {
- this.vocValsService.insertVocVals(list);
+ if (list.size() > 0) {
+ //this.vocValsService.insertVocVals(list);
+ this.vocValsService.insertVocSync(list);
+ }
} catch (Exception e) {
- logger.error(e.getMessage());
+ logger.error(e.getMessage(), e);
e.printStackTrace();
}
}
--
Gitblit v1.9.3