<%
final int PAGE_SIZE = 2;
int pageNo = 1;
String strPageNo = request.getParameter("pageNo");
if(strPageNo != null && !strPageNo.trim().equals("")) {
try {
pageNo = Integer.parseInt(strPageNo);
} catch (NumberFormatException e) {
pageNo = 1;
}
}if(pageNo <= 0) pageNo = 1;int totalPages = 0;List<Article> articles = new ArrayList<Article>();
Connection conn = DB.getConn();Statement stmtCount = DB.getStmt(conn);
ResultSet rsCount = DB.executeQuery(stmtCount, "select count(*) from article where pid = 0");
rsCount.next();
int totalRecords = rsCount.getInt(1);totalPages = (totalRecords + PAGE_SIZE - 1)/PAGE_SIZE;if(pageNo > totalPages) pageNo = totalPages;Statement stmt = DB.getStmt(conn);
int startPos = (pageNo-1) * PAGE_SIZE;
String sql = "select * from article where pid = 0 order by pdate desc limit " + startPos + "," + PAGE_SIZE ;
System.out.println(sql);
ResultSet rs = DB.executeQuery(stmt, sql);
while(rs.next()) {
Article a = new Article();
a.initFromRs(rs);
articles.add(a);
}
DB.close(rsCount);
DB.close(stmtCount);DB.close(rs);
DB.close(stmt);
DB.close(conn);
%>
<table border="0" cellpadding="3" cellspacing="0" width="100%">
<tbody>
<tr valign="top">
<td><span class="nobreak">第<%=pageNo %>页,共<%=totalPages %>页 - <span class="jive-paginator"> [</span></span>
<span class="nobreak"><span class="jive-paginator">
<a href="articleFlat.jsp?pageNo=1">第一页</a></span></span>
<span class="nobreak"><span class="jive-paginator">|</span></span>
<span class="nobreak"><span class="jive-paginator">
<a href="articleFlat.jsp?pageNo=<%=pageNo - 1 %>">上一页</a>
</span></span>
<span class="nobreak"><span class="jive-paginator">| </span></span>
<span class="nobreak"><span class="jive-paginator">
<a href="articleFlat.jsp?pageNo=<%=pageNo + 1 %>">下一页</a>
|
<a href="articleFlat.jsp?pageNo=<%=totalPages %>">最末页</a> ] </span> </span> </td>
</tr>
</tbody>
</table>
运行完,为什么总报这个错呢:
HTTP Status 404 - /BBS/articleFlat.jsp--------------------------------------------------------------------------------type Status reportmessage /BBS/articleFlat.jspdescription The requested resource (/BBS/articleFlat.jsp) is not available.
final int PAGE_SIZE = 2;
int pageNo = 1;
String strPageNo = request.getParameter("pageNo");
if(strPageNo != null && !strPageNo.trim().equals("")) {
try {
pageNo = Integer.parseInt(strPageNo);
} catch (NumberFormatException e) {
pageNo = 1;
}
}if(pageNo <= 0) pageNo = 1;int totalPages = 0;List<Article> articles = new ArrayList<Article>();
Connection conn = DB.getConn();Statement stmtCount = DB.getStmt(conn);
ResultSet rsCount = DB.executeQuery(stmtCount, "select count(*) from article where pid = 0");
rsCount.next();
int totalRecords = rsCount.getInt(1);totalPages = (totalRecords + PAGE_SIZE - 1)/PAGE_SIZE;if(pageNo > totalPages) pageNo = totalPages;Statement stmt = DB.getStmt(conn);
int startPos = (pageNo-1) * PAGE_SIZE;
String sql = "select * from article where pid = 0 order by pdate desc limit " + startPos + "," + PAGE_SIZE ;
System.out.println(sql);
ResultSet rs = DB.executeQuery(stmt, sql);
while(rs.next()) {
Article a = new Article();
a.initFromRs(rs);
articles.add(a);
}
DB.close(rsCount);
DB.close(stmtCount);DB.close(rs);
DB.close(stmt);
DB.close(conn);
%>
<table border="0" cellpadding="3" cellspacing="0" width="100%">
<tbody>
<tr valign="top">
<td><span class="nobreak">第<%=pageNo %>页,共<%=totalPages %>页 - <span class="jive-paginator"> [</span></span>
<span class="nobreak"><span class="jive-paginator">
<a href="articleFlat.jsp?pageNo=1">第一页</a></span></span>
<span class="nobreak"><span class="jive-paginator">|</span></span>
<span class="nobreak"><span class="jive-paginator">
<a href="articleFlat.jsp?pageNo=<%=pageNo - 1 %>">上一页</a>
</span></span>
<span class="nobreak"><span class="jive-paginator">| </span></span>
<span class="nobreak"><span class="jive-paginator">
<a href="articleFlat.jsp?pageNo=<%=pageNo + 1 %>">下一页</a>
|
<a href="articleFlat.jsp?pageNo=<%=totalPages %>">最末页</a> ] </span> </span> </td>
</tr>
</tbody>
</table>
运行完,为什么总报这个错呢:
HTTP Status 404 - /BBS/articleFlat.jsp--------------------------------------------------------------------------------type Status reportmessage /BBS/articleFlat.jspdescription The requested resource (/BBS/articleFlat.jsp) is not available.
你确认你的目录叫 BBS?
JSP中最好少量出现Java代码