From d312d25e147e1e90c3600de4653ffbdcf7df76f3 Mon Sep 17 00:00:00 2001
From: lizijie <lzjiiie@163.com>
Date: Wed, 04 Nov 2020 08:56:13 +0800
Subject: [PATCH] device_adjust_value表更新
---
src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java | 3 +++
src/main/resources/mapper/DeviceAdjustValueMapper.xml | 6 ++++++
src/main/java/com/moral/service/DeviceAdjustValueService.java | 3 +++
src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java | 7 +++++++
4 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java b/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java
index 72a6fcd..222f15f 100644
--- a/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java
+++ b/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java
@@ -3,10 +3,13 @@
import org.apache.ibatis.annotations.Param;
+import java.util.List;
import java.util.Map;
public interface DeviceAdjustValueMapper {
Map<String, Object> selectAllByid(@Param("id") Integer id);
void updateValueByID(@Param("id") Integer id,@Param("value") String value);
+
+ List<Map<String, Object>> selectDataByTimesolt(@Param("startTime")String startTime, @Param("endTime")String endTime);
}
\ No newline at end of file
diff --git a/src/main/java/com/moral/service/DeviceAdjustValueService.java b/src/main/java/com/moral/service/DeviceAdjustValueService.java
index 23f9f06..00956b3 100644
--- a/src/main/java/com/moral/service/DeviceAdjustValueService.java
+++ b/src/main/java/com/moral/service/DeviceAdjustValueService.java
@@ -1,9 +1,12 @@
package com.moral.service;
+import java.util.List;
import java.util.Map;
public interface DeviceAdjustValueService {
Map<String, Object> getDataByid(Integer id);
void uudateValueByID(int id,String value);
+
+ List<Map<String, Object>> selectDataByTimesolt(String startTime,String endTime);
}
diff --git a/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java b/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java
index 3ef4805..c297237 100644
--- a/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java
@@ -5,6 +5,7 @@
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import java.util.List;
import java.util.Map;
@Service
@@ -23,4 +24,10 @@
public void uudateValueByID(int id, String value) {
deviceAdjustValueMapper.updateValueByID(id,value);
}
+
+ @Override
+ public List<Map<String, Object>> selectDataByTimesolt(String startTime, String endTime) {
+ List<Map<String, Object>> result = deviceAdjustValueMapper.selectDataByTimesolt(startTime,endTime);
+ return result;
+ }
}
diff --git a/src/main/resources/mapper/DeviceAdjustValueMapper.xml b/src/main/resources/mapper/DeviceAdjustValueMapper.xml
index ef86663..428316e 100644
--- a/src/main/resources/mapper/DeviceAdjustValueMapper.xml
+++ b/src/main/resources/mapper/DeviceAdjustValueMapper.xml
@@ -12,5 +12,11 @@
SET value = #{value}
WHERE id = #{id}
</update>
+
+ <!--���������������������������-->
+ <select id="selectDataByTimesolt" resultType="java.util.Map">
+ select * FROM device_adjust_value_timing
+ WHERE adjusttime BETWEEN #{startTime} AND #{endTime}
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0