📄 notice.jsp
字号:
<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@include file="conn.jsp" %>
<%@include file="top.jsp" %>
<%
request.setCharacterEncoding("gb2312");
String sql1="select * from icefish_notice";
Statement stmt1=conn.createStatement();
ResultSet rs1=stmt1.executeQuery(sql1);
%>
<html>
<head>
<style>
a{text-decoration:none}a.xh{text-decoration:none; color:#ffffff}a:hover.xh{text-decoration:underline}a.zh{text-decoration:none;color:#000000}a:hover.zh{text-decoration:underline;color:blue}
body,td{font-size:9pt}
</style>
<title>冰鱼论坛----发布公告|管理公告</title>
<script Language="Javascript" src="include/form.js"> </Script>
<script language=JavaScript>
function selectUrl()
{
var aUrl=document.getElementsByName("checkbox");
for(icount=0;icount<aUrl.length;icount++)
{aUrl[icount].checked=(document.getElementById("selchk").checked==true)?true:false;}
}
</script>
</head>
<body style="text-align: center">
<p align="left">>> 欢迎光临 <b>冰鱼论坛</b></p>
<table width="100%" height="50" border="0" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr bgcolor="#dff2ed"><td><img src="images/skin/1/forum_nav.gif"> <a class=zh href="">冰鱼论坛</a> → →<a class=zh href="****">浏览论坛公告</a></td></tr>
</table><p>
<a class=zh href="addnotice.jsp"><font color="#000000">发布公告</font></a> | <a class=zh href="notice.jsp"><font color="#000000">管理公告</font></a><br><br>
<table width="100%" border="1" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr>
<td width="7%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">ID</p></td>
<td width="47%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">标题</p></td>
<td width="17%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">作者</p></td>
<td width="20%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">日期</p></td>
<td width="7%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">操作</p></td>
</font></b></td>
<%while(rs1.next()){
%> <form method="post" name="frmCheckBox" action="delnotice.jsp">
<tr height="25" colspan="2"><b><font color="black">
<td align="center" bgcolor="#dff2ed"> <%=rs1.getString("notice_id")%> </td>
<td align="center"> <%=rs1.getString("notice_title")%> </td>
<td align="center" bgcolor="#dff2ed"> <%=rs1.getString("notice_author")%> </td>
<td align="center"> <%=rs1.getString("notice_date")%> </td>
<td align="center" bgcolor="#dff2ed"> <input type="checkbox" name="checkbox" value="<%=rs1.getString("notice_id")%>"> </td>
</tr>
<%}
rs1.close();
stmt1.close();
conn.close();
%>
<tr height="25" colspan="2"><b><font color="black">
<td align="right"colspan="5" bgcolor="#dff2ed"> 请选择要删除的公告，
<input type=checkbox onClick="selectUrl()" id=selchk>全选/反选
<input type = submit name="Submit" value="执行"onclick="return(' 你确定执行？')"></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -