运维管理系统

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
package Method;
import java.io.*;
 
import PbuliClass.GetTxt;
import PbuliClass.ShowMessage;
/**Êý¾Ý¿â±¸·Ý»Ö¸´µÄ·½·¨*/
public class DataBackUp {
     /**±¸·ÝÊý¾Ý¿â*/
    static String database="hxzkuwb";
    static String dbUser=GetTxt.getTxt("dbName","system");         
    static String dbPwd=GetTxt.getTxt("dbPass","system");
    public static void  mysqldump(String path) { // ±¸·ÝÊý¾Ý¿â
        
        try {
            Process p = Runtime.getRuntime().exec(
                    "cmd.exe /c mysqldump -u"+dbUser+" -p"+dbPwd +" "+ database + " >"
                            + path + "");           //¶¨Òå½øÐÐÊý¾Ý±¸·ÝµÄÓï¾ä
            
            
            StringBuffer out1 = new StringBuffer(); //¶¨Òå×Ö·û´®»º³å¶ÔÏó
            byte[] b = new byte[1024];              //¶¨Òå×Ö½ÚÊý×é
            for (int i; ((i = p.getInputStream().read(b)) != -1);) { // ½«Êý¾ÝдÈëµ½Ö¸¶¨ÎļþÖÐ
                out1.append(new String(b, 0, i));   //ÏòÁ÷ÖÐ×·¼ÓÊý¾Ý
            }
        } catch (IOException e) {
            e.printStackTrace();
            ShowMessage.zidingyi("±¸·Ýʧ°Ü");
            return;
        }
        ShowMessage.zidingyi("±¸·Ý³É¹¦");
    }
    
    /**Êý¾Ý¿â»Ö¸´*/
    public static  void mysqlresume(String path) { // »Ö¸´Êý¾Ý¿â
        try {
            Process p = Runtime.getRuntime().exec(
                    "cmd.exe /c mysql -u"+dbUser+" -p"+dbPwd+" "+ database + " <" + path
                            + ""); // Ö´Ðлָ´Óï¾ä
            StringBuffer out1 = new StringBuffer(); // ¶¨Òå×Ö·û´®»º³å¶ÔÏó
            byte[] b = new byte[1024]; // ¶¨Òå×Ö½ÚÊý×é
            for (int i; ((i = p.getInputStream().read(b)) != -1);) { // ½«Êý¾ÝдÈëµ½Ö¸¶¨ÎļþÖÐ
                out1.append(new String(b, 0, i)); // ÏòÁ÷ÖÐ×·¼ÓÊý¾Ý
            }
        } catch (IOException e) {
            e.printStackTrace();
            ShowMessage.zidingyi("»Ö¸´Ê§°Ü");
            return ;
        }
        ShowMessage.zidingyi("»Ö¸´³É¹¦");
    }
 
    public static String getDatabase() {
        return database;
    }
        
 
}