linux mysql 导入数据库脚本_在linux机器上从java执行mysql数据库导入脚本

实现它的简单方法。

String DBUSERNAME = "";

String DBUSERPASSWORD = "";

String sqlfilename = "";

PrintWriter writer = new PrintWriter("tmp.dmp", "UTF-8");

writer.println("mysql --user " + DBUSERNAME + " --password=" + DBUSERPASSWORD + " < " + sqlfilename);

writer.close();

runCommand("chmod 777 tmp.dmp");

runCommand("./tmp.dmp");

runCommand("rm tmp.dmp");

public static void runCommand(String command) throws IOException {

String s = "";

Process p = Runtime.getRuntime().exec(command);

BufferedReader stdInput = null;

BufferedReader stdError = null;

try {

stdInput = new BufferedReader(new InputStreamReader(p.getInputStream()));

stdError = new BufferedReader(new InputStreamReader(p.getErrorStream()));

// read the output from the command

while ((s = stdInput.readLine()) != null) {

System.out.println(s);

}

// read any errors from the attempted command

while ((s = stdError.readLine()) != null) {

System.out.println(s);

}

} finally {

if (stdInput != null) {

stdInput.close();

}

if (stdError != null) {

stdError.close();

}

}

}