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("还原失败"); } }
java程序还原MySQL数据库代码
最新推荐文章于 2021-12-27 16:52:29 发布