📄 admin_bckdb.jsp
字号:
<%
if (session.getAttribute("Urule").toString().compareTo("a")!=0){
response.sendRedirect ("error.jsp?id=admin");
}
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="check.jsp" %>
<%@ page import="java.util.*" %>
<script language=javascript src="mouse.js"></script>
<link rel="stylesheet" type="text/css" href="oa1.css">
<script language=javascript >
<!--
function onBackup(form){
if(form.filename.value.length<2){
alert("请选择备份文件！");
return false;
}
form.submit();
return true;
}
function onSelFile(form){
form.filename.value=form.fname.value;
alert(form.fname.value);
}
//-->
</script>
<body bgcolor="#d6d3ce">
<%
String kind = "1";
if(request.getParameter("kind")!=null){
kind = request.getParameter("kind");
}
String title="导出数据";
String dbtt="备份整个数据库";
int op2 = 1;
String fname = request.getParameter("filename");
if(kind.compareTo("2")==0){
title = "导入数据";
dbtt= "还原整个数据库";
op2 = 5;
}
String op = "100";
if(request.getParameter("op")!=null){
op = request.getParameter("op");
}
Calendar nowtime = Calendar.getInstance();
String sj = nowtime.get(Calendar.YEAR)+"_"+(nowtime.get(Calendar.MONTH)+1)+"_"+nowtime.get(Calendar.DAY_OF_MONTH)+"_"+nowtime.get(Calendar.HOUR_OF_DAY);
String sql;
String tmp = request.getParameter("db");
if(op.compareTo("1")==0){//导出数据
String path = "c:/office/dbbackup/"+tmp+sj+".txt";
//数据库支持事务
sql ="set transaction read only";
sql +="lock tables "+tmp+" write;\n";
sql += "select * from "+tmp+" into outfile '"+path+"'\n";
sql += "unlock tables;\n";
sql += "insert into dbbck (tbname,filename,time)values('"
+ tmp + "','" + path + "','"+sj+"');\n";
sql +="commit;";
sqlbean.execute(sql);
//out.println(sql);
out.println(sqlbean.showMsg("javascript:history.back()","成功导出数据！","系统提示"));
}else if(op.compareTo("2")==0){//备份数据表
sql ="set transaction read only";
sql +="lock tables "+tmp+" write;\n";
sql +="BACKUP TABLE "+tmp+" TO 'c:/office/dbbackup/"+tmp+sj+".tb';\n";
sql += "unlock tables;\n";
sql +="commit;";
sqlbean.execute(sql);
out.println(sqlbean.showMsg("javascript:history.back()","成功备份数据表！","系统提示"));
}else if(op.compareTo("3")==0){//
out.println(sqlbean.showMsg("javascript:history.back()","成功备份数据表！","系统提示"));
}else if(op.compareTo("4")==0){//备份整个数据库
sql ="c:/mysql/bin/";
// out.println("op=4");
out.println(sqlbean.showMsg("javascript:history.back()","成功备份数据表！","系统提示"));
}else if(op.compareTo("5")==0){//导入数据
sql ="set transaction read only";
sql +="lock tables "+tmp+" write;\n";
sql += "load data infile "+fname+" into table "+tmp;
sql += ";\nunlock tables;\n";
sql +="commit;";
sqlbean.execute(sql);
out.println(sqlbean.showMsg("javascript:history.back()","成功导入数据！","系统提示"));
}else if(op.compareTo("6")==0){//还原整个数据库
}else{
%>
<table width=100% border=1 cellspacing=0 cellpadding=0 bordercolorlight=#666666 bordercolordark=#ffffff bgcolor=#d6d3ce>
<tr>
<th height=25 colspan=3 bgcolor="#333333"> <font color="#ff0000">
<B><span lang="zh-cn">Gjm-OA--软件</span><%=title%></font></B></th>
</tr>
<tr>
<td class='forumrow' width='10%' >编号</td>
<td width='30%' >数据表名称</td>
<td>编辑: <%=title%></td>
</tr>
<tr>
<td class='forumrow' colspan=3><font color=red>这一节只做演示不能运行，因为各厂商的SQL语句是不同的，需要定做！</font></td>
</tr>
<%
/*
sql = "show tables";
sqlbean.executeQuery(sql);
int i=1;
while(sqlbean.next()){
tmp = sqlbean.getString(1);
out.println("<tr bgcolor=#f3f3f3>");
out.println("<form name=db method=post action='admin_bckdb.jsp' >");
out.println("<input type=hidden name=filename>");
out.println("<input type=hidden name=op value=5>");
out.println("<td>"+i+"</td><td>"+tmp+"</td><td>");
if(kind.compareTo("2")==0){
out.println("<input type=file size=10 name=fname value='' onchange='onSelFile(this.form)'>");
out.println("<input type=button name=submit value='开始还原' onclick='onBackup(this.form)'>");
}else{
out.println("<a href='admin_bckdb.jsp?op=1&db="+tmp+"'>开始备份</a></td><td>");
}
out.println("</td></form></tr>");
i++;
}
out.println("<tr bgcolor=#f1f1f1><td colspan=3><a href='admin_bckdb.jsp?op=4'>备份整个数据库</a></td></tr>");
out.println("<tr bgcolor=#e1e1e1><td colspan=3><font color=red>因为SQL_92并没有定义数据导出和导入的语句，这里只是一个MySQL数据库服务器的演示。解决的方法只能是根据<数据库服务器>定做，别无他途！</font></td></tr>");
out.println("</table></form>");
*/
}
sqlbean.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -