WEB项目分页的实现【通用】

一.在工具类中封装一个获取路径的方法，用于获取jsp页面的请求路径及相关参数

 1 public static String getPath(HttpServletRequest request) {
 2         String uri = request.getRequestURI();
 3         //获取请求路径/bookstore02/BookServlet
 4 
 5         String queryString = request.getQueryString();
 6         //获取请求参数method=getPage&pageNumber=4
 7 
 8         
 9         String path=uri+"?"+queryString;
10         //拼接字符串
11         
12         //截取字符串
13         if(path.contains("&pageNumber")){
14             path = path.substring(0, path.indexOf("&pageNumber"));
15         }
16         return path;
17     }
18

二.分页的具体实现

1.创建分页实体类（bean）

  1 package com.neuedu.bean;
  2 
  3 import java.util.List;
  4 
  5 public class Page<T> {
  6  
  7     private List<T> list;     //当前页列表数据
  8     private int pageNumber;   //当前页
  9     private int totalRecord;  //总记录数
 10     private int pageSize;     //每页显示几条数据
 11     
 12 //    private int totalPage;    //总页数(需要计算得到)
 13 //    private int index;        //当前页的索引(需要计算得到)
 14     
 15     private String path;
 16     
 17     
 18     public Page() {
 19         super();    
 20     }
 21     
 22     public List<T> getList() {
 23         return list;
 24     }
 25     
 26     public int getPageNumber() {
 27         if(pageNumber<1){
 28             pageNumber=1;
 29         }
 30         if(pageNumber>getTotalPage()){
 31             pageNumber=getTotalPage();
 32         }
 33         return pageNumber;
 34     }
 35     
 36     public int getTotalPage() {
 37         
 38         if(totalRecord%pageSize==0){
 39             return totalRecord/pageSize;
 40         }else{
 41             return (totalRecord/pageSize)+1;
 42         }
 43         
 44     }
 45     
 46     public int getTotalRecord() {
 47         return totalRecord;
 48     }
 49     
 50     public int getPageSize() {
 51         return pageSize;
 52     }
 53     
 54     public int getIndex() {      //分页查询，在数据访问层调用getIndex方法获得索引值
 55         /**
 56          * pageNumber    pageSize    Index
 57          *     1              3           0
 58          *     2              3           3
 59          *     3              3           6
 60          *     
 61          *    index=(pageNumber-1)*pageSize
 62          */
 63         
 64         return (getPageNumber()-1)*getPageSize();
 65         
 66     }
 67     
 68     public void setList(List<T> list) {
 69         this.list = list;
 70     }
 71     
 72     public void setPageNumber(int pageNumber) {
 73         this.pageNumber = pageNumber;
 74     }
 75     
 76     public void setTotalRecord(int totalRecord) {
 77         this.totalRecord = totalRecord;
 78     }
 79     
 80     public void setPageSize(int pageSize) {
 81         this.pageSize = pageSize;
 82     }
 83     
 84     @Override
 85     public String toString() {
 86         return "Page [list=" + list + ", pageNumber=" + pageNumber
 87                 + ",  totalRecord=" + totalRecord
 88                 + ", pageSize=" + pageSize + "]";
 89     }
 90 
 91     public Page(int pageNumber, int totalRecord, int pageSize) {
 92         super();
 93         this.pageNumber = pageNumber;
 94         this.totalRecord = totalRecord;
 95         this.pageSize = pageSize;
 96     }
 97 
 98     public String getPath() {
 99         return path;
100     }
101 
102     public void setPath(String path) {
103         this.path = path;
104     }
105     
106 }

2.创建Dao层

①创建BookDao接口

 1 package com.neuedu.dao;
 2 
 3 import java.util.List;
 4 import com.neuedu.bean.Book;
 5 
 6 public interface BookDao {
 7     
 8     public int getTotalRecord();                                 //获取数据库总记录数
 9     public List<Book> getBookList(int index, int pageSize);      //得到请求页的数据列表
10 
11 }

②创建BookDao接口的实现类BookDaoImpl

 1 package com.neuedu.dao.impl;
 2 
 3 import java.sql.Connection;
 4 import java.sql.PreparedStatement;
 5 import java.sql.ResultSet;
 6 import java.util.List;
 7 import com.neuedu.utils.JDBCUtils;
 8 import java.sql.Connection;
 9 import java.sql.PreparedStatement;
10 import java.sql.ResultSet;
11 import java.util.ArrayList;
12 import com.neuedu.bean.Book;
13 import com.neuedu.dao.BookDao;
14 
15 public class BookDaoImpl implements BookDao{
16 
17     private Connection conn=null;
18     private PreparedStatement ps=null;
19     private ResultSet rs=null;
20     
21 
22     //查询数据库中总记录数
23     public int getTotalRecord() {
24         ResultSet rs =null;
25         int totalRecord=0;
26         try {
27             conn= JDBCUtils.getConnection();
28             String sql="select count(*) totalRecord from book";
29             ps=conn.prepareStatement(sql);
30             rs = ps.executeQuery();
31             
32             if(rs.next()){
33                 totalRecord = rs.getInt("totalRecord");
34             }
35             
36         } catch (Exception e) {
37             e.printStackTrace();
38         }finally{
39             JDBCUtils.close(conn, ps, rs);
40         }
41         
42         return totalRecord;
43         
44     }
45 
46     //访问数据库，通过limit (当前页的索引，每页显示几条数据) 实现分页查询，得到请求页的数据列表
47     public List<Book> getBookList(int index, int pageSize) {
48         ResultSet rs =null;
49         int totalRecord=0;
50         List<Book> list=new ArrayList<Book>();
51         try {
52             conn= JDBCUtils.getConnection();
53             String sql="select * from book limit ?,?";
54             ps=conn.prepareStatement(sql);
55             ps.setInt(1, index);
56             ps.setInt(2, pageSize);
57             rs = ps.executeQuery();
58             while(rs.next()){
59                 int id = rs.getInt("id");
60                 String bookName = rs.getString("book_name");
61                 String author = rs.getString("author");
62                 int price = rs.getInt("price");
63                 int sales = rs.getInt("sales");
64                 int stock = rs.getInt("stock");
65                 String imgPath = rs.getString("img_path");
66                 
67                 list.add(new Book(id, bookName, author, price, sales, stock, imgPath));
68             }
69             
70         } catch (Exception e) {
71             e.printStackTrace();
72         }finally{
73             JDBCUtils.close(conn, ps, rs);
74         }
75         return list;
76     }
77 }

