device_adjust_value表更新

lizijie

2020-11-04 d312d25e147e1e90c3600de4653ffbdcf7df76f3

device_adjust_value表更新

 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);
}

 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);
}

 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;
    }
}

 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>