📄 board.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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 http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%!String Forum_Name,Forum_Mastor,Forum_Id;%>
<%
String fid=request.getParameter("fid");
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENEITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
String sql="Select Forum_Id,Forum_Name,Manager_Name from Forum_Id="+fid;
rs=stmt.executeQuery(sql);
while(rs.next())
{
Forum_Name=rs.getString("Forum_Name");
Forum_Id=rs.getString("Forum_Id");
Forum_Mastor=rs.getString("Manager_Name");
}
%>
<tr>
<td bgcolor="#ffffff" width="70%"><br>
<a href="index.jsp">梦幻论坛</a>>><%=Forum_Name%></td>
<td bgcolor="#FFFFFF" class="post" align="right" width="30%">论坛版主:
<%=Forum_Mastor%> <a href="post.jsp?fid=<%Forum_Id%>"><img src="IMAGES/TOPIC.GIF" border="0" /></a></td>
</tr></table>
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<tr><td bgcolor="#009ACE">
<table border="0" cellspacing="1" cellpadding="6" width="100%" height="58">
<tr bgcolor="#9ccfff">
<td width="4%" height="14" bgcolor="#66cc99"> </td>
<td width="30%" height="14" align="center" bgcolor="#66cc99">文章标题</td>
<td width="8%" height="14" align="center" bgcolor="#66cc99">新窗口</td>
<td width="10%" height="14" align="center" bgcolor="#66cc99">作者</td>
<td width="10%" height="14" align="center" bgcolor="#66cc99">回复数量</td>
<td width="10%" height="14" align="center" bgcolor="#66cc99">浏览数量</td>
<td width="25%" height="14" align="center" bgcolor="#66cc99">最后回复</td>
</tr>
<%! String Note_Id,Note_Name,Replay_Name,Note_Author,Replay_Time;%>
<%
//每页显示的帖子数量为8个,还有一行为标题栏,总共9行数据
int PageSize=9;
//记录页数为0
int RecordCount=0;
//总页数为0
int PageCount=0;
int ShowPage=1;
sql="select * from Card where Board_Id="+fid+"and Reply_Id=0 order by Card_Id desc";
rs=stmt.executeQuery(sql);
rs.last();
RecordCount=rs.getRow();
PageCount=(RecordCount%
PageSize==0)?(RecordCount/PageSize):(RecordCount/PageSize+1);
String Page=request.getParameter("page");
if(Page!=null)
{
showPage=Integer.parseInt(Page);
if(ShowPage>PageCount)
ShowPage=PageCount;
else if(ShowPage<0)
ShowPage=1;
}else
ShowPage=1;
if(RecordCount>0)
{
Note_Id=rs.getString("Card_Id");
Note_Name=rs.getString("Card_Name");
Note_Author=rs.getString("Card_Author");
Replay_Name=rs.getString("Reply_User");
Replay_Time=rs.getString("Reply_Time");
%>
<tr bgcolor="#f7fbff">
<td align="center" height="16"><img src="IMAGES/<%=rs.getStrng("Card_Image")%>.GIF"></td>
<td height="16" bgcolor="#f7fbff"><a href="shownote.jap?fid=<%=Forum_Id%>¬eid=<%=Note_Id%>"><%=Note_Name%></a> </td>
<td height="16" align="center" bgcolor="#f7fbff"><a href="shownote.jsp?fid=<%=Forum_Id%>¬eid=<%=Note_Id%>" target="_blank"><img src="image/newwin.gif" border="0"></a></td>
<td align="center" height="16" ><a href="member.jsp?member=<%Note_Author%>"><%=Note_Author%></a></td>
<td align="center" height="16"><%=rs.getString("Reply_Times")%></td>
<td align="center" height="16"><%=rs.getString("Click_Times")%></td>
<td height="16">时间:<%Repaly_Time.substring(1,16)%><br>
作者:<a href="member.jsp?member=<%=Replay_Name%>"><%=Replay_Name%></a></td>
</tr>
<%
if(!rs.next())
break;
}
}
else
{
%>
<tr bgcolor="#f7fbff">
<td align="center" height="16" colspan="7" width="100%">对不起,该论坛暂时没有帖子</td>
</tr>
<%
}
%>
</table>
</td></tr></table>
<br>
<table width="733" cellspacing="0" cellpadding="0" align="center" height="2">
<tr>
<td width="524" height="2" valign="top"> </td>
<td align="right" width="205" height="2">
<form method="post" action="board.jsp">
<p><input type="hidden" name="fid" size="20" value="<%=Forum_Id%>"></p>
<p>第<font color="black"><%=ShowPage%></font>页转到
<select size="1" name="page">
<%
for(int i=1;i<=PageCount;i++){
out.println("<option value="+i+">"+i+"页</option>");
}
%>
</select>
<input type="submit" value="go" name="B1"></p>
</form> </td></tr>
<jsp:include page="inc/jumpboard.jsp" flush="true"/>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -