update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

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

@@ -2,19 +2,31 @@

import java.util.List;

import com.fgkj.dto.BattDischarge_param;
import org.apache.ibatis.annotations.Delete;
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 BattDischarge_paramMapper{

    //8.1添加新的参数
   public boolean add(Object obj);
   @Insert("insert into web_site.tb_battdischarge_param(param_name,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,plan_circle,plan_rate,note) " +
         "values(#{param_name},#{preset_time},#{preset_cap},#{preset_monvol},#{preset_groupvol},#{preset_curr},#{preset_mon},#{dcvolhighlimit},#{chargecurrset},#{plan_circle},#{plan_rate},#{note})")
   public boolean add(BattDischarge_param obj);
   
    //8.1修改参数信息
   public boolean update(Object obj);

   public boolean del(Object obj);
   @Update("update web_site.tb_battdischarge_param set param_name=#{param_name},preset_time=#{preset_time} ,preset_cap=#{preset_cap},preset_monvol=#{preset_monvol},preset_groupvol=#{preset_groupvol},preset_curr=#{preset_curr},preset_mon=#{preset_mon},dcvolhighlimit=#{dcvolhighlimit},chargecurrset=#{chargecurrset},plan_circle=#{plan_circle},plan_rate=#{plan_rate},note=#{note} where num=#{num} ")
   public boolean update(BattDischarge_param obj);
   @Delete("delete from web_site.tb_battdischarge_param where num=#{num}")
   public boolean del(BattDischarge_param obj);

    //8.1查询所有的参数
   public List searchAll();
    
   public List serchByCondition(Object obj);
   @Select("select num,param_name,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,plan_circle,plan_rate,note from web_site.tb_battdischarge_param")
   public List<BattDischarge_param> searchAll();

   @Select("select num,param_name,preset_time,preset_cap,preset_monvol,preset_groupvol,preset_curr,preset_mon,dcvolhighlimit,chargecurrset,plan_circle,plan_rate,note from web_site.tb_battdischarge_param where num=#{num}")
   public List<BattDischarge_param> serchByCondition(BattDischarge_param obj);

}