📄 restore.jsp

📁 新闻发布系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="getadminsession.jsp"%>
<%
request.setCharacterEncoding("GB2312");
%>
<jsp:useBean id="restore" scope="page" class="dsp.database.Operation"/>
<%
String sql = "SELECT * FROM web_bak ORDER BY id DESC";
ResultSet rs = restore.query(sql);
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="inc/admin.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
function RestoreBak_check(id,c)
{
	var ok;
	ok=confirm("您是确定要恢复【"+c+"】备份吗？");
	if(ok)
	{
		self.location.href="processrestore.jsp?id="+id;
	}
}

function DelBak_check(id,c)
{
	var ok;
	ok=confirm("您是确定要删除【"+c+"】备份吗？");
	if(ok)
	{
		self.location.href="delbak.jsp?id="+id;
	}
}
</script>
</head>

<body>
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
  <tr> 
    <td colspan="8" align="center" height="30" background="images/tablebg.gif"><b>恢 
      复 数 据 库</b> </td>
  </tr>
  <tr> 
    <td height="25" colspan="3"><div align="center"><font color="#FF0000"> 切记</font>：数据库在恢复之后，要重新MySQL数据库服务器才能生效，否则无效！</div></td>
  </tr>
  <tr> 
    <td width="17%" height="26" align="center">ID</td>
    <td width="50%" align="center">备份时间</td>
    <td width="33%" height="26" align="center">操作</td>
  </tr>
<%
int id = 0;
String d = "";
while(rs.next()){
	id = rs.getInt("id");
	d = rs.getString("date");
%>
  <tr> 
    <td height="25" align="center"><%=id%></td>
    <td height="25" align="center"><%=d%></td>
    <td height="25" align="center"><a onclick="javascript:RestoreBak_check(<%=id%>,'<%=d%>');" class="A">恢 复</a> | <a onclick="javascript:DelBak_check(<%=id%>,'<%=d%>');" class="A">删 除</a></td>
  </tr>
<%
}
%>

</table>
 <%@include file="copyright.jsp"%> 
</body>
</html>

<%
restore.closestmt();
restore.closeconn();
%>
⌨️ 快捷键说明

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