<%@?page?contentType="text/html;charset=gb2312"%>?
<%@?page?import="java.util.*,com.fxm.common.*,com.ncucec.*,com.ncucec.dbo.*,java.sql.*,org.hibernate.*"%>
<body>
<%
int?j=0;
String?action,postid,folder;
action?=?request.getParameter("action");
postid?=?request.getParameter("postid");
if?((action==null)?||?("".equals(action)))?action="main";
if?((null==postid)?||?("".equals(postid)))?postid="0";
String?path,realPath,sql,file,err;
boolean?ret=false;
if?("backup".equals(action)){
????path?=?CnUtils.toChinese(request.getParameter("path"));
????if?(CnUtils.isEmpty(path))?path?="";?else?path=DirList.getRealDir(path);
????//得到查詢的絕對路徑
????realPath?=?getServletContext().getRealPath(path);
????
????try{
????????//得到路徑
????????ret?=?DirList.MakeDir(realPath);
????????path?=?realPath+"\\"+DateUtil.formatDate(new?java.util.Date(),"yyMMdd");
????????ret?=?DirList.MakeDir(path);
????????path?=?CnUtils.Replace(path,"\\","/");
????????Session?ss?=?HibernateUtil.currentSession();
????????Transaction?tx?=?ss.beginTransaction();
????????Connection?conn=?ss.connection();
????????Statement?st?=?conn.createStatement();
????????file?=?path+"/news.txt";
????????sql?=?"select?*?from?tbl_news_b?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????
????????file?=?path+"/column.txt";
????????sql?=?"select?*?from?tbl_column_b?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????file?=?path+"/invinfo.txt";
????????sql?=?"select?*?from?tbl_invinfo_r?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????file?=?path+"/vote.txt";
????????sql?=?"select?*?from?tbl_vote_r?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????file?=?path+"/placard.txt";
????????sql?=?"select?*?from?tbl_placard_b?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????file?=?path+"/group.txt";
????????sql?=?"select?*?from?tbl_group_r?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????file?=?path+"/user.txt";
????????sql?=?"select?*?from?tbl_user_b?into?outfile?'"+?file?+"'";
????????st.execute(sql);
????????ret?=?true;
????????conn.commit();
????}catch(Exception?e){
????????out.println(e);
????????ret?=?false;
????}
????if?(ret==false)
????????out.println("<br><br><p?align=center>數據不能正確備份，請稍后再試，或與管理員聯系。<a?href=#?onclick='history.go(-1)'>返回</a></p>");
????else{
????????out.println("<br><br><p?align=center>數據備份成功。<a?href=#?onclick='history.go(-1)'>返回</a></p>");
????????action="main";
????}
????out.close();
}
if?("restore".equals(action)){
????path?=?CnUtils.toChinese(request.getParameter("path"));
????if?(CnUtils.isEmpty(path))?path?="";?else?path=DirList.getRealDir(path);
????//得到查詢的絕對路徑
????realPath?=?getServletContext().getRealPath(path);
????
????try{
????????//得到路徑
????????ret?=?DirList.MakeDir(realPath);
????????path?=?realPath+"\\"+DateUtil.formatDate(new?java.util.Date(),"yyMMdd");
????????ret?=?DirList.MakeDir(path);
????????path?=?CnUtils.Replace(path,"\\","/");
????????Session?ss?=?HibernateUtil.currentSession();
????????Transaction?tx?=?ss.beginTransaction();
????????Connection?conn=?ss.connection();
????????Statement?st?=?conn.createStatement();
????????file?=?path+"/column.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_column_b";
????????st.execute(sql);
????????
????????file?=?path+"/news.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_news_b";
????????st.execute(sql);
????????
????????file?=?path+"/vote.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_vote_r";
????????st.execute(sql);
????????
????????file?=?path+"/placard.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_placard_b";
????????st.execute(sql);
????????
????????file?=?path+"/invinfo.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_invinfo_r";
????????st.execute(sql);
????????file?=?path+"/template.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_template_r";
????????st.execute(sql);
????????file?=?path+"/group.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_group_r";
????????st.execute(sql);
????????file?=?path+"/user.txt";
????????sql?=?"load?data?infile?'"+file+"'?replace?into?table?tbl_user_r";
????????st.execute(sql);
????????ret?=?true;
????????conn.commit();
????}catch(Exception?e){
????????out.println(e);
????????ret?=?false;
????}
????if?(ret==false)
????????out.println("<br><br><p?align=center>數據不能正確恢復，請稍后再試，或與管理員聯系。<a?href=#?onclick='history.go(-1)'>返回</a></p>");
????else{
????????out.println("<br><br><p?align=center>數據恢復成功。<a?href=#?onclick='history.go(-1)'>返回</a></p>");
????????action="main";
????}
????out.close();
}
if?("main".equals(action)){
%>
<script?language="javascript">
????//?表單提交（當遠程上傳完成后，觸發此函數）
????function?doSubmit(type){
????????document.a1.action.value?=?type;
????????document.a1.submit();
????}
</script>
<table?width="550"?cellspacing=1?cellpadding=1?align=center?style="border:?1?solid?#808080"?border="0">?
??<tr>?
????<th?height=25>???<B>備份系統數據庫</B></th>?
??</tr>?
??<form?method="post"?action="?"?id=a1?name=a1>?
??<input?type=text?name="action"?value="backup">
????<tr>?
??????<td?bgcolor="ffffff"?height="22">?備份目錄：?
????????<input?type=text?size=20?name="path"?value="backup"></td>?
????</tr>?
????<tr>?
??????<td?bgcolor="efefef"?height="25">??
????????<input?type=button?value="?備?份?數?據?"?onclick="doSubmit('backup')">???<input?type=button?value="?恢?復?數?據?"?onclick="doSubmit('restore')"></td>?
????</tr>?
??</form>?
</table>?
<%
}
%>
|