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

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();

}