From 0fb1d609321e64a11b28ef524022c7eddc533649 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 05 六月 2023 17:53:11 +0800
Subject: [PATCH] 解决Voc的Mapper运行出错
---
src/main/resources/mapping/VocValsMapper.xml | 4 ++--
src/main/java/com/yssh/scheduled/ReadCsvTask.java | 1 +
src/main/java/com/yssh/dao/VocValsMapper.java | 5 +++--
src/main/java/com/yssh/utils/VocParser.java | 4 ++--
4 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/yssh/dao/VocValsMapper.java b/src/main/java/com/yssh/dao/VocValsMapper.java
index bc4c7a0..aac2ce6 100644
--- a/src/main/java/com/yssh/dao/VocValsMapper.java
+++ b/src/main/java/com/yssh/dao/VocValsMapper.java
@@ -2,6 +2,7 @@
import com.yssh.entity.VocVals;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
import java.util.List;
@@ -19,7 +20,7 @@
* @param startVal 璧峰鍊硷紙鍙负绌�)
* @return
*/
- public List<VocVals> selectByTime(String time, Double startVal);
+ public List<VocVals> selectByTime(@Param("time") String time, @Param("startVal") Double startVal);
/**
* 鏍规嵁鏃堕棿缁熻
@@ -27,7 +28,7 @@
* @param time 鏃堕棿锛堢ず渚嬶細2023060514锛�
* @return 琛屾暟
*/
- public int countByTime(String time);
+ public int countByTime(@Param("time") String time);
/**
* 鎻掑叆涓�鏉℃暟鎹�
diff --git a/src/main/java/com/yssh/scheduled/ReadCsvTask.java b/src/main/java/com/yssh/scheduled/ReadCsvTask.java
index 36df3aa..97cf133 100644
--- a/src/main/java/com/yssh/scheduled/ReadCsvTask.java
+++ b/src/main/java/com/yssh/scheduled/ReadCsvTask.java
@@ -56,6 +56,7 @@
}
private void loadVoc() {
+ vocValsService.deleteLastYear();
Calendar calendar = getCalendar(96);
for (int i = 0; i < 192; i++) {
calendar.add(Calendar.HOUR, -1);
diff --git a/src/main/java/com/yssh/utils/VocParser.java b/src/main/java/com/yssh/utils/VocParser.java
index 0d29188..bd29fe3 100644
--- a/src/main/java/com/yssh/utils/VocParser.java
+++ b/src/main/java/com/yssh/utils/VocParser.java
@@ -27,7 +27,7 @@
private Date date;
- private List<VocVals> list = new ArrayList<>(BATCH_COUNT);
+ private List<VocVals> list = new ArrayList<>();
public VocParser(VocValsService vocValsService, Date date) {
this.vocValsService = vocValsService;
@@ -50,7 +50,7 @@
if (list.size() >= BATCH_COUNT) {
inserts();
- list = new ArrayList<>(BATCH_COUNT);
+ list = new ArrayList<>();
}
}
diff --git a/src/main/resources/mapping/VocValsMapper.xml b/src/main/resources/mapping/VocValsMapper.xml
index 36480da..cad3a40 100644
--- a/src/main/resources/mapping/VocValsMapper.xml
+++ b/src/main/resources/mapping/VocValsMapper.xml
@@ -23,7 +23,7 @@
<select id="countByTime" resultType="java.lang.Integer">
select count(*)
from voc_vals
- where date_format(create_time, '%Y%m%d%H') = ${time}
+ where date_format(create_time, '%Y%m%d%H') = ${time};
</select>
<insert id="insert" parameterType="com.yssh.entity.VocVals" useGeneratedKeys="true" keyProperty="id">
@@ -40,6 +40,6 @@
<delete id="deleteLastYear">
delete from voc_vals
- where create_time < date_sub(now(), interval 1 year);
+ where create_time < date_sub(now(), interval 1 year);
</delete>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3