运维管理系统

zsh_root

2024-01-02 7b595546af704983dbafcd0d385c8768ddacefc2

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
package tbDataModel_Dell;
/**´¦ÀíÀúÊ·µçÁ¿µÄ¼¯ºÏ*/
 
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import tbDataModel.AcHispower;
import tbDataModel.Hispower;
public class Dell_hispower {
    static Vector<Hispower> hispower_vec=new Vector<>();
    static Vector<AcHispower> achispower_vec=new Vector<>();
 
    public static Vector<Hispower> getHispower_vec() {
        return hispower_vec;
    }
    
    /**»ñȡij¸ö±êÇ©µÄÀúÊ·µçÁ¿Êý¾Ý*/
    @SuppressWarnings("rawtypes")
    public static void  insert(String tagid) {
        String sql="select * from tb_history_power where tagid='"+tagid+"'";
        Iterator iterator = DatabaseManagement.serch(sql).iterator();//´´½¨µü´úÆ÷        
        while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ            
            List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
            Hispower row = new Hispower();    
            row.setPower(String.valueOf(info.get(2)));
            String data=String.valueOf(info.get(3)).substring(5,10);
            row.setData(data);
            row.setTagid(tagid);
            hispower_vec.add(row);
            }    
    }
 
 
    @SuppressWarnings("rawtypes")
    public static void  insert2(String anchorId) {
        String sql="select * from tb_ac_history_power where anchorId='"+anchorId+"'";
        Iterator iterator = DatabaseManagement.serch(sql).iterator();//´´½¨µü´úÆ÷
        while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
            List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
            AcHispower row = new AcHispower();
            row.setPower(String.valueOf(info.get(2)));
            String data=String.valueOf(info.get(3)).substring(5,10);
            row.setData(data);
            row.setAnchorid(anchorId);
            achispower_vec.add(row);
        }
    }
 
}