📄 bbslist.jsp
字号:
<%@ page session="true" %>
<%@page pageEncoding="GB2312"%>
<%@page contentType="text/html; charset=gb2312"%>
<%request.setCharacterEncoding("GB2312");%>
<%@ include file="incdb.jsp"%>
<jsp:useBean id="bbs" class="twm.bbs" scope="page"/>
<jsp:useBean id="board" class="twm.bbsboard" scope="page"/>
<jsp:useBean id="bbscom" class="twm.bbscom" scope="page"/>
<%
int boardid,method;
String tempSTR;
boardid=0;
method=0;
String delon="false";
//byte[] tmpbyte;
tempSTR=request.getParameter("boardid");
boardid=java.lang.Integer.parseInt(tempSTR);
tempSTR=request.getParameter("method");
if (tempSTR==null){ method=0;}
else{method=java.lang.Integer.parseInt(tempSTR);}
//'method=0正常显示贴子
//'method=1搜索=主题
//'method=2搜索=发言人
//'method=3搜索=时间
//'method=4搜索=精华贴(所有版面)
//'method=8版主管理（DEL）
%>
<%
int iPageSize; // '每页显示的记录数
int iPageCount; // '页面总数
int iPageCurrent=0; // '显示的当前页面
int iPageLast=0; // '上一页
int iPageNext=0; // '下一页
int iRecordsShown;
int iRecordsCount; //记录总数
int iRecordsStart; //起始记录
int i;// '循环变量
String par="";// '查询参数
java.sql.ResultSet rs;
java.sql.ResultSet sqlRst;
int bbsid,parentid,child,bbshits,length;
String username,useremail,userip,expression,usersign,bbstopic,bbscontent,bbshot;
String boardname,boardmaster,masterword,masteremail;
java.util.Date dateandtime= new java.util.Date();
username="";
boardname="";
boardmaster="";
masterword="";
masteremail="";
board.updateBoardHits(boardid,1); //'版面点击数加1
if (board.getBoardInfo(boardid)){
boardname=board.getBoardName();
boardmaster=board.getBoardMaster();
masterword=board.getBoardMasterword();
masteremail=board.getBoardMasteremail();
} //'找出本版块资料,版名,版主,版主的话
iRecordsCount=0;
iPageCount=0;
iPageSize =10; // '每页显示10条记录,可更改部分.
//'如果是首次显示,则当前页为1,否则根据请求的页数显示
tempSTR=request.getParameter("pages");
if (tempSTR==null){ iPageCurrent=1;}
else{ iPageCurrent=java.lang.Integer.parseInt(tempSTR);}
par=request.getParameter("par");
if (par==null) {par="";}
//tmpbyte=par.getBytes("ISO8859_1");
//par=new String(tmpbyte);
iRecordsCount=bbs.getRecordsCount(method,boardid,par);
iPageCount=0;
if (iRecordsCount!=0) {
iPageCount=iRecordsCount/iPageSize;
if ((iRecordsCount%iPageSize)!=0){
iPageCount++; //页面总数；
}
}
bbscom.setPages(iPageCount,iPageCurrent);
iPageLast=bbscom.getPagesLast();
iPageNext=bbscom.getPagesNext();
iPageCurrent=bbscom.getPagesCurrent();
if (method==8) { // '管理员开关
//'method=8版主管理（DEL）
delon="false";
if (session.getValue("superlogin")!="true"){ // '非正常版主登录
%>
<script language="JavaScript">
window.location="superlog.jsp";
</script>
<%
}else{
delon="true";
}//' end if
} //'End if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>New Page 3</title>
<style type="text/css">
<!--
.header {font: 11px Tahoma, Verdana; color: #000000; font-weight: bold; background-color: #99CC66 }
.maintable {width: 100%; background-color: #EFFFCE }
.tableborder {background: #D6E0EF; border: 1px solid #000000 }
-->
</style>
<base target="rtop">
<link rel="stylesheet" type="text/css" href="bbs01.css">
</head>
<body >
<div align="center" bgcolor="#EFFFCE">
<table cellspacing="1" cellpadding="4" width="757" align="center" bgcolor="#EFFFCE">
<tr class="header">
<td height="58"><h1><div align="center">BBS</h1></td>
</tr>
</table>
</div>
<div align="center">
<table border="0" width="757">
<tr>
<td align=middle width="18%"><a href="mailto:<%=masteremail%>">(<img src="images/online_moderator.gif"width="16" height="15" border="0"> 版主:<%=boardmaster%></a>)</td>
<td width="17%" align=middle>主题：<b><i><%=boardname%></i></b></td>
<td width="65%" align=middle>板块说明：<font color="#FF0000"><%=masterword%></font></td>
</tr>
</table>
<!--表头部分 --><!--表头部分结束 -->
<table border="1" width="759" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#EFFFCE" cellspacing="0" cellpadding="3">
<tr>
<td width="30" bgcolor="#99CC66"><p align="center"><a href="bbsadd.jsp?boardid=<%=boardid%>" target="_self"><font color="#FFFFFF">留言</font></a></p></td>
<td width="30" bgcolor="#99CC66"><p align="center"><a href="bbslist.jsp?boardid=<%=boardid%>" target="_self"><font color="#FFFFFF">刷新</font></a></p></td>
<td width="30" bgcolor="#99CC66"><p align="center"><a href="query.jsp"><font color="#FFFFFF">查询</font></a></p></td>
<td width="100" bgcolor="#99CC66"><p align="center"><a href="bbslist.jsp?boardid=<%=boardid%>&method=4"><font color="#FFFFFF">精华区</font></a></p></td>
<td width="200" bgcolor="#99CC66"><p align="center">
<%if (iPageCount>1) {%>
<a href="bbslist.jsp?boardid=<%=boardid%>&pages=1&method=<%=method%>&par=<%=par%>"> <font color="#FFFFFF">首页</font></a>
<%}%>
<%if (iPageLast!=0) {%>
<a href="bbslist.jsp?boardid=<%=boardid%>&pages=<%=iPageLast%>&method=<%=method%>&par=<%=par%>"><font color="#FFFFFF">上页</font></a>
<%}%>
<%if (iPageNext!=0) {%>
<a href="bbslist.jsp?boardid=<%=boardid%>&pages=<%=iPageNext%>&method=<%=method%>&par=<%=par%>"><font color="#FFFFFF">下页</font></a>
<%}%>
<%if (iPageCount>1) {%>
<a href="bbslist.jsp?boardid=<%=boardid%>&pages=<%=iPageCount%>&method=<%=method%>&par=<%=par%>"><font color="#FFFFFF">尾页</font></a>
<%}%>
<font color="#FFFFFF"><%=iPageCurrent%>/<%=iPageCount%></font></p></td>
<td width="110" valign="middle" bgcolor="#99CC66"><form method="GET" action="bbslist.jsp" style="margin-top: 0; margin-bottom: 0">
<p align="center" style="margin-top: 0; margin-bottom: 0"><font color="#FFFFFF">转到:
<input type="text" name="pages" size="3" value="1">
页
<input type="submit" value="GO" name="GO">
</font></p>
<input type="hidden" name="boardid" value="<%=boardid%>">
<input type="hidden" name="method" value="<%=method%>">
<input type="hidden" name="par" value="<%=par%>">
</form></td>
</tr>
</table>
</div>
<%if (iPageCurrent>0){%>
<div align="center">
<table bgcolor="#EFFFCE" border="2" cellSpacing=1 cellPadding=4 width="761">
<TR class=category>
<td> </td>
<td align=middle width="14%">标题 </td>
<TD noWrap align=middle width="8%">大小</TD>
<TD align=middle width="12%">作者</TD>
<TD noWrap align=middle width="14%">发表日期</TD>
<TD noWrap align=middle width="13%">作者ID</TD>
<TD noWrap align=middle width="11%">点击率</TD>
<TD align=middle width="11%">回复次数</TD>
</TR>
<tr>
<td width="17%">
<%
sqlRst=bbs.listBbs(method,iPageSize,iPageCurrent,boardid,par);
while(sqlRst.next()){
bbsid=sqlRst.getInt("bbsid");
parentid=sqlRst.getInt("parentid");
child=sqlRst.getInt("child");
username=sqlRst.getString("username");
useremail=sqlRst.getString("useremail");
userip=sqlRst.getString("userip");
expression=sqlRst.getString("expression");
usersign=sqlRst.getString("usersign");
bbstopic=sqlRst.getString("bbstopic");
bbscontent=sqlRst.getString("bbscontent");
//dateandtime=sqlRst.getString("dateandtime");
dateandtime=sqlRst.getDate("dateandtime");
bbshits=sqlRst.getInt("bbshits");
length=sqlRst.getInt("length");
bbshot=sqlRst.getString("bbshot");
%>
<tr>
<td align=middle > <p align="left"><img src="images/06.gif" width="45" height="45" border="0"></td>
<td align=middle ><a href="bbsaddre.jsp?boardid=<%=boardid%>&bbsid=<%=bbsid%>" ><%=bbstopic%></a><img src="images/agree.gif"></td>
<td align=middle > <font color="#FF0000"><%if (length==0){%>无内容<%}else{%><%=length%>Bytes<%}%></font></td>
<td align=middle >【<a href="mailto:<%=useremail%>"><b><%=username%></b></a>】</td>
<td align=middle ><i><%=dateandtime%></i></td>
<td align=middle >ID:<%=bbsid%></td>
<td align=middle >点击:<%=bbshits%></td>
<td align=middle >回复:<%=child%></td>
</tr>
<%if (bbshot.compareTo("ok")==0){%><font color="#FF0000">★</font><%}%>
<%if (delon=="true"){%><a href="delete.jsp?bbsid=<%=bbsid%>">删除</a>
###<%if (bbshot.compareTo("ok")!=0) {%><a href="addfav.jsp?bbsid=<%=bbsid%>">加入精华区</a>
<%}else{%><a href="subfav.jsp?bbsid=<%=bbsid%>">从精华区删除</a><%}}%>
<!--跟贴开始----------------------->
<%
if ((method==0)||(method==8)||(method==4)||(method==1)) {
//if (false){
//'0正常显示 //'4 精华区显示 //'8 管理员显示 //'1搜索主题
rs=bbs.listBbsRe(bbsid); //：列出某贴的所有跟贴
while(rs.next()){
bbsid=rs.getInt("bbsid");
parentid=rs.getInt("parentid");
username=rs.getString("username");
useremail=rs.getString("useremail");
userip=rs.getString("userip");
expression=rs.getString("expression");
usersign=rs.getString("usersign");
bbstopic=rs.getString("bbstopic");
bbscontent=rs.getString("bbscontent");
//dateandtime=rs.getString("dateandtime");
dateandtime=rs.getDate("dateandtime");
bbshits=rs.getInt("bbshits");
length=rs.getInt("length");
%>
<ul>
<li type="circle">
<p align="left"><img src="images/06.gif" width="45" height="45" border="0"><a href="bbsaddre.jsp?boardid=<%=boardid%>&bbsid=<%=parentid%>" ><%=bbstopic%></a>
<<font color="#FF0000"><%if (length==0){%>无内容<%}else{%><%=length%>Bytes<%}%></font>>-【<a href="mailto:<%=useremail%>"><b><%=username%></b></a>】=<i><%=dateandtime%></i>=</li>[ID:<%=bbsid%>点击:<%=bbshits%>]
<%if (delon=="true") {%> <a href="delete.jsp?bbsid=<%=bbsid%>">删除</a><%}%>
</ul>
<%
} //end while
rs.close();
} //end if
%>
<!--跟贴结束------------------------->
<hr size="0" color="#808080">
<%
} //全部记录结束
sqlRst.close();
%>
</ul>
</table>
</div>
<!--表头部分 -->
<!--表头部分结束 -->
<%}else{ //'屏蔽错误，如果页面数为0，显示如下信息
%>
<table bgcolor="#EFFFCE" cellspacing="1" cellpadding="4" width="761" align="center" class="tableborder">
<tr><td align=middle height="32" colspan="7" class="header">
很抱歉，没有找到您所需要的记录！请重新查询！
<%
}%>
</td>
</tr></table>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -