📄 bulletin_display.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*,java.lang.*" %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<SCRIPT language=JavaScript>
function commitForm(destJsp){
document.form1.action=destJsp;
document.form1.submit();
}
</script>
<link rel='stylesheet' type='text/css' href='imbed/forum.css'>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/qtop5.jpg" width="432" height="55"> <img src="images/dot.gif" width="12" height="11">
<font size="2"><a href="javascript:window.external.addFavorite('http://59.64.156.13','911论坛')" title="911论坛">收藏本站</a> <img src="images/dot.gif" width="12" height="11"> <a href="index.jsp">返回首页</a></font></td>
</tr>
</table>
<br>
<%
String bulletin_id="";
String bulletin_title="";
String bulletin_content="";
String bulletin_time="";
String id=request.getParameter("bulletin_id");
ResultSet rs=null;
String sql="select * from Bulletin where bulletin_id="+id;
rs=yy.executeQuery(sql);
if(rs.next())
{
bulletin_id=rs.getString("bulletin_id");
bulletin_title=rs.getString("bulletin_title");
bulletin_content=rs.getString("bulletin_content");
bulletin_time=rs.getString("bulletin_time");
}
%>
<table width="100%" border="1">
<tr>
<td width="100%" height="41" align="center" bordercolor="#CCCCCC" ><font size='2'>标题:<%=bulletin_title%>
<br>
发表日期:<%=bulletin_time.substring(0,10)%></font></td>
</tr>
<tr>
<td bordercolor="#CCCCCC"><font size='2'><%=bulletin_content%></font></td>
</tr>
<%
sql="select * from Bulletin order by bulletin_time desc ";
rs=yy.executeQuery(sql);
while(rs.next())
{
bulletin_id=rs.getString("bulletin_id");
bulletin_title=rs.getString("bulletin_title");
bulletin_content=rs.getString("bulletin_content");
bulletin_time=rs.getString("bulletin_time");
if(!bulletin_id.equals("id"))
{
%>
<tr>
<td width="100%" height="41" align="center" bordercolor="#CCCCCC" ><font size='2'>标题:<%=bulletin_title%>
<br>
发表日期:<%=bulletin_time.substring(0,10)%></font></td>
</tr>
<tr>
<td bordercolor="#CCCCCC"><font size='2'><%=bulletin_content%></font></td>
</tr>
<%}}%>
</table>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -