📄 post.jsp
字号:
<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@page import="java.sql.*"%>
<%@include file="top.jsp" %>
<%
request.setCharacterEncoding("gb2312");
String board_id=request.getParameter("board_id");
String topic_id=request.getParameter("topic_id");
String sql="select * from icefish_topic WHERE topic_id="+topic_id;
//Statement stmt=conn.createStatement();
//ResultSet rs=stmt.executeQuery(sql);
ResultSet rs=null;
rs=indexBean.executeSQL(sql);
boolean ismaster=false;
while(rs.next()){
%>
<html>
<head>
<title>冰鱼论坛----阅读帖子</title>
<script Language="Javascript" src="include/form.js"></Script>
</head>
<body style="text-align: center">
<table width="100%" height="50" border="0" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr><td height="20">〓 <%=session.getAttribute("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=<%=session.getAttribute("board_mother")%>&bmid=<%=session.getAttribute("board_mother_id")%>&board_id=<%=session.getAttribute("board_mother_id")%>"><%=session.getAttribute("board_mother")%></a> → <a class=zh href="board.jsp?bm=<%=session.getAttribute("board_mother")%>&bmid=<%=session.getAttribute("board_mother_id")%>&board_id=<%=session.getAttribute("board_id")%>"><%=session.getAttribute("board_name")%></a> → 发表帖子</td></tr>
</table>
<%
String sql23="select * from icefish_board where board_master='"+userBean.getUser_Name()+"' and board_id="+board_id;
ResultSet rs23=indexBean1.executeSQL(sql23);
if(rs23.next()){ismaster=true;}
if(ismaster||userBean.getUser_Admin()){
%><%@include file="manageTopic.jsp" %><%
}else
out.println("<p>");
rs23.close();
%>
<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="replypost.jsp?board_id=<%=board_id%>&topic_id=<%=topic_id%>"><img src="images/skin/1/mreply.gif" border=0></a></td></tr>
</table>
<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"><b><font color="white"> * 帖子主题：<%=rs.getString("topic_name")%></font></b></td></tr>
<%}
rs.close();
//stmt.close();
String sql2="select * from icefish_post inner join icefish_user on icefish_user.user_name = icefish_post.post_user where post_topicid="+topic_id+" or post_replyid="+topic_id+" order by post_id asc";
//Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//ResultSet rs2=stmt2.executeQuery(sql2);
ResultSet rs2=null;
rs2=indexBean.executeSQL(sql2);
int pagesize=10; //设置帖子每页显示记录数
%><%@include file="page.jsp"%><%
if(intPageCount>0){
rs2.absolute((intPage-1)*intPageSize+1);
i=0;
int j=(intPage-1)*intPageSize+1; //计算该帖为第几楼
while(i<intPageSize&&!rs2.isAfterLast()){
//while(rs2.next()){
%>
<tr height="320" valign="top">
<td width="190" align="center">
<table width="160">
<tr><td width="40"></td><td width="40"></td><td width="40"></td><td width="40"></td></tr>
<tr align="left"><td colspan="3"><font style="filter:glow(color=blue,strength=2);height:10px;color:white;padding:1px;"><%=rs2.getString("user_name")%></font></td><td><img src="<%if(rs2.getString("user_sex").equals("男")){%>images/male.gif<%}if(rs2.getString("user_sex").equals("女")){%>images/female.gif<%}%>"></td></tr>
<tr><td colspan="4"><img onload="if(this.width>150){this.width=150;}" src="<%=rs2.getString("user_face")%>"></td></tr>
<tr><td>等级：</td><td colspan="3"><%=rs2.getString("user_grade")%></td></tr>
<tr><td>帖数：</td><td align="left" colspan="3"><%=rs2.getString("user_post")%></td></tr>
<tr><td>积分：</td><td align="left" colspan="3"><%=rs2.getString("user_mark")%></td></tr>
<tr><td>门派：</td><td align="left" colspan="3"><%=rs2.getString("user_group")%></td></tr>
<tr><td>注册：</td><td align="left" colspan="3"><%=rs2.getString("user_regtime")%></td></tr>
</table>
</td>
<td>
<table width="100%">
<tr height="25" valign="center">
<td> <img src="images/skin/1/friend.gif" title="将该用户加为好友"> <img src="images/skin/1/message.gif" title="发送论坛短信给该用户"> <img src="images/skin/1/email.gif" title="此用户邮箱"> <img src="images/skin/1/profile.gif" title="查看该用户个人资料"></td>
<td align="right">第<font color="red" size="3"> <%=j%> </font>楼 <a href="#top"><img src="images/skin/1/p_up.gif" title="返回本页面顶部" border="0"></a></td>
</tr>
<tr><td colspan="2"><hr size="1" width="97%" color="#7777ff"></td></tr>
<tr height="225" valign="top" align="left"><td colspan="2"><%=rs2.getString("post_content")%></td></tr>
<tr><td colspan="2"><img src="images/skin/1/sigline.gif"></td></tr>
<tr><td colspan="2"><%=rs2.getString("user_sign")%></td></tr>
</table>
</td>
</tr>
<tr height="30" valign="center" align="center">
<td><img src="images/ip.gif" title="只有管理员才能查看IP"> <%=rs2.getString("post_time")%></td>
<td><table width="100%"><tr><td>文字广告区</td><td align="right"><img src="images/skin/1/reply.gif" title="引用回复这个帖子"> <img src="images/skin/1/reply_a.gif" title="回复这个帖子"> <%if(ismaster||userBean.getUser_Admin()||rs2.getString("user_name").equals(userBean.getUser_Name())){%><a href="editpost.jsp?board_id=<%=board_id%>&topic_id=<%=topic_id%>&post_id=<%=rs2.getString("post_id")%>"><img src="images/skin/1/edit.gif" title="重新编辑此帖" border="0"></a> <%}%><img src="images/skin/1/topicmanage.gif" title="版主对该帖子进行删除、编辑、锁定操作"></td></tr></table></td>
</tr>
<%
rs2.next();
i++;
j++;
if(i<intPageSize&&!rs2.isAfterLast()){ //判断是否为最后记录,否则,改变背景色,使上下楼之间界限明显
%>
<tr height="320" bgcolor="#dff2ed" valign="top">
<td width="190" align="center">
<table width="160">
<tr><td width="40"></td><td width="40"></td><td width="40"></td><td width="40"></td></tr>
<tr align="left"><td colspan="3"><font style="filter:glow(color=blue,strength=2);height:10px;color:white;padding:1px;"><%=rs2.getString("user_name")%></font></td><td><img src="<%if(rs2.getString("user_sex").equals("男")){%>images/male.gif<%}if(rs2.getString("user_sex").equals("女")){%>images/female.gif<%}%>"></td></tr>
<tr><td colspan="4"><img onload="if(this.width>150){this.width=150;}" src="<%=rs2.getString("user_face")%>"></td></tr>
<tr><td>等级：</td><td colspan="3"><%=rs2.getString("user_grade")%></td></tr>
<tr><td>帖数：</td><td align="left" colspan="3"><%=rs2.getString("user_post")%></td></tr>
<tr><td>积分：</td><td align="left" colspan="3"><%=rs2.getString("user_mark")%></td></tr>
<tr><td>门派：</td><td align="left" colspan="3"><%=rs2.getString("user_group")%></td></tr>
<tr><td>注册：</td><td align="left" colspan="3"><%=rs2.getString("user_regtime")%></td></tr>
</table>
</td>
<td>
<table width="100%">
<tr height="25" valign="center">
<td> <img src="images/skin/1/friend.gif" title="将该用户加为好友"> <img src="images/skin/1/message.gif" title="发送论坛短信给该用户"> <img src="images/skin/1/email.gif" title="此用户邮箱"> <img src="images/skin/1/profile.gif" title="查看该用户个人资料"></td>
<td align="right">第<font color="red" size="3"> <%=j%> </font>楼 <a href="#top"><img src="images/skin/1/p_up.gif" title="返回本页面顶部" border="0"></a></td>
</tr>
<tr><td colspan="2"><hr size="1" width="97%" color="#7777ff"></td></tr>
<tr height="225" valign="top" align="left"><td colspan="2"><%=rs2.getString("post_content")%></td></tr>
<tr><td colspan="2"><img src="images/skin/1/sigline.gif"></td></tr>
<tr><td colspan="2"><%=rs2.getString("user_sign")%></td></tr>
</table>
</td>
</tr>
<tr height="30" bgcolor="#dff2ed" valign="center" align="center">
<td><img src="images/ip.gif" title="只有管理员才能查看IP"> <%=rs2.getString("post_time")%></td>
<td><table width="100%"><tr><td>文字广告区</td><td align="right"><img src="images/skin/1/reply.gif" title="引用回复这个帖子"> <img src="images/skin/1/reply_a.gif" title="回复这个帖子"> <%if(ismaster||userBean.getUser_Admin()||rs2.getString("user_name").equals(userBean.getUser_Name())){%><a href="editpost.jsp?board_id=<%=board_id%>&topic_id=<%=topic_id%>&post_id=<%=rs2.getString("post_id")%>"><img src="images/skin/1/edit.gif" title="重新编辑此帖" border="0"></a> <%}%><img src="images/skin/1/topicmanage.gif" title="版主对该帖子进行删除、编辑、锁定操作"></td></tr></table></td>
</tr>
<%
rs2.next();
i++;
j++;}
}
}%>
</table>
<table width="100%">
<tr align="right" valign="center" width="50%">
<td>
<form name="gotopage" method="post" action="post.jsp?board_id=<%=board_id%>&topic_id=<%=topic_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="post.jsp?post.jsp?board_id=<%=board_id%>&topic_id=<%=topic_id%>&page=1">第一页</a></td><%if(intPage>1){%><td><a class=zh href="post.jsp?board_id=<%=board_id%>&topic_id=<%=topic_id%>&page=<%=intPage-1%>">上一页</a></td><%}if(intPage<intPageCount){%><td><a class=zh href="post.jsp?board_id=<%=board_id%>&topic_id=<%=topic_id%>&page=<%=intPage+1%>">下一页</a></td><%}%><td><a class=zh href="post.jsp?post.jsp?board_id=<%=board_id%>&topic_id=<%=topic_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 + -