http://www.111cn.net/jsp/Java/33832.htm
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();
}
更多详细内容请查看:http://www.111cn.net/jsp/Java/33832.htm
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();
}
更多详细内容请查看:http://www.111cn.net/jsp/Java/33832.htm