From 305c7b36ac9e92df0e9d8f998067fcd640106e37 Mon Sep 17 00:00:00 2001
From: whyczh <hzjl@qq.com>
Date: 星期三, 31 三月 2021 16:01:33 +0800
Subject: [PATCH] 添加试验数据接口
---
src/main/java/com/whyc/service/MotorStateService.java | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/MotorStateService.java b/src/main/java/com/whyc/service/MotorStateService.java
index 91893d8..f2a34e5 100644
--- a/src/main/java/com/whyc/service/MotorStateService.java
+++ b/src/main/java/com/whyc/service/MotorStateService.java
@@ -13,6 +13,10 @@
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import java.text.DateFormat;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.Date;
import java.util.List;
@Service
@@ -67,4 +71,20 @@
public boolean delete(int deviceId){
return motorStateMapper.deleteById(deviceId)>0;
}
+
+ /**
+ * 閫氳繃璁惧id锛屽紑濮嬬粨鏉熸椂闂磋幏鍙栬澶囧巻鍙叉暟鎹�
+ * @param deviceId
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ public List<MotorState> getHistoryData(String deviceId,String startTime,String endTime){
+ //鑾峰彇鏃堕棿鎷兼帴鏁版嵁琛ㄥ悕
+ String dateStr = startTime.substring(0,10).replace('-','_');
+ String tableName="tb_motor_state_realdata_"+deviceId+"_"+dateStr;
+ List<MotorState> data = motorStateMapper.getDataByTime(tableName,startTime,endTime);
+ return data;
+ }
+
}
--
Gitblit v1.9.1