3.创建service层

获取当前页的数据列表

 1 package com.neuedu.service;
 2 
 3 import java.util.List;
 4 import com.neuedu.bean.Book;
 5 import com.neuedu.bean.Page;
 6 import com.neuedu.dao.impl.BookDaoImpl;
 7 
 8 public class BookService {
 9 
10     private BookDaoImpl dao =new BookDaoImpl();
11     
12     
13     public Page<Book> getPage(int pageSize,String pageNumber){
14         int pageNum=1;
15         Page<Book> page=null;
16         try{
17             pageNum=Integer.parseInt(pageNumber);
18         }catch(Exception e) {    
19         }    
20             //1.获取总记录数
21             int totalRecord=dao.getTotalRecord();
22             //2.封装page对象
23             page=new Page<>(pageNum,totalRecord,pageSize);
24             //3.查询当前页对应的数据列表并设置到page对象中
25             List<Book> list=dao.getBookList(page.getIndex(),pageSize);
26             page.setList(list);
27         
28         return page;
29     }
30     
31     
32 }

4.创建servlet层

 1 package com.neuedu.web;
 2 
 3 import java.io.IOException;
 4 import java.util.List;
 5 
 6 import javax.servlet.ServletException;
 7 import javax.servlet.http.HttpServlet;
 8 import javax.servlet.http.HttpServletRequest;
 9 import javax.servlet.http.HttpServletResponse;
10 
11 import com.neuedu.bean.Book;
12 import com.neuedu.bean.Page;
13 import com.neuedu.service.BookService;
14 import com.neuedu.utils.WEBUtils;
15 
16 
17 public class BookServlet extends BaseServlet {
18     private static final long serialVersionUID = 1L;
19 
20     private BookService service=new BookService();
21     
22     public void getPage(HttpServletRequest request, HttpServletResponse response){
23         
24         String path=WEBUtils.getPath(request);
25         String pageNumber = request.getParameter("pageNumber");
26         Page<Book> page = service.getPage(pageSize, pageNumber);
27         page.setPath(path);
28         
29         request.setAttribute("page", page);
30         try {
31             request.getRequestDispatcher("/pages/manager/book_manager.jsp").forward(request, response);
32         } catch (Exception e) {
33             e.printStackTrace();
34         }
35     }
36  }   
37

三.前台页面的实现

 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3 <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"  %>    
 4 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 5 <div id="page_nav">
 6     <a href="${page.path}&pageNumber=1">首页</a>
 7     <c:if test="${page.pageNumber>1}">
 8         <a href="${page.path}&pageNumber=${page.pageNumber-1}">上一页</a>
 9     </c:if>
10 
11     <c:choose>
12         <c:when test="${page.totalPage<=5}">
13             <c:set var="begin" value="1"></c:set>
14             <c:set var="end" value="${page.totalPage}"></c:set>
15         </c:when>
16         <c:when test="${page.pageNumber<=3}">
17             <c:set var="begin" value="1"></c:set>
18             <c:set var="end" value="5"></c:set>
19         </c:when>
20         <c:when test="${page.pageNumber>3}">
21             <c:set var="begin" value="${page.pageNumber-2 }"></c:set>
22             <c:set var="end" value="${page.pageNumber+2 }"></c:set>
23             <c:if test="${page.pageNumber+2>=page.totalPage}">
24                 <c:set var="end" value="${page.totalPage}"></c:set>
25                 <c:set var="begin" value="${page.totalPage-4}"></c:set>
26             </c:if>
27         </c:when>
28     </c:choose>
29     
30     <c:forEach begin="${begin}" end="${end}" var="index">
31         <c:if test="${page.pageNumber==index}">
32             <a href="${page.path}&pageNumber=${page.pageNumber}">【${index}】</a>
33         </c:if>
34         <c:if test="${page.pageNumber!=index}">
35             <a href="${page.path}&pageNumber=${index}">${index}</a>
36         </c:if>
37     </c:forEach>
38 
39     <c:if test="${page.pageNumber<page.totalPage}">
40         <a href="${page.path}&pageNumber=${page.pageNumber+1}">下一页</a>
41     </c:if>
42     
43     <a href="${page.path}&pageNumber=${page.totalPage}">末页</a>
44     共${page.totalPage}页，${page.totalRecord}条记录到第<input value="${page.pageNumber}" name = "pn" id ="pn_input"/>页
45     <input id="btn" type="button" value="确定"/>
46     
47     <script type="text/javascript">
48         $(function(){
49             $("#btn").click(function(){
50                 var pageNum=$("#pn_input").val();
51                 window.location="${page.path}&pageNumber="+pageNum;
52             });
53         });
54     </script>
55     
56 </div>

 

posted on 2017-12-26 20:06  ALWAYS☆REMIND  阅读(2292)  评论(0)  编辑  收藏  举报

导航