Backup.java

package com.zdcf.test;
import java.util.Calendar;  
import java.util.Date;  
import java.text.SimpleDateFormat;  
import java.io.IOException;  
import java.io.PrintStream;  
  

public class Backup {
    private String user_name;// 数据库用户名
    private String user_psw;// 数据库密码
    private String db_name;// 需要备份的数据库名
    private String host_ip;// 主机IP
    private String user_charset;// 字符集
    private String backup_path; // 存放备份文件的路径
    private String stmt;// 命令

    public Backup(String user_name, String user_psw, String db_name,
            String host_ip, String user_charset, String backup_path) {
        this.user_name = user_name;
        this.user_psw = user_psw;
        this.db_name = db_name;
        // 主机IP;
        if (host_ip == null || host_ip.equals(""))
            this.host_ip = "localhost";// 默认为本机
        else
            this.host_ip = host_ip;
        // 字符集
        if (user_charset == null || user_charset.equals(""))
            this.user_charset = " "; // 默认为安装时设置的字符集
        else
            this.user_charset = " --default-character-set=" + user_charset;
        this.backup_path = backup_path;
        this.stmt = "c:\\wamp\\bin\\mysql\\mysql5.5.20\\bin\\mysqldump "
                + this.db_name + " -h " + this.host_ip + " -u" + this.user_name
                + " -p" + this.user_psw + this.user_charset + " --result-file="
                + this.backup_path;
    }

    public boolean backup_run() {
        boolean run_result = false;
        try {
            Runtime.getRuntime().exec(this.stmt);
            run_result = true;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return run_result;
    }

    public static void main(String[] args) {
        Backup backup = new Backup("root", "123456", "mysql", null, "utf8",
                "d:\\test.sql");
        boolean result = backup.backup_run();
        if (result)
            System.out.println("备份成功");
    }
}