java程序还原MySQL数据库代码

来源:互联网 发布:港台直播软件apk 编辑:程序博客网 时间:2024/05/21 06:23
private static void restore() {String fpath="d:/xytx.sql";Runtime rt=Runtime.getRuntime();Process child=null;try {child=rt.exec("C://Program Files//MySQL//MySQL Server 5.5//bin//mysql -uroot -padmin crmsure");} catch (IOException e) {e.printStackTrace();System.out.println("还原命令执行错误");}OutputStream out=child.getOutputStream();String inStr;StringBuffer sb=new StringBuffer();String outStr;InputStreamReader sr=null;try {sr = new InputStreamReader(new FileInputStream(fpath),"utf8");} catch (UnsupportedEncodingException e) {e.printStackTrace();System.out.println("文件流读入错误");} catch (FileNotFoundException e) {e.printStackTrace();System.out.println("文件路径错误");}BufferedReader br=new BufferedReader(sr);try {while((inStr=br.readLine())!=null){sb.append(inStr+"/r/n");}} catch (IOException e) {e.printStackTrace();System.out.println("文件流读出错误");}outStr=sb.toString();OutputStreamWriter writer=null;try {writer=new OutputStreamWriter(out,"utf8");} catch (UnsupportedEncodingException e) {e.printStackTrace();System.out.println("输出流错误");}try {writer.write(outStr);writer.flush();} catch (IOException e) {e.printStackTrace();System.out.println("写入错误");}try {writer.close();out.close();br.close();System.out.println("还原成功");} catch (Exception e) {e.printStackTrace();System.out.println("还原失败");}}
原创粉丝点击