运维管理系统

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
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
package yunwei;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import home.Open_soft_dialog;
 
public class dell_shebei_manege {    
    static Vector<Tb_shebei_manege> shebeivc = new Vector<Tb_shebei_manege>();
    /** »ñÈ¡Êý¾Ý¿âÖÐËùÓбêÇ© */
    static {
        Open_soft_dialog.addara("¼ÓÔØtb_shebei_manege");
        String sql = "select * from tb_shebei_manege order by id ASC ";
        @SuppressWarnings("rawtypes")
        Iterator iterator = DatabaseManagement.serch(sql).iterator();
        while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
            @SuppressWarnings("rawtypes")
            List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
            String id=(String)info.get(0);
            String name=(String)info.get(1);    
            String icid=(String)info.get(2);    
            String macid=(String)info.get(3);   
            String ip=(String)info.get(4);  
            String version=(String)info.get(5);
            String addtime=(String)info.get(6);
            Tb_shebei_manege tbshebei=new Tb_shebei_manege();
            tbshebei.setId(id);
            tbshebei.setName(name);
            tbshebei.setIcid(icid);
            tbshebei.setMacid(macid);
            tbshebei.setIp(ip);
            tbshebei.setVersion(version);
            tbshebei.setAddtime(addtime);
            shebeivc.add(tbshebei);
        }
    }
 
    /** Í¨¹ý±êÇ©id»ñȡijһ¸ö±êÇ©¶ÔÏó */
    public static Tb_shebei_manege get_Tb_shebei_manege(String tagid) {
        Tb_shebei_manege engm = null;
        if (shebeivc.size() != 0) {
            Iterator<Tb_shebei_manege> it = shebeivc.iterator();
            while (it.hasNext()) {
                Tb_shebei_manege engm1 = it.next();
                String macid1 = engm1.getMacid();
                if (macid1.equals(tagid)) {
                    engm= engm1;
                    break;
                }
            }
        }
        return engm;
    }
 
    /**¸üÐÂÊý¾Ý*/
    public static void alert_shebei(String tagid,String ip,String macid,String icid,String version) {
        Tb_shebei_manege tbtag=get_Tb_shebei_manege(tagid);
        String addtime=GetNowTime.now();
        if(tbtag !=null) {
            tbtag.setAddtime(addtime);
            tbtag.setIp(ip);
            tbtag.setMacid(macid);
            tbtag.setIcid(icid);
            String[] ziduan = {"icid","macid","ip","addtime","tbshebei","version","tagid" };
            String[] zhi = {icid,macid,ip,addtime, version,tagid };
            DatabaseManagement.fast_alert_dbase("tb_shebei_manege", ziduan, zhi);
        }else {
            tbtag=new Tb_shebei_manege();    
            tbtag.setTagid(tagid);
            tbtag.setMacid(macid);
            tbtag.setAddtime(addtime);
            tbtag.setIp(ip);
            tbtag.setIcid(icid);
            String[] ziduan = {"icid","macid","ip","addtime", "version","tagid" };
            String[] zhi = {icid,macid,ip,addtime, version,tagid };
            DatabaseManagement.insertfast("tb_shebei_manege", ziduan, zhi);
        }        
    }
 
    //$equipment,tagid,¿¨ºÅ,°æ±¾ºÅ,µçÄÔÐòÁкÅ,end
    public static void dell_message(String message,String ip) {
        String a[]=message.split(",");
        String tagid=a[1];
        String icid=a[2];
        String version=a[2];
        String macid=a[4];
        alert_shebei(tagid,ip,macid,icid,version);
    }
}