package com.app.pagination;import java.util.List;/** * 通用分頁(yè)接口 * @author: super.wwz@hotmail.com * @ClassName: Pagination * @Version: v0.1 * @param <T> */ public interface Pagination<T> { /** * 判斷是否是首頁(yè) * @return */ boolean isFirst(); /** * 判斷是否是尾頁(yè) * @return */ boolean isLast(); /** * 判斷是否有上一頁(yè) * @return */ boolean isPrevious(); /** * 判斷是否有下一頁(yè) * @return */ boolean isNext();   /** * 獲取上一頁(yè)的頁(yè)碼 * @return */ int getPreviousIndex(); /** * 獲取下一頁(yè)的頁(yè)碼 * @return */ int getNextIndex(); /** * 獲取當(dāng)前頁(yè)碼 * @return */ int getPageIndex(); /** * 獲取當(dāng)前頁(yè)大小 * @return */ int getPageSize(); /** * 獲取總頁(yè)數(shù) * @return */ int getTotalPages(); /** * 獲取數(shù)據(jù)總行數(shù) * @return */ int getTotalElements();  /** * 獲取當(dāng)前頁(yè)的數(shù)據(jù) * @return */ List<T> getCurrData();  /** * 獲取數(shù)字分頁(yè)鏈接對(duì)象 * @return */ BetweenIndex getBetweenIndex();  /** * 獲取每頁(yè)顯示的分頁(yè)鏈接數(shù) * @return */ int getPageLinkNumber();  /** * 設(shè)置每頁(yè)的分頁(yè)鏈接數(shù)量 * @param pageLinkNumber */ void setPageLinkNumber(int pageLinkNumber);}

package com.app.pagination;/** * 開始鏈接-結(jié)束鏈接 * @author: super.wwz@hotmail.com * @ClassName: BetweenIndex * @Version: v0.1 */public interface BetweenIndex { /** * 獲取開始分頁(yè)鏈接索引 * @return */ int getBeginIndex(); /** * 獲取結(jié)束分頁(yè)鏈接索引 * @return */ int getEndIndex();}

package com.app.pagination.impl;import java.util.List;import com.app.pagination.BetweenIndex;import com.app.pagination.Pagination;/** * Pagination接口默認(rèn)實(shí)現(xiàn) * @author: super.wwz@hotmail.com * @ClassName: DefaultPagination * @Version: v0.1 * @param <T> */public class DefaultPagination<T> implements Pagination<T> { private int totalElements; private int pageSize; private int totalPages; private int pageIndex; private QueryHandler<T> queryHandler; private List<T> currData; private int pageLinkNumber; public DefaultPagination(int pageIndex, int pageSize, QueryHandler<T> queryHandler, int pageLinkNumber) { this(pageIndex, pageSize, queryHandler); setPageLinkNumber(pageLinkNumber); } public DefaultPagination(int pageIndex, int pageSize, QueryHandler<T> queryHandler){ //初始化數(shù)據(jù)訪問回調(diào)接口 this.queryHandler = queryHandler; //查詢總行數(shù) setTotalElements(); //修正頁(yè)大小 setPageSize(pageSize); //計(jì)算總頁(yè)數(shù): setTotalPages(); //修正頁(yè)碼 setPageIndex(pageIndex); //查詢當(dāng)前頁(yè)數(shù)據(jù) setCurrData(); } private void setCurrData() { // TODO Auto-generated method stub this.currData = queryHandler.getCurrData(pageIndex, pageSize); } private void setPageIndex(int pageIndex) { // TODO Auto-generated method stub if(pageIndex < 1) { this.pageIndex = 1; } else if(pageIndex > totalPages) { this.pageIndex = totalPages; } else { this.pageIndex = pageIndex; } } private void setTotalPages() { // TODO Auto-generated method stub if(pageSize > 0) { /*//普通算法: this.totalPages = totalElements % pageSize == 0 ?  totalElements / pageSize : (totalElements / pageSize) + 1;*/ //減一公式: this.totalPages = (totalElements + pageSize - 1) / pageSize; } } private void setPageSize(int pageSize) { // TODO Auto-generated method stub if(pageSize < 1) { this.pageSize = 1; } else if(pageSize > totalElements) { this.pageSize = totalElements; } else { this.pageSize = pageSize; } } private void setTotalElements() { // TODO Auto-generated method stub this.totalElements = queryHandler.getTotalElements(); } @Override public boolean isFirst() { // TODO Auto-generated method stub return pageIndex == 1; } @Override public boolean isLast() { // TODO Auto-generated method stub return pageIndex == totalPages; } @Override public boolean isPrevious() { // TODO Auto-generated method stub return pageIndex > 1; } @Override public boolean isNext() { // TODO Auto-generated method stub return pageIndex < totalPages; } @Override public int getPreviousIndex() { // TODO Auto-generated method stub return isPrevious() ? pageIndex - 1 : 1; } @Override public int getNextIndex() { // TODO Auto-generated method stub return isNext() ? pageIndex + 1 : totalPages; } @Override public int getPageIndex() { // TODO Auto-generated method stub return pageIndex; } @Override public int getPageSize() { // TODO Auto-generated method stub return pageSize; } @Override public int getTotalPages() { // TODO Auto-generated method stub return totalPages; } @Override public int getTotalElements() { // TODO Auto-generated method stub return totalElements; } @Override public List<T> getCurrData() { // TODO Auto-generated method stub return currData; } @Override public BetweenIndex getBetweenIndex() { // TODO Auto-generated method stub return new BetweenIndex() { private int beginIndex; private int endIndex; { boolean isOdd = pageLinkNumber % 2 == 0; int val = pageLinkNumber / 2; beginIndex = pageIndex - (isOdd ? val - 1: val); endIndex = pageIndex + val; if(beginIndex < 1) {  beginIndex = 1;  endIndex = pageLinkNumber; } if(endIndex > totalPages) {  endIndex = totalPages;  beginIndex = endIndex - pageLinkNumber + 1; } } @Override public int getEndIndex() { // TODO Auto-generated method stub return endIndex; } @Override public int getBeginIndex() { // TODO Auto-generated method stub return beginIndex; } }; } @Override public int getPageLinkNumber() { // TODO Auto-generated method stub return pageLinkNumber; } @Override public void setPageLinkNumber(int pageLinkNumber) { // TODO Auto-generated method stub if (pageLinkNumber < 0) { this.pageLinkNumber = 0; } else if (pageLinkNumber > totalPages) { this.pageLinkNumber = totalPages; } else { this.pageLinkNumber = pageLinkNumber; } }}　

package com.app.pagination.impl;import java.util.List;/** * 分頁(yè)查詢回調(diào)接口 * @author: super.wwz@hotmail.com * @ClassName: QueryHandler * @Version: v0.1 * @param <T> */public interface QueryHandler<T> { /** * 獲取數(shù)據(jù)總行數(shù) * @return */ int getTotalElements();  /** * 獲取當(dāng)前頁(yè)的數(shù)據(jù) * @param pageIndex * @param pageSize * @return */ List<T> getCurrData(int pageIndex, int pageSize);}

package com.app.dao.impl;import java.sql.SQLException;import java.util.List;import org.apache.commons.dbutils.handlers.BeanListHandler;import org.apache.commons.dbutils.handlers.ScalarHandler;import com.app.bean.Book;import com.app.dao.BaseDao;import com.app.dao.BookDao;public class BookDaoImpl extends BaseDao implements BookDao { @Override public int count() { // 查詢數(shù)據(jù)總行數(shù) String sql = "select count(1) from t_book"; try { return getQueryRunner().query(sql, new ScalarHandler<Integer>()); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return 0; } @Override public List<Book> getBooks(int pageIndex, int pageSize) { // 關(guān)于SQLServer的查詢分頁(yè)sql StringBuffer sql = new StringBuffer(); sql.append("select * from ("); sql.append(" select row_number() over(order by(id)) new_id,* from t_book"); sql.append(") t where new_id between ? and ?"); try { return getQueryRunner().query(sql.toString(),  new BeanListHandler<Book>(Book.class),  pageSize * (pageIndex - 1) + 1,pageSize * pageIndex); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; }}

package com.app.service.impl;import java.util.List;import com.app.bean.Book;import com.app.dao.BookDao;import com.app.dao.impl.BookDaoImpl;import com.app.pagination.Pagination;import com.app.pagination.impl.DefaultPagination;import com.app.pagination.impl.QueryHandler;import com.app.service.BookService;/** * 業(yè)務(wù)邏輯層查詢分頁(yè)數(shù)據(jù)示例 * @author: super.wwz@hotmail.com * @ClassName: BookServiceImpl * @Version: v0.1 */public class BookServiceImpl implements BookService { private BookDao bookDao = new BookDaoImpl(); @Override public Pagination<Book> getBookList(int pageIndex, int pageSize,int pageLinkNumber) { // TODO Auto-generated method stub return new DefaultPagination<Book>(pageIndex, pageSize, new QueryHandler<Book>() { @Override public int getTotalElements() { // TODO Auto-generated method stub return bookDao.count(); } @Override public List<Book> getCurrData(int pageIndex, int pageSize) { // TODO Auto-generated method stub return bookDao.getBooks(pageIndex, pageSize); } },pageLinkNumber); }}

package com.app.web.action;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.app.bean.Book;import com.app.pagination.Pagination;import com.app.service.BookService;import com.app.service.impl.BookServiceImpl;public class BookAction extends HttpServlet { private static final long serialVersionUID = 5275929408058702210L; private BookService bookService = new BookServiceImpl(); @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); int pageIndex = 1; int pageSize = 10; try { pageIndex = Integer.parseInt(request.getParameter("pageIndex")); pageSize = Integer.parseInt(request.getParameter("pageSize")); } catch (NumberFormatException e) { e.printStackTrace(); } //6: 顯示的分頁(yè)鏈接個(gè)數(shù) Pagination<Book> bookPagination = bookService.getBookList(pageIndex, pageSize,6); request.setAttribute("bookPagination", bookPagination); request.getRequestDispatcher("index.jsp").forward(request, response); }}

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><c:if test="${requestScope.bookPagination == null }"> <c:redirect url="bookAction?pageIndex=1&pageSize=4"></c:redirect></c:if><!DOCTYPE html"><html> <head> <title>圖書信息列表</title> <!-- Bootstrap v3.3.5 --><link href="${pageContext.request.contextPath}/bootstrap-3.3.5-dist/css/bootstrap.min.css" type="text/css" rel="stylesheet" charset="utf-8" /><link id="bootstrapTheme" href="${pageContext.request.contextPath}/bootstrap-3.3.5-dist/css/bootstrap-theme.min.css" type="text/css" rel="stylesheet" charset="utf-8" /><script src="${pageContext.request.contextPath}/bootstrap-3.3.5-dist/js/jquery.min.js" type="text/javascript" charset="utf-8"></script><script src="${pageContext.request.contextPath}/bootstrap-3.3.5-dist/js/bootstrap.min.js" type="text/javascript" charset="utf-8"></script> </head> <body> <div class="container"> <h2 class="page-header">圖書信息</h2> <table class="table table-striped table-bordered table-hover"> <tr> <th>#</th> <th>圖書名</th> <th>單價(jià)</th> </tr> <c:set var="bookPagination" value="${requestScope.bookPagination}"></c:set> <c:choose> <c:when test="${bookPagination.totalElements gt 0}">  <c:forEach var="book" items="${bookPagination.currData}">  <tr>  <td>${book.id }</td>  <td>${book.name }</td>  <td>${book.price }</td>  </tr>  </c:forEach>  <td colspan="3" align="center">  <div class="btn-group" role="group">  <c:if test="${bookPagination.first}" var="isFirst">  <a class="btn btn-primary btn-sm" disabled="disabled" href="#">首頁(yè)</a>  <a class="btn btn-success btn-sm" disabled="disabled" href="#">上一頁(yè)</a>  </c:if>  <c:if test="${not isFirst}">  <a class="btn btn-primary btn-sm" href="${pageContext.request.contextPath}/bookAction?pageIndex=1&pageSize=${bookPagination.pageSize}">首頁(yè)</a>  <a class="btn btn-success btn-sm" href="${pageContext.request.contextPath}/bookAction?pageIndex=${bookPagination.previousIndex }&pageSize=${bookPagination.pageSize}">上一頁(yè)</a>  </c:if>  <c:if test="${bookPagination.last }" var="isLast">  <a class="btn btn-success btn-sm" disabled="disabled" href="#">下一頁(yè)</a>  <a class="btn btn-primary btn-sm" disabled="disabled" href="#">尾頁(yè)</a>  </c:if>  <c:if test="${not isLast}">  <a class="btn btn-success btn-sm" href="${pageContext.request.contextPath}/bookAction?pageIndex=${bookPagination.nextIndex }&pageSize=${bookPagination.pageSize}">下一頁(yè)</a>  <a class="btn btn-primary btn-sm" href="${pageContext.request.contextPath}/bookAction?pageIndex=${bookPagination.totalPages }&pageSize=${bookPagination.pageSize}">尾頁(yè)</a>  </c:if>  </div>  </td> </c:when> <c:otherwise>  <tr><td colspan="3">沒有更多數(shù)據(jù)!</td></tr> </c:otherwise> </c:choose> </table> <center> <nav> <ul class="pagination"> <c:if test="${isFirst }">  <li class="disabled">  <a href="#" aria-label="Previous">  <span aria-hidden="true">»上一頁(yè)</span>  </a> </li> </c:if> <c:if test="${not isFirst }"> <li>  <a href="${pageContext.request.contextPath}/bookAction?pageIndex=${bookPagination.previousIndex }&pageSize=${bookPagination.pageSize}" aria-label="Previous">  <span aria-hidden="true">»上一頁(yè)</span>  </a> </li> </c:if> <c:if test="${bookPagination.pageLinkNumber gt 0}"> <c:set var="betweenIndex" value="${bookPagination.betweenIndex}"></c:set> <c:forEach var="linkIndex" begin="${betweenIndex.beginIndex}" end="${betweenIndex.endIndex}">  <c:if test="${linkIndex eq bookPagination.pageIndex}" var="isCurr">  <li class="active"><a href="#">${linkIndex}</a></li>  </c:if>  <c:if test="${not isCurr}">  <li><a href="${pageContext.request.contextPath}/bookAction?pageIndex=${linkIndex}&pageSize=${bookPagination.pageSize}" >${linkIndex}</a></li>  </c:if> </c:forEach> </c:if> <c:if test="${isLast }">  <li class="disabled">  <a href="#" aria-label="Next">  <span aria-hidden="true">下一頁(yè) »</span>  </a> </li> </c:if> <c:if test="${not isLast }"> <li>  <a href="${pageContext.request.contextPath}/bookAction?pageIndex=${bookPagination.nextIndex }&pageSize=${bookPagination.pageSize}" aria-label="Next">  <span aria-hidden="true">下一頁(yè) »</span>  </a> </li> </c:if> </ul> </nav> </center> </div> </body></html>

package com.app.service.impl;import java.util.ArrayList;import java.util.List;import com.app.bean.Book;import com.app.pagination.Pagination;import com.app.pagination.impl.DefaultPagination;import com.app.service.BookService;/** * 使用List<T>集合模擬數(shù)據(jù)庫(kù) * @author: super.wwz@hotmail.com * @ClassName: BookServiceImpl2 * @Version: v0.1 */public class BookServiceImpl2 implements BookService {// private BookDao bookDao = new BookDaoImpl(); private static List<Book> list = new ArrayList<Book>(); //初始化List<Book>數(shù)據(jù) static { list.add(new Book(1, "書名1", 18)); list.add(new Book(2, "書名2", 13)); list.add(new Book(3, "書名3", 18)); list.add(new Book(4, "書名4", 38)); list.add(new Book(5, "書名5", 18)); list.add(new Book(6, "書名6", 58)); list.add(new Book(7, "書名7", 12)); list.add(new Book(8, "書名8", 11)); list.add(new Book(9, "書名9", 13)); list.add(new Book(10, "書名10", 22)); list.add(new Book(11, "書名11", 19)); list.add(new Book(12, "書名12", 13)); list.add(new Book(13, "書名13", 19)); list.add(new Book(14, "書名14", 32)); } @Override public Pagination<Book> getBookList(int pageIndex, int pageSize, int pageLinkNumber) { return new DefaultPagination<Book>(pageIndex, pageSize, new QueryHandler<Book>() { @Override public int getTotalElements() {  //return bookDao.count(); return list.size(); } @Override public List<Book> getCurrData(int pageIndex, int pageSize) {  //return bookDao.list(pageIndex, pageSize); int fromIndex = (pageIndex - 1) * pageSize; int endIndex = fromIndex + pageSize; endIndex = endIndex > list.size() ? list.size() : endIndex; return list.subList(fromIndex, endIndex); } }, pageLinkNumber); }}