device_adjust_value表相关文件

lizijie

2020-11-03 428a3c3136d5a64655a09aa1e8644b6a439c2a0f

device_adjust_value表相关文件

 src/main/java/com/moral/mapper/DeviceAdjustValueMapper.java

New file
@@ -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);
}

 src/main/java/com/moral/service/DeviceAdjustValueService.java

New file
@@ -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);
}

 src/main/java/com/moral/service/impl/DeviceAdjustValueServiceImpl.java

New file
@@ -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);
    }
}

 src/main/resources/mapper/DeviceAdjustValueMapper.xml

New file
@@ -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>