运维管理系统

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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
package tbDataModel_Dell;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.swing.ImageIcon;
import DataBase.DatabaseManagement;
import Method.GetNowTime;
import PbuliClass.ShowMessage;
import home.Open_soft_dialog;
import tbDataModel.Tbicon;
 
@SuppressWarnings("rawtypes")
public class Dell_Tbicon {
    static Vector<Tbicon > tbicon_vector;//»ùÕ¾µÄ¼¯ºÏ
    static {
        Open_soft_dialog.addara("¼ÓÔØtb_icon");
        Iterator iterator = DatabaseManagement.get_alldate_indatabase("tb_icon").iterator();
        tbicon_vector=new Vector<>();
        while (iterator.hasNext()) {
            List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
            Tbicon tbicon=new Tbicon();
            tbicon.setIcon_name((String) info.get(1));
            tbicon.setIcon_adress((String) info.get(2));
            tbicon.setAdd_time((String) info.get(3));
            tbicon.setBeizhu((String) info.get(4));
            tbicon.setIcon(new ImageIcon((String)info.get(2)));
            tbicon_vector.add(tbicon);
        }
    }
 
    /**¸ù¾Ýͼ±êÃû³Æ»ñȡͼ±ê¶ÔÏó*/
    public static  Tbicon get_icon(String icobName) {
        Tbicon tbicon=null;
        if(tbicon_vector.size() !=0) {
            Iterator<Tbicon> it=tbicon_vector.iterator();
            while(it.hasNext()) {
                Tbicon tbicon1=it.next();
                String icobName1=tbicon1.getIcon_name();
                if(icobName1.equals(icobName) ) {
                    tbicon=tbicon1;
                    break;
                }
            }
        }
        return tbicon;
    }
 
    /**Ïò¼¯ºÏÌí¼ÓÒ»¸öͼ±ê¶ÔÏó*/
    public static void add_tbicon(String name,String adress) {
        if(get_icon(name)==null) {            
            String sql="INSERT tb_icon (icon_name,icon_adress,add_time) VALUES "
                    + "('"
                    +name+"','"
                    +adress+"','"
                    +GetNowTime.now()+"')";
 
            //Ìí¼Ó³É¹¦ÌáʾÐÅÏ¢        
            if(DatabaseManagement.update(sql) !=0){            
                Tbicon tbicon=new Tbicon();
                tbicon.setIcon_name(name);
                tbicon.setIcon_adress(adress);
                tbicon.setAdd_time(GetNowTime.now());
                tbicon.setIcon(new ImageIcon(adress));
                tbicon_vector.add(tbicon);
                ShowMessage.zidingyi("Ìí¼Óͼ±ê"+name+"³É¹¦£¡");
            }
        }else {
            ShowMessage.zidingyi("ͼ±ê"+name+"ÒѾ­´æÔÚ²»ÄÜÖظ´Ìí¼Ó£¡");
        }
    }
 
    /**ɾ³ýij¸öͼ±ê¶ÔÏó*/
    public static void delete_tbicon(String name) {
        if(get_icon(name) !=null) {            
            String deleteSql="DELETE FROM tb_icon WHERE icon_name='"+
                    name+"'";
            if(DatabaseManagement.update(deleteSql) !=0) {
                tbicon_vector.remove(get_icon(name));
            }
        }
    }
 
    /**ÐÞ¸Äij¸öͼ±ê¶ÔÏó*/
    public static void alert_tbicon(String name,String adress,String addtime) {
        if(get_icon(name) !=null) {    
 
            String sql="UPDATE tb_icon SET icon_adress='"+adress
                    +"'where icon_name='"+name+"'";    
            if(DatabaseManagement.update(sql)!=0) {
                get_icon(name).setIcon_adress(adress);
                get_icon(name).setAdd_time(GetNowTime.now());
                get_icon(name).setIcon(new ImageIcon(adress));
            }
        }
    }
 
    /**ɾ³ýËùÓеÄͼ±ê¶ÔÏó*/
    public static void delete_all_tbicon() {
        if(tbicon_vector.size() !=0) {
            tbicon_vector.removeAllElements();
        }
    }
 
    /**»ñÈ¡ËùÓÐͼ±êÃû³ÆµÄ¼¯ºÏ*/
    public static String[] icon_name() {
        int size=tbicon_vector.size();
        String[] iconname=new String[size];
        if(size !=0) {
            for(int i=0;i<size;i++) {
                iconname[i]=tbicon_vector.get(i).getIcon_name();
            }
        }
        return iconname;
    }
 
    public static Vector<Tbicon> getTbicon_vector() {
        return tbicon_vector;
    }
 
 
}