From a90e365f7034968e8560707953aa147e5dd0e7b2 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 22 十一月 2024 17:37:28 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/utils/CsvParser.java | 54 ++++++++++++++++++++++++++++++++++--------------------
1 files changed, 34 insertions(+), 20 deletions(-)
diff --git a/src/main/java/com/yssh/utils/CsvParser.java b/src/main/java/com/yssh/utils/CsvParser.java
index fa374a2..1e779a4 100644
--- a/src/main/java/com/yssh/utils/CsvParser.java
+++ b/src/main/java/com/yssh/utils/CsvParser.java
@@ -3,60 +3,75 @@
import java.util.ArrayList;
import java.util.List;
-import org.apache.commons.logging.Log;
-import org.apache.commons.logging.LogFactory;
+import com.yssh.entity.AlertConfig;
+import com.yssh.entity.SuYuan;
+import com.yssh.mapper.AlertConfigMapper;
+import com.yssh.service.SuYuanService;
+
+import com.github.biyanwen.impl.AbstractCsvFileParser;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
-import com.github.biyanwen.impl.AbstractCsvFileParser;
-import com.yssh.entity.SuYuan;
-import com.yssh.service.ISuYuanService;
+import javax.annotation.Resource;
-public class CsvParser extends AbstractCsvFileParser<SuYuan>{
+public class CsvParser extends AbstractCsvFileParser<SuYuan> {
+ protected final Logger logger = LoggerFactory.getLogger(this.getClass());
- protected final Log logger = LogFactory.getLog(this.getClass());
/**
- * 姣忛殧3000鏉″瓨鍌ㄦ暟鎹簱锛岀劧鍚庢竻鐞唋ist 锛屾柟渚垮唴瀛樺洖鏀�
+ * 姣忛殧100000鏉″瓨鍌ㄦ暟鎹簱锛岀劧鍚庢竻鐞唋ist 锛屾柟渚垮唴瀛樺洖鏀�
*/
public static final int BATCH_COUNT = 100000;
-
+
/**
* 缂撳瓨鐨勬暟鎹�
*/
private List<SuYuan> cachedData = new ArrayList<>(BATCH_COUNT);
-
- private ISuYuanService suYuanService;
+
+ private SuYuanService suYuanService;
+
private String time;
-
- public CsvParser(ISuYuanService suYuanService, String time) {
+
+ private double jcyj;
+
+ public CsvParser(SuYuanService suYuanService, String time) {
this.suYuanService = suYuanService;
this.time = time;
+ this.jcyj = suYuanService.getJcyj();
}
-
+
/**
* 鎵�鏈夋暟鎹В鏋愬畬鎴愪簡 浼氭潵璋冪敤,闃叉鏈夋暟鎹病鏈夎淇濆瓨
*/
- @Override
protected void doAfterAllAnalysed() {
try {
saveSuYuanData();
} catch (Exception e) {
- logger.error("瑙ｆ瀽淇濆瓨鏁版嵁鍑虹幇寮傚父锛屽紓甯稿師鍥犳槸锛�" + e.getMessage());
+ logger.error("瑙ｆ瀽淇濆瓨鏁版嵁鍑虹幇寮傚父锛屽紓甯稿師鍥犳槸锛�" + e.getMessage(), e);
e.printStackTrace();
}
}
- @Override
protected void invoke(SuYuan t) {
t.setId(t.getX() + "_" + t.getY() + "_" + t.getZ());
- System.err.println(t.getId());
+ /*if ("0_0_0".equals(t.getId())) {
+ return; // 瑙ｅ喅涓婚敭閲嶅
+ }*/
+ /*if (t.getZ() > 0 && t.getC() < jcyj) {
+ return; // 鍙叆绗�0灞傛暟鎹�+Voc鍊煎ぇ浜�1
+ }*/
+
+ // 鍙叆鍊� > =0.05
+ if (t.getC() < 0.01) {
+ return;
+ }
+
cachedData.add(t);
// 杈惧埌BATCH_COUNT浜嗭紝闇�瑕佸幓瀛樺偍涓�娆℃暟鎹簱锛岄槻姝㈡暟鎹嚑涓囨潯鏁版嵁鍦ㄥ唴瀛橈紝瀹规槗OOM
if (cachedData.size() >= BATCH_COUNT) {
try {
saveSuYuanData();
} catch (Exception e) {
- logger.error("瑙ｆ瀽淇濆瓨鏁版嵁鍑虹幇寮傚父锛屽紓甯稿師鍥犳槸锛�" + e.getMessage());
+ logger.error("瑙ｆ瀽淇濆瓨鏁版嵁鍑虹幇寮傚父锛屽紓甯稿師鍥犳槸锛�" + e.getMessage(), e);
e.printStackTrace();
}
// 瀛樺偍瀹屾垚娓呯悊 list
@@ -67,5 +82,4 @@
private void saveSuYuanData() throws Exception {
suYuanService.insertSuYuanDatas(cachedData, time);
}
-
}
--
Gitblit v1.9.3