📄 shownotice.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../incoming/common.jsp"%>
<html>
<head>
<title>公告</title>
</head>
<body>
<div align="center">
<h1>查看公告内容</h1>
<%
String noticeID = request.getParameter("noticeID");
DBSQLManager dbsm = new DBSQLManager();
String sql="SELECT * FROM tb_notice where NOTICE_ID='"+noticeID+"'";
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs=dbsm.getRs();
if(rs.next())
{
%>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<td>公告ID：</td>
<td width="200"><%=rs.getString("NOTICE_ID") %></td>
</tr>
<tr>
<td>公告标题：</td>
<td><%=rs.getString("NOTICE_TITLE") %></td>
</tr>
<tr>
<td>发表时间：</td>
<td><%=rs.getString("NOTICE_DATE") %></td>
</tr>
<tr>
<td>公告内容：</td>
<td width="600" height="300"><%=rs.getString("NOTICE_TEXT") %></td>
</tr>
<tr>
<td><a href="noticelist.jsp">返回</a></td>
<td><a href="updateNotice.jsp?modifyNotice=1¬iceID=<%=noticeID %>" onClick="return confirm('确定要删除这条数据吗?');">修改</a> <a href="delnotice.jsp?noticeID=<%=noticeID %>">删除</a></td>
</tr>
</table>
<%}%>
<br>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -