From b129ec5b6d0268dce3233e715e5c31923731daf2 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Wed, 04 Nov 2020 15:16:24 +0800
Subject: [PATCH] 分钟表数据插入时，异常抛出
---
src/main/java/com/moral/task/HistoryTableInsertTask.java | 21 +++++++++++++--------
1 files changed, 13 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/moral/task/HistoryTableInsertTask.java b/src/main/java/com/moral/task/HistoryTableInsertTask.java
index 8af56a4..3b4d770 100644
--- a/src/main/java/com/moral/task/HistoryTableInsertTask.java
+++ b/src/main/java/com/moral/task/HistoryTableInsertTask.java
@@ -1,14 +1,10 @@
package com.moral.task;
import java.math.BigDecimal;
+import java.text.SimpleDateFormat;
import java.time.LocalDateTime;
import java.time.temporal.ChronoUnit;
-import java.util.ArrayList;
-import java.util.Arrays;
-import java.util.HashMap;
-import java.util.LinkedHashMap;
-import java.util.List;
-import java.util.Map;
+import java.util.*;
import javax.annotation.Resource;
@@ -124,6 +120,8 @@
XxlJobLogger.log("historyMinutelyException:" + e.getMessage());
logger.error(e.getMessage());
e.printStackTrace();
+ ReturnT returnT = new ReturnT(500, e.getMessage());
+ return returnT;
}
ReturnT returnT = new ReturnT(500, "���������������������");
return returnT;
@@ -332,10 +330,17 @@
public ReturnT insertHistorySpecialTable(String params) {
Map macMap = JSON.parseObject(params);
List<String> macList = (List<String>) macMap.get("mac");
- LocalDateTime value = LocalDateTime.now();
+ SimpleDateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ Calendar calendar=Calendar.getInstance();
+ Date date=calendar.getTime();
+ String s=format.format(date);
+ calendar.set(Calendar.HOUR_OF_DAY, calendar.get(Calendar.HOUR_OF_DAY) - 1);
+ Date date1=calendar.getTime();
+ String s1=format.format(date1);
Map<String, Object> devices = new HashMap<>();
devices.put("macList", macList);
- devices.put("time", value);
+ devices.put("startTime", s1);
+ devices.put("endTime", s);
try {
int count = historyService.insertHistorySpecialTable(devices);
XxlJobLogger.log("insertHistorySpecialTable:" + count);
--
Gitblit v1.8.0