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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
package com.fgkj.mapper.impl;
 
import java.util.List;
 
 
import com.fgkj.dto.BattInf;
import com.fgkj.dto.Batt_electricity;
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 Batt_electricityMapper{
 
    @Insert("insert into web_site.tb_batt_electricity(dev_id,dev_name,dev_recordtime,dev_electricity_CM,dev_electricity_CT,dev_electricity_CU,note) values(#{dev_id},#{dev_name},#{dev_recordtime},#{dev_electricity_CM},#{dev_electricity_CT},#{dev_electricity_CU},#{note})")
    public int add(Batt_electricity obj);
 
    @Update("UPDATE web_site.tb_batt_electricity SET  dev_id=#{dev_id}, dev_name=#{dev_name}, dev_recordtime=#{dev_recordtime}, dev_electricity_CM=#{dev_electricity_CM}, dev_electricity_CT=#{dev_electricity_CT}, dev_electricity_CU=#{dev_electricity_CU}, note=#{note} where num=#{num}")
    public boolean update(Batt_electricity obj);
 
    @Insert("delete from  web_site.tb_batt_electricity where num=#{num}")
    public boolean del(Batt_electricity obj);
 
//    @Select("select num,dev_id,dev_name,dev_recordtime,dev_electricity_CM,dev_electricity_CT,dev_electricity_CU,note from web_site.tb_batt_devdischarge")
    @Select("select num,dev_id,dev_name,dev_recordtime,dev_electricity_CM,dev_electricity_CT,dev_electricity_CU,note from web_site.tb_batt_electricity")
    public List<Batt_electricity> searchAll();
 
 
    //9.1机房主控中用电量的统计的折线图
    public List<Batt_electricity> serchByInfo(BattInf obj);
 
    /*public static void main(String[] args) throws ParseException {
        Batt_electricityImpl bimpl=new Batt_electricityImpl();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Date date1 = sdf.parse("2000-01-01");
        Date date2 = sdf.parse("2017-12-01");
        BattInf binf=new BattInf();
        *//*binf.setStationName("湖北省-鄂州市-东方世纪城-设备1");
        binf.setStationName1("");*//*
        binf.setStationId("42070450");
        binf.setBattProducer("");
        binf.setSignalName("1");//统计方式
        binf.setMonCount(1);
        binf.setBattProductDate(ActionUtil.getSimpDate(date1));
        binf.setBattProductDate1(ActionUtil.getSimpDate(date2));
        List<Batt_electricity> list=bimpl.serchByCondition(binf);
        for (Batt_electricity b : list) {
            System.out.println(b);
        }
        System.out.println(list.size());
    
    }*/
    //10.1根据设备id连battinf和batt_devdischarge表
        /*
         * 记录时间放在battinf的battproducer
         * 统计方式放在SignalName*/
 
//    @Select("select num,dev_id,dev_name,dev_recordtime,dev_electricity_CM,dev_electricity_CT,dev_electricity_CU,note from web_site.tb_batt_electricity limit 10 ")
    @Select("select num,dev_id,dev_name,dev_recordtime,dev_electricity_CM,dev_electricity_CT,dev_electricity_CU,note " +
            "from web_site.tb_batt_electricity ,(select DISTINCT(FBSdeviceid) from db_battinf.tb_battinf where stationid=#{stationId} )  as DISTINCTbattinf " +
            "where  DISTINCTbattinf.FBSdeviceid=tb_batt_electricity.dev_id  and  to_days(tb_batt_electricity.dev_recordtime)>=to_days(#{battProductDate}) and to_days(tb_batt_electricity.dev_recordtime)<=to_days(#{battProductDate1})  ORDER BY dev_id ,dev_recordtime ")
    public List<Batt_electricity> serchByCondition(BattInf obj);
 
}