[color=red]mysql导入:[/color]
[color=green]//host:数据库主机名,user数据库用户名,password数据库密码,database导入的数据库名[/color]
try {
Runtime rt = Runtime.getRuntime();
String sql="cmd /c mysql -h"+host+" -u"+user+" -p"+password+" "+database+"c://re.sql";
rt.exec(sql);
}
catch (IOException e) {
e.printStackTrace();
}
[color=red]mysql导出[/color]
[color=green]//tables要导出的数据库各个表,用空格隔开[/color]
String stmt1 = "cmd /c mysqldump "+database +tables+ "-h"+host+" -u" + user + " -p"
+ password ;
StringBuffer sql = new StringBuffer();
try {
Process ps=Runtime.getRuntime().exec(stmt1);
InputStream is = ps.getInputStream();
BufferedReader reader = new BufferedReader(new InputStreamReader(
is, "utf-8"));
String line = "";
while ((line = reader.readLine()) != null) {
sql.append(line + System.getProperty("line.separator"));
}
}
catch (IOException e) {
e.printStackTrace();
}
response.setContentType("application/x-download");
response.setHeader("Content-Disposition", "attachment;filename=fileback.sql");
OutputStream os = response.getOutputStream();
byte[] bytes = sql.toString().getBytes("utf-8");
os.write(bytes);
os.close();
[color=green]//host:数据库主机名,user数据库用户名,password数据库密码,database导入的数据库名[/color]
try {
Runtime rt = Runtime.getRuntime();
String sql="cmd /c mysql -h"+host+" -u"+user+" -p"+password+" "+database+"c://re.sql";
rt.exec(sql);
}
catch (IOException e) {
e.printStackTrace();
}
[color=red]mysql导出[/color]
[color=green]//tables要导出的数据库各个表,用空格隔开[/color]
String stmt1 = "cmd /c mysqldump "+database +tables+ "-h"+host+" -u" + user + " -p"
+ password ;
StringBuffer sql = new StringBuffer();
try {
Process ps=Runtime.getRuntime().exec(stmt1);
InputStream is = ps.getInputStream();
BufferedReader reader = new BufferedReader(new InputStreamReader(
is, "utf-8"));
String line = "";
while ((line = reader.readLine()) != null) {
sql.append(line + System.getProperty("line.separator"));
}
}
catch (IOException e) {
e.printStackTrace();
}
response.setContentType("application/x-download");
response.setHeader("Content-Disposition", "attachment;filename=fileback.sql");
OutputStream os = response.getOutputStream();
byte[] bytes = sql.toString().getBytes("utf-8");
os.write(bytes);
os.close();