wenzheng.yang
2023-06-19 8d3a46d346ef028acc16e267fe5c812c76a754e5
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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
package data_model;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import publicclass.GetNowTime;
public class Dell_shebei {    
    static Vector<tb_shebei> tagvc=new Vector<tb_shebei>();    
    @SuppressWarnings("rawtypes")
    public static  Vector<tb_shebei> getvec() {        
        String databasename="tb_shebei";
            Iterator iterator = DatabaseManagement.table_addtime(databasename,"ASC").iterator();        
            while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
                List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËØ¸øµ½info¼¯ºÏ
                tb_shebei data=new tb_shebei();                
                String tagid=(String) info.get(1);   
                String name=(String) info.get(2);     
                String ip=(String) info.get(3);      
                String state="0";    
                String icid=(String) info.get(5);    
                String addtime=(String) info.get(6);   
                String gengxintime=(String) info.get(7);   
                String baoliu1=(String) info.get(8);  
                String baoliu2=(String) info.get(9); 
                data.setTagid(tagid);   
                data.setName(name);     
                data.setIp(ip);       
                data.setState(state);    
                data.setIcid(icid);     
                data.setAddtime(addtime);   
                data.setGengxintime(gengxintime);   
                data.setBaoliu1(baoliu1);   
                data.setBaoliu2(baoliu2);                 
                tagvc.add(data);
            }
            return tagvc;
    }
    
    /** Í¨¹ý±êÇ©id»ñȡijһ¸öÉ豸¶ÔÏó */
    public static tb_shebei get_tag(String tagid) {
        tb_shebei tag = null;
        if (tagvc.size() != 0) {
            Iterator<tb_shebei> it = tagvc.iterator();
            while (it.hasNext()) {
                tb_shebei tag1 = it.next();
                String idtag = tag1.getTagid();
                if (tagid.equals(idtag)) {
                    tag = tag1;
                    break;
                }
            }
        }
        return tag;
    }
    
    
    /**²åÈëÒ»¸öÉ豸*/
    public static void add_shebei(String tagid,String ip,String icid,String name) {
        tb_shebei data =get_tag(tagid);
        String time=GetNowTime.now();
        if(data==null) {
            tb_shebei data2 =new tb_shebei();
            data2.setTagid(tagid);   
            data2.setName(name);     
            data2.setIp(ip);       
            data2.setState("1");    
            data2.setIcid(icid);     
            data2.setAddtime(time);   
            data2.setGengxintime(time);
            tagvc.add(data2);
            insertdatabase(tagid,ip,icid,time);//²åÈëÊý¾Ý¿â
        }else {
            data.setIp(ip);       
            data.setState("1");    
            data.setIcid(icid);    
            data.setGengxintime(time);
        }
    }
    
    /**²åÈëÊý¾Ý½øÈëÊý¾Ý¿â*/
    public static void insertdatabase(String tagid,String ip,String icid,String time) {         
        String[]  ziduan= {"tagid","ip","state","icid","addtime","gengxintime"};
        String[] zhi= {tagid,ip,"1",icid,time,time};
        DatabaseManagement.insertfast("tb_shebei", ziduan, zhi);
    }
    
    public static Vector<tb_shebei> getshebeivc(String tagid){
        Vector<tb_shebei> tagvc1=new Vector<tb_shebei>();
        tb_shebei data =get_tag(tagid);
        if(data!=null) {
            tagvc1.add(data);
        }
        return tagvc1;        
    }
    
    public static Vector<tb_shebei> getTagvc() {
        return tagvc;
    }
    public static void setTagvc(Vector<tb_shebei> tagvc) {
        Dell_shebei.tagvc = tagvc;
    }
 
}