运维管理系统

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
package fence.kaoqing;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import DataBase.DatabaseManagement;
import PbuliClass.ShowMessage;
@SuppressWarnings("rawtypes")
public class Dell_tbreallkaoqing {
    static Vector<tb_reallkaoqing>  vc_realkq=new Vector<tb_reallkaoqing>();
 
    
    static {        
        Iterator iterator =DatabaseManagement.table_base("tb_realkaoqing","ASC","tagid").iterator();
        while (iterator.hasNext()) {//µü´úÆ÷´æÔÚÔªËØ            
            List info = (List) iterator.next();//½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
            int size=info.size();
            tb_reallkaoqing tbrk=new tb_reallkaoqing();
            tbrk.setArea((String)info.get(1));
            tbrk.setName((String)info.get(2));
            tbrk.setBumen((String)info.get(3));
            tbrk.setTagid((String)info.get(4));   
            tbrk.setIntime((String)info.get(5));  
            tbrk.setBeizhu((String)info.get(6));
            if(size>10) {
            tbrk.setJuli((String)info.get(7)); 
            //ÊÇ·ñÔÚ¿¼ÇÚÇøÓò
            tbrk.setBaoliu1((String)info.get(8));
            }else {
                ShowMessage.zidingyi_24("tb_realkaoqingÊý¾Ý±íȱÉÙ×Ö¶Î");
            }
            vc_realkq.add(tbrk);
        }
    }
    
    /**»ñÈ¡¿¼ÇÚÊý¾Ý¿âÖеÄÊý¾Ý¼¯ºÏ*/
    public static Vector<tb_reallkaoqing> getVc_realkq() {
        return vc_realkq;
    }
    
    /**»ñȡij¸ö¿¼ÇÚ¶ÔÏó*/
    public static tb_reallkaoqing  get_tbrkq(String tgid) {
        tb_reallkaoqing  tbr=null;
        return tbr;
    }
    
    /**Ïòʵʱ¿¼ÇÚÊý¾Ý¿âÌí¼ÓÒ»ÌõÊý¾Ý*/
    public static void add_in_data(String tagid) {
        String[] ziduan= {"tagid","baoliu1"};
        String[] zhi= {tagid,"1"};
        DatabaseManagement.insertfast("tb_realkaoqing", ziduan, zhi);
    }
    
    /**ɾ³ýʵʱ¿¼ÇÚÊý¾Ý±íÖеÄÒ»ÌõÊý¾Ý*/
    public static void delete_data(String tagid) {
        String deleteSql="DELETE FROM tb_realkaoqing WHERE tagid='"+tagid+"'";                            
        DatabaseManagement.update(deleteSql);
    }
    
    /**ɾ³ýʵʱ¿¼ÇÚÊý¾Ý±íÖеÄËùÓÐÊý¾Ý*/
    public static void deleteall() {
        String deleteall="TRUNCATE TABLE tb_realkaoqing";                    
        DatabaseManagement.update(deleteall) ;
    }
    
}