📄 siteproblem_manage.jsp

📁 Java 实现代码后台管理功能的 script语言

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file ="../DT_inc/ChkPwd.jsp"%>

<%@include file="../ConnDB.jsp"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>问题网站管理</title>
<link href="Style.css" rel="stylesheet" type="text/css" />

</head>

<body>
<br />
&nbsp; <a href="SiteProblem_Manage.jsp">问题网站管理</a>
<hr color="#0099FF" size="1" />

<%
Statement stmt_WebDir =conn.createStatement();
String WebDir_Sql="Select * from tSiteProblem ";

ResultSet RsWebDir =stmt_WebDir.executeQuery(WebDir_Sql);
%>

&nbsp; 问题网站总数： <%//=RsWebDir.RecordCount%> 个
<div align="center">
      <form id="form1" name="form1" method="post" action="">
      站内搜索:&nbsp;
      <input name="Searchtext" type="text" id="Searchtext" />
      <input name="SearchInside" type="submit" id="Search" value="搜 索" />
    </form>


<table width="600" border="0" cellspacing="0" align="center">
	<tr height="30">
	  <td>序号</td>
	  <td>问题网站名称</td>
		<td>网址类别</td>
		<td>报告时间</td>
		<td>审阅</td>
		<td>管  理</td>
	</tr>

	<%
	int xuhao=1;
	while (RsWebDir.next()) 
	{
	
	%>
	<tr height="20" onmouseover="this.bgColor='#f0f8ff';" onmouseout="this.bgColor='#FFFFFF';">
	<td><%=xuhao%></td>
	  <td align="left"><a href="<%=RsWebDir.getString("fUrl")%>" target="_blank" title="网站问题说明:<%=RsWebDir.getString("fContent")%>"><%=RsWebDir.getString("fTitle")%></a>
	  </td>
		<td><%=RsWebDir.getString("fClassName")%></td>
		<td><%=RsWebDir.getString("fUpdateTime")%></td>
		<td><%if (RsWebDir.getString("fPassed").equals("0")) {%><font color="#FF0000">(未审阅)</font><%}%></td>
		<td><a href="SiteProblem_DEL.jsp?ID=<%=RsWebDir.getInt("fID")%>" onclick="return confirm('删除后将不能恢复，你确定删除么？')">删除</a></td>
	</tr>
	<%
	xuhao=xuhao+1;
	}
	%>
</table>
<%//分页未写 pagination(RsWebDir.PageCount,RsWebDir.pagesize,page,RsWebDir.RecordCount) %>

</div>
<%
RsWebDir.close();
stmt_WebDir.close();
conn.close();
%>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -