JSP分页

来源：互联网发布：java实现解压缩zip 编辑：程序博客网时间：2024/05/01 23:39

<%@ page language="java" pageEncoding="UTF-8"%>
<%@page import="java.sql.*,java.io.*,java.util.*,com.bbs.*" %>

<%
boolean isLogined = false;
if(session.getAttribute("adminLogined")!=null &&
session.getAttribute("adminLogined").toString().trim().equals("true"))
{
isLogined = true;
}

%>

<%
final int PAGE_SIZE = 10;
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.createStmt(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.createStmt(conn);
int startPos = (pageNo - 1)*PAGE_SIZE;

String sql = "select * from article where pid = 0 order by id desc limit " +startPos +","+PAGE_SIZE;
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);
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Java|Java世界_中文论坛|ChinaJavaWorld技术论坛 : Java语言*初级版</title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="images/style.css" title="Integrated Styles">
<script language="JavaScript" type="text/javascript" src="images/global.js"></script>
<link rel="alternate" type="application/rss+xml" title="RSS" href="http://bbs.chinajavaworld.com/rss/rssmessages.jspa?forumID=20">
<script language="JavaScript" type="text/javascript" src="images/common.js"></script>
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="140"><a href="http://bbs.chinajavaworld.com/index.jspa"><img src="images/header-left.gif" alt="Java|Java世界_中文论坛|ChinaJavaWorld技术论坛" border="0"></a></td>
<td><img src="images/header-stretch.gif" alt="" border="0" height="57" width="100%"></td>
<td width="1%"><img src="images/header-right.gif" alt="" border="0"></td>
</tr>
</tbody>
</table>
<br>
<div id="jive-forumpage">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr valign="top">
<td width="98%"><p class="jive-breadcrumbs">论坛: Java语言*初级版
(模仿)</p>
<p class="jive-description"> 探讨Java语言基础知识,基本语法等大家一起交流共同提高！谢绝任何形式的广告 </p>
</td>
</tr>
</tbody>
</table>
<div class="jive-buttons">
<table summary="Buttons" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td class="jive-icon"><a href="post.jsp"><img src="images/post-16x16.gif" alt="发表新主题" border="0" height="16" width="16"></a></td>
<td class="jive-icon-label"><a id="jive-post-thread" href="post.jsp">发表新主题</a> <a href="http://bbs.chinajavaworld.com/forum.jspa?forumID=20&isBest=1"></a></td>
</tr>
</tbody>
</table>
</div>
<br>
<table border="0" cellpadding="3" cellspacing="0" width="100%">
<tbody>
<tr valign="top">
<td><span class="nobreak"> 页:
第<%=pageNo %>页，共<%=totalPages %>页 - <span class="jive-paginator"> [
<a href="articleFlat.jsp?pageNo=1">第一页</a></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"> |
<a href="articleFlat.jsp?pageNo=<%=pageNo + 1%>">下一页</a></span> </span>
<span class="nobreak"><span class="jive-paginator"> |
<a href="articleFlat.jsp?pageNo=<%=totalPages%>">最末页</a>  ]</span> </span>
</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr valign="top">
<td width="99%"><div class="jive-thread-list">
<div class="jive-table">
<table summary="List of threads" cellpadding="0" cellspacing="0" width="100%">
<thead>
<tr>
<th class="jive-first" colspan="3"> 主题 </th>
<th class="jive-author"> <nobr> 作者
  </nobr> </th>
<th class="jive-view-count"> <nobr> 浏览
  </nobr> </th>
<th class="jive-msg-count" nowrap="nowrap"> 回复 </th>
<th class="jive-last" nowrap="nowrap"> 最新帖子 </th>
</tr>
</thead>
<tbody>

<%
int i=0;
for(Iterator<Article> it = articles.iterator(); it.hasNext(); )
{
Article a = it.next();

String classStr = i%2 ==0 ? "jive-even" : "jive-odd";
%>

<tr class="<%= classStr%>">
<td class="jive-first" nowrap="nowrap" width="1%"><div class="jive-bullet"> <img src="images/read-16x16.gif" alt="已读" border="0" height="16" width="16">

</div></td>
<%
if(isLogined)
{
%>
<td nowrap="nowrap" width="1%">
<%
String url = request.getScheme()+"://"+request.getServerName()+":"
+request.getServerPort()+request.getContextPath()+request.getServletPath();

url += request.getQueryString()==null ? "" :("?"+request.getQueryString());
System.out.println(url);
System.out.println(request.getRequestURI());
System.out.println(request.getRequestURL());
%>

<a href="modify.jsp?id=<%=a.getId()%>">修改</a>
<a href="delete.jsp?id=<%=a.getId()%>&isLeaf=<%=a.isIsleaf()%>&pid=<%=a.getPid()%>&from=<%=url %>">删除</a>

</td>
<%
}
%>
<td class="jive-thread-name" width="95%"><a id="jive-thread-1" href="articleDetailFlat.jsp?id=<%=a.getId()%>"><%=a.getTitle() %></a></td>
<td class="jive-author" nowrap="nowrap" width="1%"><span class=""> <a href="http://bbs.chinajavaworld.com/profile.jspa?userID=226030">fei870407</a> </span></td>
<td class="jive-view-count" width="1%"> 104</td>
<td class="jive-msg-count" width="1%"> 0</td>
<td class="jive-last" nowrap="nowrap" width="1%"><div class="jive-last-post"> <%=a.getPdate().toLocaleString() %> <br>
by: <a href="http://bbs.chinajavaworld.com/thread.jspa?messageID=780182#780182" title="jingjiangjun" style="">jingjiangjun »</a> </div></td>
</tr>

<%
i++;
}
%>
</tbody>
</table>
</div>
</div>
<div class="jive-legend"></div></td>
</tr>
</tbody>
</table>
<br>
<br>
</div>
</body>
</html>