update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

 src/main/java/com/fgkj/mapper/impl/Chart_ColorMapper.java

@@ -2,13 +2,23 @@

import java.util.List;

import com.fgkj.dto.Chart_Color;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

public interface Chart_ColorMapper{
    //给用户添加颜色组
   public boolean add(Object obj);
    @Insert("insert into web_site.tb_chart_color(uid,max_color,min_color,normal_color,change_color,warn_color) " +
            "values(#{uid},#{max_color},#{min_color},#{normal_color},#{change_color},#{warn_color})")
   public int add(Chart_Color obj);

    //修改用户的颜色组
   public boolean update(Object obj);
    @Update("update web_site.tb_chart_color set max_color=#{max_color},min_color=#{min_color},normal_color=#{normal_color},change_color=#{change_color},warn_color=#{warn_color}where uid=#{uid}")
   public int update(Chart_Color obj);

   //查询用户对应得颜色组
   public List serchByCondition(Object obj);
    @Select("select max_color,min_color,normal_color,change_color,warn_color from web_site.tb_chart_color where uid=#{uid} ")
   public List<Chart_Color> serchByCondition(Chart_Color obj);
}