JSP数据库备份和还原

JSP数据库备份和还原

JSP数据库备份
废话不多说Java代码如下：

package com.p.filter;
import java.io.BufferedReader;  
import java.io.DataInputStream;  
import java.io.IOException;  
import java.io.InputStreamReader;  
/**
 * 数据库备份
 * @author Forever_mx
 */
public class Command {
	public static void main(String[] args) {
		   Command com = new Command();  
com.backupDatebase("localhost","root","root","test","D:/test.sql");//输出到控制台  
	}
	//执行dos命令 
	public String execCmd(String cmd) {
		StringBuffer sb = new StringBuffer("");
		StringBuffer str = new StringBuffer();
		str.append(" cmd.exe /c \"").append(cmd).append("\"");
		System.out.println(str); // 打印执行的命令
		Process ls_proc;
		try {
			ls_proc = Runtime.getRuntime().exec(str.toString());
			BufferedReader in = new BufferedReader(new InputStreamReader(
					new DataInputStream(ls_proc.getInputStream())));