📄 db.jsp

📁 很好的,网上商城在线购物网站系统,电子商务自助建站管理系统。适合电脑,手机,数码,化妆品,服装,运动鞋,首饰,母婴,成人用品,书籍,汽车,办公用品,音像制品的网店
💻 JSP
字号:
<%@ page contentType="text/html;charset=utf-8"%>
<%@ include file="../../include.jsp"%> 
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>无标题文档</title>

<script language="javascript" src="../../common.js"></script>
<script src="<%=ConfigBean.getStringValue("systenFolder")%>alert_js.jsp"></script>
<script language="JavaScript" type="text/JavaScript">
<!--

function importDB(folder,i)
{
	theForm = document.getElementById("dbform" + i);

	if( confirm("确认恢复数据库到 "+folder+" 版本？"))
	{
		document.getElementById("handle_status").className="ErrorMsg";
		document.getElementById("handle_status").innerHTML="正在恢复数据库，请勿刷新浏览器……";
		theForm.action="<%=ConfigBean.getStringValue("systenFolder")%>appController/importDB";
		theForm.folder.value=folder;
		theForm.submit();
	}
}

function delDataBaseBK(folder,i)
{
	theForm = document.getElementById("dbform" + i);

	if( confirm("确认删除备份数据库？"))
	{
		theForm.action="<%=ConfigBean.getStringValue("systenFolder")%>appController/delDataBaseBK";
		theForm.folder.value=folder;
		theForm.submit();
	}
}

function backupDBNow()
{
	theForm = document.add_form;

	if( confirm("该操作非常消耗系统资源，请勿在访问高峰期操作。确认立即备份数据库？"))
	{
		document.getElementById("handle_status").className="ErrorMsg";
		document.getElementById("handle_status").innerHTML="正在备份数据库，请勿刷新浏览器……";
		theForm.action="<%=ConfigBean.getStringValue("systenFolder")%>appController/backupDBNow";
		theForm.submit();
	}
}

function dbDBNow(v)
{
	theForm = document.add_form;

	if( confirm("确认下载数据库版本 "+v+" ？"))
	{
		theForm.action="export_db.jsp?folder="+v;
		theForm.submit();
	}
}
//-->
</script>
<link href="../comm.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style></head>
<body>
<br>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0" >
  <tr>
    <td class="page-title"><img src="../imgs/page_title.gif" alt="title" width="17" height="12" align="absmiddle">&nbsp;&nbsp; 系统管理 »   帐号管理 </td>
  </tr>
</table>
<br>
<br>
<div align="center">
<fieldset style="width:98%">
  <legend>数据库自动备份设置</legend>
  <table width="98%" height="40" border="0" align="center" cellpadding="3" cellspacing="0">
    <form action="<%=ConfigBean.getStringValue("systenFolder")%>appController/batchModifySystemConfig" method="post" name="add_form" >
      <tr valign="middle"> 
        <td align="left">自动备份 : 
          <input name="backup_db_flag" type="radio" value="1" <%=systemConfig.getIntConfigValue("backup_db_flag")==1?"checked":""%>>
          是 
          <input type="radio" name="backup_db_flag" value="0" <%=systemConfig.getIntConfigValue("backup_db_flag")==0?"checked":""%>>
          否&nbsp; <input name="Submit6" type="submit" class="short-button" value="保存设置">
          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;备份 
          <input name="backup_db_count" type="text" id="backup_db_count" style="width:30px;" value="<%=systemConfig.getIntConfigValue("backup_db_count")%>">
          天 
          <input name="Submit2" type="submit" class="short-button" value="保存设置">
          &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
          <input name="Submit5" type="button" class="long-button" id="backup_b" onClick="backupDBNow()"  value="立即备份">
          <span id="handle_status"></span></td>
      </tr>
    </form>
  </table>
</fieldset>
</div>
<br>

<br>
<%
String folder[] = systemConfig.getAllDBBK();
for (int i=0; i<folder.length; i++)
{
%>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0"  class="thetable">
  <form name="dbform<%=i%>">
    <input type="hidden" name="folder">
  <thead>
    <tr> 
      <td width="60%" valign="middle" class="left-title">&nbsp;<strong>备份日期</strong>: 
		<font face="Arial, Helvetica, sans-serif">
        <%=folder[i].substring(0,4)%>-<%=folder[i].substring(4,6)%>-<%=folder[i].substring(6,8)%>
		<%=folder[i].substring(8,10)%>:<%=folder[i].substring(10,12)%>:<%=folder[i].substring(12,14)%>        </font> </td>
      <td width="40%" align="right" valign="middle" class="right-title"> 
        <input name="Submit" type="button" class="long-button" onClick="importDB('<%=folder[i]%>',<%=i%>)" value="恢复数据库">
        &nbsp; 
        <input name="Submit3" type="button" class="long-button" onClick="delDataBaseBK('<%=folder[i]%>',<%=i%>)" value="删除备份">
        &nbsp; 
        <input name="Submit4" type="button" class="long-button" onClick="dbDBNow('<%=folder[i]%>')" value="下载备份">
      </td>
    </tr>
  </thead>
  <tr> 
    <td height="31" colspan="2" valign="middle" style="line-height:18px;"> 
      <%
DBRow file[] = systemConfig.getAllDBBKTableSql(folder[i]);
float filesize;
for ( int j=0; j<file.length; j++ )
{
	filesize = StringUtil.getFloat(file[j].getString("size"))/1024;
%>
     <DIV style="FLOAT: left;width:20%;">
				<DIV style="padding-top:5px;">
        <input name="tablename" type="hidden" value="<%=file[j].getString("name")%>">
          <font color="#666666"><%=file[j].getString("name")%></font>(<font color="#993366"><%=StringUtil.formatNumber("#0.00",filesize)%>k</font>)
				</div>
		</div>
      <%
}
%>
    </td>
  </tr>
</form>
</table>
<br>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -