📄 board.jsp
字号:
<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@page import="java.sql.*"%>
<%@include file="top.jsp" %>
<%
request.setCharacterEncoding("gb2312");
String board_mother=request.getParameter("bm");//URL传递中文为乱码，需作处理
System.out.print(board_mother);
String board_mother_id=request.getParameter("bmid");//决定了父板块
String board_id=request.getParameter("board_id");
//取出父板块
String sql5="select board_name from icefish_board WHERE board_id="+board_mother_id;
ResultSet rs5=null;
rs5=indexBean.executeSQL(sql5);
while(rs5.next()){
board_mother=rs5.getString(1);
}
//
String sql1="select * from icefish_board WHERE board_id="+board_id;
ResultSet rs1=null;
rs1=indexBean.executeSQL(sql1);
while(rs1.next()){
%>
<html>
<head>
<title><%=rs1.getString("board_name")%>----冰鱼论坛『冰鱼论坛管理系统』</title>
</head>
<body>
<table width="100%" height="50" border="0" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr><td height="20">〓 <%=rs1.getString("board_info")%></td></tr>
<tr bgcolor="#dff2ed"><td><img src="images/skin/1/forum_nav.gif"> <a class=zh href="">冰鱼论坛</a> → <a class=zh href="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=board_mother_id%>"><%=board_mother%></a> → <a class=zh href="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=rs1.getString("board_id")%>"><%=rs1.getString("board_name")%></a> → 帖子列表</td></tr>
</table><p>
<% //以下判断版块是否为主版块,是就列出其下相应的子版块,否则跳过
boolean board_isMother=rs1.getBoolean("board_isMother");
if (board_isMother == true){
String sql0="select * from icefish_board WHERE board_bid="+board_id+" order by board_id asc";
//Statement stmt0=conn.createStatement();
//ResultSet rs0=stmt0.executeQuery(sql0);
ResultSet rs0=null;
//Connection conn=null;
rs0=indexBean.executeSQL(sql0);
%>
<table width="100%" border="1" bordercolorlight="#7777FF" bordercolordark="#7777FF" style="border-collapse:collapse">
<tr>
<td height="25" colspan="2" background="images/skin/1/bg_td.gif" valign="middle"><b><font color="#ffffff"> <img src="images/skin/1/nofollow.gif"> <a class=xh href="board.jsp?bm=<%=rs1.getString("board_name")%>&bmid=<%=board_mother_id%>&board_id=<%=rs1.getString("board_id")%>"><%=rs1.getString("board_name")%></a></font></b></td>
</tr>
<%
while(rs0.next()){%>
<tr>
<td height="85" valign="middle" align="center" width="43"><img src="images/skin/1/forum_nonews.gif"></td>
<td>
<table width="100%" height="100%" border="2" bordercolorlight="#ffffff" bordercolordark="#ffffff" style="border-collapse:collapse">
<tr>
<td valign="top"><a class=zh href="board.jsp?bm=<%=rs1.getString("board_name")%>&bmid=<%=board_mother_id%>&board_id=<%=rs0.getString("board_id")%>"><%=rs0.getString("board_name")%></a><br><img src="images/skin/1/forum_readme.gif"><%=rs0.getString("board_info")%></td>
<td width="27%">主题：<br>发帖：<br>日期：</td>
</tr>
<tr bgcolor="#dff2ed" height="23">
<td> 版主：<%=rs0.getString("board_master")%></td>
<td><img src="images/skin/1/forum_today.gif"><img src="images/skin/1/forum_topic.gif"><img src="images/skin/1/forum_post.gif"></td>
</tr>
</table>
</td>
</tr>
<%
}
rs0.close();
//stmt0.close();
%></table><p><%
}
//以上判断版块是否为主版块,是就列出其下相应的子版块,否则跳过
%>
<table width="100%" height="60" border="1" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr bgcolor="#dff2ed"><td valign="middle" align="center"><%if(ad3_img==null||ad3_img.equals("")){%>此处可放置广告（版块大幅广告）<%}else{%><a href="<%=ad3_url%>"><img border="0" onload="javascript:if(this.width>979){this.width=979;}" src="<%=ad3_img%>" title="<%=ad3_title%>"></a><%}%></td></tr>
</table>
<table width="100%" height="40" border="0" style="border-collapse:collapse">
<tr valign="bottom"><td><a href="addpost.jsp?board_id=<%=board_id%>"><img src="images/skin/1/postnew.gif" border="0"></a> <a href=""><img src="images/skin/1/xzb.gif" border="0"></a></td></tr>
</table>
<table width="100%" border="1" bordercolorlight="#7777FF" bordercolordark="#7777FF" style="border-collapse:collapse">
<tr height="25"><td colspan="7" valign="center" align="left"> <img src="images/skin/1/team2.gif"> 版主：<%=rs1.getString("board_master")%></td></tr>
<tr height="25" align="middle">
<td background="images/skin/1/bg_td.gif"><b><font color="#ffffff">状态</font></b></td>
<td background="images/skin/1/bg_td.gif"><b><font color="#ffffff">主 题 (点 <img src="images/skin/1/plus.gif"> 即可展开贴子列表)</font></b></td>
<td background="images/skin/1/bg_td.gif"><b><font color="#ffffff">作 者</font></b></td>
<td background="images/skin/1/bg_td.gif"><b><font color="#ffffff">回复</font></b></td>
<td background="images/skin/1/bg_td.gif"><b><font color="#ffffff">人气</font></b></td>
<td background="images/skin/1/bg_td.gif" colspan="2"><b><font color="#ffffff">最后更新</font></b></td>
</tr>
<%session.setAttribute("board_mother",board_mother);
session.setAttribute("board_mother_id",board_mother_id);
session.setAttribute("board_id",rs1.getString("board_id"));
session.setAttribute("board_name",rs1.getString("board_name"));
session.setAttribute("board_info",rs1.getString("board_info"));
}
rs1.close();
//stmt1.close();
String sql2="select * from icefish_topic WHERE topic_boardid="+board_id+" order by topic_top desc, topic_id desc";
// Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
// ResultSet rs2=stmt2.executeQuery(sql2);
ResultSet rs2=null;
//Connection conn=null;
rs2=indexBean.executeSQL(sql2);
int pagesize=45; //设置每页显示记录数
%>
<%@include file="page.jsp"%>
<%
// while(rs2.next()){
if(intPageCount>0){
rs2.absolute((intPage-1)*intPageSize+1);
i=0;
while(i<intPageSize&&!rs2.isAfterLast()){
boolean topic_top=rs2.getBoolean("topic_top");
boolean topic_best=rs2.getBoolean("topic_best");
%>
<tr height="25" align="middle" valign="center">
<td width="30" bgcolor="#dff2ed"><%if(topic_top==true&&topic_best==false){%><img title="置顶帖子，点击右边标题可浏览该帖" src="images/skin/1/ztop.gif"><%}else if(topic_best==true){%><img title="精华帖子，点击右边标题可浏览该帖" src="images/skin/1/isbest.gif"><%}else{%><img src="images/skin/1/folder.gif" title="点击右边标题可浏览该帖"><%}%></td>
<td width="55%" align="left"><img src="images/skin/1/plus.gif"> <a class=zh href="post.jsp?board_id=<%=rs2.getString("topic_boardid")%>&topic_id=<%=rs2.getString("topic_id")%>"><%=rs2.getString("topic_name")%></td>
<td bgcolor="#dff2ed" width="80"><%=rs2.getString("topic_user")%></td>
<td><%=rs2.getString("topic_replynum")%></td>
<td><%=rs2.getString("topic_hits")%></td>
<td bgcolor="#dff2ed" width="150"><%=rs2.getString("topic_time")%></td>
<td bgcolor="#dff2ed" width="80"><%=rs2.getString("topic_lastreplyid")%></td>
</tr>
<%
rs2.next();
i++;
}
}%>
</table>
<table width="100%">
<tr align="right" valign="center" width="50%">
<td>
<form method="post" action="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=board_id%>">
<table border="1" bordercolorlight="#7777FF" bordercolordark="#7777FF">
<tr>
<td bgcolor="#7799FF" title="该版块总主题数"><font color="white" size="3"><b><%=intRowCount%></b></font></td><td bgcolor="#7799ff" title="当前页主题数"><font color="white" size="3"><b><%=intPageSize%></b></font></td><td bgcolor="#7799ff"><font color="white" size="2">页次:<%=intPage%>/<%=intPageCount%>页 <%=intPageSize%>条/页 </font></td><td><a class=zh href="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=board_id%>&page=1">第一页</a></td><%if(intPage>1){%><td><a class=zh href="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=board_id%>&page=<%=intPage-1%>">上一页</a></td><%}if(intPage<intPageCount){%><td><a class=zh href="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=board_id%>&page=<%=intPage+1%>">下一页</a></td><%}%><td><a class=zh href="board.jsp?bm=<%=board_mother%>&bmid=<%=board_mother_id%>&board_id=<%=board_id%>&page=<%=intPageCount%>">最末页</a></td><td bgcolor="#7799FF"><input type="text" name="page" value="" size="5"><input type="submit" value="转到该页"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<%
rs2.close();
//stmt2.close();
//conn.close();
indexBean.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -