📄 list.jsp
字号:
<%!
ResultSet rs;
long rowCount,pageCount=0;
int pageSize =15;
String sql = null;
%>
<html>
<head>
<title>BBS</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../bbs.css">
</head>
<script language="javascript">
function openpage(pageurl) {
var newwin = window.open(pageurl,'查看资料','toolbar=no,directories=no,status=no,width=300,height=200');
return false;
}
</script>
<body bgcolor="#FFF9F0" topmargin="0">
<table width="606" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#FFFFFF" align="left" valign="top"><img src="../images/bbs_logo.gif" width="149" height="77"></td>
<td bgcolor="#FFFFFF" align="center" valign="middle"><img src="../../../sz/images/banner.gif" width="412" height="63"></td>
</tr>
</table>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn = OPDB.getConn();
String boardid = request.getParameter("boardid");
//取版主资料
String boardname ="";
String boardmaster ="";
String masteremail ="";
sql = "select boardname,boardmaster,masteremail from t_board ";
sql += "where boardid = " + boardid;
rs = OPDB.select(conn,sql);
if(rs.next()) {
boardname = OPDB.GBK(rs.getString("boardname"));
boardmaster = OPDB.GBK(rs.getString("boardmaster"));
masteremail = OPDB.GBK(rs.getString("masteremail"));
}
rs.close();
//总记录数，总页数
sql = "select id from t_bbs where boardid = " + boardid;
rs = OPDB.select(conn,sql);
rowCount =OPDB.getRowcount();
rs.close();
if (rowCount % pageSize == 0) {
pageCount = rowCount/pageSize;
if (pageCount == 0) {
pageCount = 1;
}
}
else {
pageCount = rowCount/pageSize+1;
}
//分页的初始化
int pages = 1;
int intStart = 0;
int intEnd = 0;
if (request.getParameter("page") != null) {
pages = Integer.parseInt(request.getParameter("page"));
}
intStart = (pages - 1) * pageSize;
intEnd = pages * pageSize;
//显示导航条
%>
<table width="100%" border="1" bordercolor="#000000">
<tr bgcolor="#FF9900">
<td height="20" bordercolor="#FF9900">
<div align="center"><a href="listgood.jsp?boardid=<%= boardid %>">>>精华</a>
<%
if (pages == 1) {
out.print("首页");
out.print(" 上页");
}
else {
out.print("<a href=\"list.jsp?boardid="+boardid+"&page=1\">首页</a>");
out.print(" <a href=\"list.jsp?boardid="+boardid+"&page="+(pages-1)+"\">上页</a>");
}
if (pages == pageCount) {
out.print(" 下页");
out.print(" 尾页");
}
else {
out.print(" <a href=\"list.jsp?boardid="+boardid+"&page="+(pages+1)+"\">下页</a>");
out.print(" <a href=\"list.jsp?boardid="+boardid+"&page="+pageCount+"\">尾页</a>");
}
out.print(" 页次：");
out.print(pages);
out.print("/"+pageCount+"页 共"+rowCount+"条记录 ");
%>
<a href="addnew.jsp?boardid=<%= boardid %>" target="boardAnnounce">我要发言</a> 斑竹：<a href="mailto:<%= masteremail %>"><%= boardmaster %></a>
版面：<%= boardname %> <a href="list.jsp?boardid=<%= boardid %>&page=<%= pages %>"><<刷新</a></div>
</td>
</tr>
</table>
<%
//初始化变量
String id = "";
String face = "";
String type = "";
String txtlong = "";
String name = "";
int layer,i;
String listtrip = "";
String topic = "";
String lasttime = "";
boolean firstboard = true;
//显示论坛
sql = "select id,face,type,txtlong,name,layer,topic,lasttime from v_bbs ";
sql += "where id not in (select id from v_bbs where rownum <= " + intStart;
sql += " and boardid = " + boardid + ") ";
sql += "and id in (select id from v_bbs where rownum <= " + intEnd;
sql += " and boardid = " + boardid + ") order by topid desc,bbsorder";
//out.print(sql);
ResultSet rs1 = OPDB.select(conn,sql);
while (rs1.next()) {
firstboard = false;
id = rs1.getString("id");
face = rs1.getString("face");
type = OPDB.GBK(rs1.getString("type"));
txtlong = rs1.getString("txtlong");
name = OPDB.GBK(rs1.getString("name").trim());
layer = Integer.parseInt(rs1.getString("layer"));
topic = OPDB.GBK(rs1.getString("topic").trim());
lasttime = rs1.getString("lasttime");
//设置树状结构
listtrip = " ";
i = 1;
while (i < layer) {
listtrip = listtrip + " ";
i++;
}
//设置显示的每行内容
%>
<table border="0" cellpadding="0" cellspacing="0">
<tr><td valign="top"><%= listtrip %><img src="../images/mod<%= face %>.gif"> </td>
<td><a href="show.jsp?boardid=<%= boardid %>&id=<%= id %>" target="boardAnnounce">
<%= topic %></a> [<%= type %>]-< <%= txtlong %> 字节>
<% if (!name.equals("过客")) { %><a href="../userdetail.jsp?name=<%= name %>" onclick="return openpage(this.href);"><%= name %></a>
<% } else out.print("<font color='#0000cc'>"+name+"</font>");%> 【<%= lasttime %> ID:<%= id %>】</td></tr></table>
<%
}
//没有帖子
if (firstboard) {
%>
<p>这个版还没有帖子，我要<a href="addnew.jsp?boardid=<%= boardid %>" target="boardAnnounce">发言</a></p>
<%
}
rs1.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -