update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
package com.fgkj.mapper.impl;
 
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添加新的参数
    @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修改参数信息
    @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查询所有的参数
    @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);
 
}