JAVA实现数据库备份与还原(7)

做一个项目中的数据库备份与恢复(MSSQL)

数据库备份

String webtruepath=getServletContext().getRealPath(request.getServletPath());//取Servlet的真实路径 java.io.File file=new java.io.File(webtruepath);

file=file.getParentFile();

String path=file.getPath()+"\\..\\WEB-INF\\lib\\"+name+".dbbak";//name文件名

String bakSQL="backup database school to disk=? with init";//SQL语句

java.sql.PreparedStatement bak=DBS.getConnection().prepareStatement(bakSQL);

bak.setString(1,path);//path必须是绝对路径

if(!bak.execute())over="备份成功";

else over="备份失败";

bak.close();

数据库恢复

if(!DBS.close()){

over="关闭所有链接失败";

}else{

String webtruepath=getServletContext().getRealPath(request.getServletPath()); java.io.File file=new java.io.File(webtruepath);

file=file.getParentFile();

String path=file.getPath()+"\\..\\WEB-INF\\lib\\"+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="恢复成功";

else over="恢复失败";

reStmt.close();

con.close();

}