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())));