更新

wenzheng.yang

2023-06-13 963ab41dff2876c091ff0405931aa5d3f8f71780

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 data_model;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
public class Dell_door {
    static Vector<Tb_door> Tb_doorvc=new Vector<Tb_door>();
    @SuppressWarnings("rawtypes")
    public static  Vector<Tb_door> getvec() {
        Vector<Tb_door> jiancevc=new Vector<Tb_door>();
        String databasename="tb_door";
            Iterator iterator = DatabaseManagement.table_addtime(databasename,"DESC").iterator();        
            while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ
                List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
                Tb_door data=new Tb_door();                 
                String id=(String) info.get(0);  
                String tagid=(String) info.get(1);   
                String anchorid=(String) info.get(2);  
                String distance=(String) info.get(3);  
                String power=(String) info.get(4);   
                String addtime =(String) info.get(5); 
                data.setId(id);  
                data.setTagid(tagid);   
                data.setAnchorid(anchorid);  
                data.setDistance(distance);  
                data.setPower(power);   
                data.setAddtime(addtime); 
                jiancevc.add(data);
            }
            return jiancevc;
    }
    
    public static Vector<Tb_door> serch(String tagid){
        Vector<Tb_door> jiancevc=new Vector<Tb_door>();
        int size=getvec().size();
        for(int i=0;i<size;i++) {
            Tb_door a1=getvec().get(i);
            String tagid1=a1.getTagid();
            if(tagid1.equals(tagid)) {
                jiancevc.add(a1);
            }
        }
        return jiancevc;
    }
 
    public static Vector<Tb_door> getTb_doorvc() {
        return Tb_doorvc;
    }
    
    public static void insert_tbdoor(String tagid,String anchorid,String distance,String power,String addtime) {
        Tb_door data=new Tb_door();
        data.setTagid(tagid);   
        data.setAnchorid(anchorid);  
        data.setDistance(distance);  
        data.setPower(power);   
        data.setAddtime(addtime); 
        Tb_doorvc.add(data);
        
    }
 
    public void setTb_doorvc(Vector<Tb_door> tb_doorvc) {
        Tb_doorvc = tb_doorvc;
    }
}