JAVA實現(xiàn)數(shù)據(jù)庫備份與還原1-

1、 try processexp = rt.exec(imp; if (processexp.waitFor( != 0 JOptionPane.showMessageDialog(null, "沒有備份的數(shù)據(jù)庫信息文件" catch (IOException e e.printStackTrace(; catch (InterruptedException e e.printStackTrace(; 做一個項目中的數(shù)據(jù)庫備份與恢復(fù)(MSSQL 數(shù)據(jù)庫備份 String webtruepath=getServletContext(.getRealPath(request.ge

2、tServletPath(;/取 Servlet 的真實路徑 java.io.File file=new java.io.File(webtruepath; file=file.getParentFile(; String path=file.getPath(+".WEB-INFlib"+name+".dbbak"/name 文件名 String bakSQL="backup database school to disk=? with init"/SQL 語句 java.sql.PreparedStatement bak=DBS.g

3、etConnection(.prepareStatement(bakSQL; bak.setString(1,path;/path 必須是絕對路徑 if(!bak.execute(over="備份成功" else over="備份失敗" bak.close(; 數(shù)據(jù)庫恢復(fù) if(!DBS.close( over="關(guān)閉所有鏈接失敗" else String webtruepath=getServletContext(.getRealPath(request.getServletPath(; java.io.File file=new

4、java.io.File(webtruepath; file=file.getParentFile(; String path=file.getPath(+".WEB-INFlib"+name; String reSQL="restore database school from disk=? with replace" Class.forName(DBInf.getDriverClassName(; java.sql.Connection con=DriverManager.getConnection(DBInf.getMester(; java.sql.PreparedStatement reStmt=con.prepareStatement(reSQL; reStmt.setString(1,path;/path 必須是絕對路徑 if(!reStmt.execute(over=&q