public void mysql () throws Tool4jException { BufferedReader br = null;
BufferedWriter bw = null;
try {
Process process = Runtime.getRuntime().exec("mysql -u root -proot test");
bw = new BufferedWriter(new OutputStreamWriter(process.getOutputStream(), "utf8"));
String inStr = null;
StringBuffer sb = new StringBuffer("");
br = new BufferedReader(new InputStreamReader(new FileInputStream("C:/text.sql"), "utf8"));
while ((inStr = br.readLine()) != null) {
sb.append(inStr).append("");
}
bw.write(sb.toString());
bw.flush();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
if (bw != null) bw.close();
} catch (Exception e2) {}
try {
if (br != null) br.close();
} catch (Exception e2) {}
}
}这个方法为什么无法导入数据?又没有错误谁有能正确导入数据库的方法?
BufferedWriter bw = null;
try {
Process process = Runtime.getRuntime().exec("mysql -u root -proot test");
bw = new BufferedWriter(new OutputStreamWriter(process.getOutputStream(), "utf8"));
String inStr = null;
StringBuffer sb = new StringBuffer("");
br = new BufferedReader(new InputStreamReader(new FileInputStream("C:/text.sql"), "utf8"));
while ((inStr = br.readLine()) != null) {
sb.append(inStr).append("");
}
process.waitFor();
bw.write(sb.toString());
bw.flush();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
if (bw != null) bw.close();
} catch (Exception e2) {}
try {
if (br != null) br.close();
} catch (Exception e2) {}
}
}
还什么process啊
是啊, 为什么不直接执行SQL语句???