From 428a3c3136d5a64655a09aa1e8644b6a439c2a0f Mon Sep 17 00:00:00 2001 From: lizijie <lzjiiie@163.com> Date: Tue, 03 Nov 2020 15:23:38 +0800 Subject: [PATCH] device_adjust_value表相关文件 --- src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java | 12 ++++++ src/main/resources/mapper/DeviceAdjustValueMapper.xml | 16 ++++++++ src/main/java/com/moral/service/DeviceAdjustValueService.java | 9 ++++ src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java | 26 +++++++++++++ 4 files changed, 63 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java b/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java new file mode 100644 index 0000000..72a6fcd --- /dev/null +++ b/src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java @@ -0,0 +1,12 @@ +package com.moral.mapper; + + +import org.apache.ibatis.annotations.Param; + +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); +} \ 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 new file mode 100644 index 0000000..23f9f06 --- /dev/null +++ b/src/main/java/com/moral/service/DeviceAdjustValueService.java @@ -0,0 +1,9 @@ +package com.moral.service; + +import java.util.Map; + +public interface DeviceAdjustValueService { + Map<String, Object> getDataByid(Integer id); + + void uudateValueByID(int id,String value); +} diff --git a/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java b/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java new file mode 100644 index 0000000..3ef4805 --- /dev/null +++ b/src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java @@ -0,0 +1,26 @@ +package com.moral.service.impl; + +import com.moral.mapper.DeviceAdjustValueMapper; +import com.moral.service.DeviceAdjustValueService; +import org.springframework.stereotype.Service; + +import javax.annotation.Resource; +import java.util.Map; + +@Service +public class DeviceAdjustValueServiceImpl implements DeviceAdjustValueService{ + + @Resource + private DeviceAdjustValueMapper deviceAdjustValueMapper; + + @Override + public Map<String, Object> getDataByid(Integer id) { + Map<String, Object> result = deviceAdjustValueMapper.selectAllByid(id); + return result; + } + + @Override + public void uudateValueByID(int id, String value) { + deviceAdjustValueMapper.updateValueByID(id,value); + } +} diff --git a/src/main/resources/mapper/DeviceAdjustValueMapper.xml b/src/main/resources/mapper/DeviceAdjustValueMapper.xml new file mode 100644 index 0000000..ef86663 --- /dev/null +++ b/src/main/resources/mapper/DeviceAdjustValueMapper.xml @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.moral.mapper.DeviceAdjustValueMapper"> + <select id="selectAllByid" resultType="java.util.Map"> + SELECT * FROM device_adjust_value + WHERE id = #{id} + </select> + + <!--������id������value--> + <update id="updateValueByID"> + UPDATE device_adjust_value + SET value = #{value} + WHERE id = #{id} + </update> + +</mapper> \ No newline at end of file -- Gitblit v1.8.0