spring+springmvc+hibernate,实现分页功能

效果图

核心代码如下:

pagebean.java

import java.util.List;

public class PageBean<T> {
    //已知数据
    private int pageNum;    //当前页,从请求那边传过来。
    private int pageSize;    //每页显示的数据条数。
    private int totalRecord;    //总的记录条数。查询数据库得到的数据
    
    //需要计算得来
    private int totalPage;    //总页数，通过totalRecord和pageSize计算可以得来
    //开始索引，也就是我们在数据库中要从第几行数据开始拿，有了startIndex和pageSize，
    //就知道了limit语句的两个数据，就能获得每页需要显示的数据了
    private int startIndex;        
        
    
    //将每页要显示的数据放在list集合中
    private List<T> list;
    
    //分页显示的页数,比如在页面上显示1，2，3，4，5页，start就为1，end就为5，这个也是算过来的
    private int start;
    private int end;
    
    //通过pageNum，pageSize，totalRecord计算得来tatalPage和startIndex
    //构造方法中将pageNum，pageSize，totalRecord获得
    public PageBean(int pageNum,int pageSize,int totalRecord) {
        this.pageNum = pageNum;
        this.pageSize = pageSize;
        this.totalRecord = totalRecord;
        
        //totalPage 总页数
        if(totalRecord%pageSize==0){
            //说明整除，正好每页显示pageSize条数据，没有多余一页要显示少于pageSize条数据的
            this.totalPage = totalRecord / pageSize;
        }else{
            //不整除，就要在加一页，来显示多余的数据。
            this.totalPage = totalRecord / pageSize +1;
        }
        //开始索引
        this.startIndex = (pageNum-1)*pageSize ;
        //显示5页，这里自己可以设置，想显示几页就自己通过下面算法修改
        this.start = 1;
        this.end = 5;
        //显示页数的算法

        if(totalPage <=5){
            //总页数都小于5，那么end就为总页数的值了。
            this.end = this.totalPage;
        }else{
            //总页数大于5，那么就要根据当前是第几页，来判断start和end为多少了，
            this.start = pageNum - 2;
            this.end = pageNum + 2;
            
            if(start < 0){
                //比如当前页是第1页，或者第2页，那么就不如和这个规则，
                this.start = 1;
                this.end = 5;
            }
            if(end > this.totalPage){
                //比如当前页是倒数第2页或者最后一页，也同样不符合上面这个规则
                this.end = totalPage;
                this.start = end - 5;
            }
        }
    }

    public int getPageNum() {
        return pageNum;
    }

    public void setPageNum(int pageNum) {
        this.pageNum = pageNum;
    }

    public int getPageSize() {
        return pageSize;
    }

    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    public int getTotalRecord() {
        return totalRecord;
    }

    public void setTotalRecord(int totalRecord) {
        this.totalRecord = totalRecord;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getStartIndex() {
        return startIndex;
    }

    public void setStartIndex(int startIndex) {
        this.startIndex = startIndex;
    }

    public List<T> getList() {
        return list;
    }

    public void setList(List<T> list) {
        this.list = list;
    }

    public int getStart() {
        return start;
    }

    public void setStart(int start) {
        this.start = start;
    }

    public int getEnd() {
        return end;
    }

    public void setEnd(int end) {
        this.end = end;
    }
    

}

controller层

@RequestMapping("findAllStudentWithPage.do")
	public ModelAndView findAllStudentWithPage(HttpServletRequest request, HttpServletResponse response){
		
		System.out.println("findAllStudentWithPage");
		String pageNum = request.getParameter("pageNum");
		if(pageNum == null){
			pageNum="1";
		}
		PageBean<Student> pb = service.findAllStudentWithPage(Integer.parseInt(pageNum),pageSize);
		ModelAndView model = new ModelAndView();
		model.addObject("pageBean", pb);
		model.setViewName("queryAll");
		return model;
	}
	

service层

	
	public PageBean<Student> findAllStudentWithPage(int pageNum, int pageSize){
		
		List<Student> allStudent = stuDaoImpl.queryAll();
		
		int totalRecord = allStudent.size();
		
		PageBean<Student> pb = new PageBean<Student>(pageNum, pageSize, totalRecord);
		
		int startIndex = pb.getStartIndex();
		
		pb.setList(stuDaoImpl.findAll(startIndex,pageSize));
		
		return pb;
	}

dao层

public List<Student> findAll(int startIndex, int pageSize) {
		
		System.out.println(" enter findAll by pageNum and pageSize");
		Session session = sessionFactory.openSession();
		
		session.beginTransaction();
		
		//HQL语句在查询时不能使用limit关键字
		Query query = session.createQuery("from Student").setFirstResult(startIndex).setMaxResults(pageSize);
		List<Student> list = query.list();

		for(Student s : list){
			System.out.println(s);
		}
		session.close();
		return list;
	}

前台页面

<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js">
</script>
</head>
<body>

**************分割线*****************************
	<table id="show_tab" border="1">
		<tr class="trhead" id="show_tab_one">
			<th>id</th>
			<th>username</th>
		</tr>
		<c:forEach items="${requestScope.pageBean.list}" var="li">
			<tr class="trhead" id="show_tab_one">
				<th>${li.id}</th>
				<th>${li.username}</th>
			</tr>
		</c:forEach>
	</table>

	<%-- 构建分页导航 --%>
	共有${requestScope.pageBean.totalRecord}个员工，共${requestScope.pageBean.totalPage }页，当前为${requestScope.pageBean.pageNum}页
	<br />
	<a
		href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=1">首页</a>
	<%--如果当前页为第一页时，就没有上一页这个超链接显示 --%>
	<c:if test="${requestScope.pageBean.pageNum ==1}">
		<c:forEach begin="${requestScope.pageBean.start}"
			end="${requestScope.pageBean.end}" step="1" var="i">
			<c:if test="${requestScope.pageBean.pageNum == i}">
                        ${i}
                    </c:if>
			<c:if test="${requestScope.pageBean.pageNum != i}">
				<a
					href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${i}">${i}</a>
			</c:if>
		</c:forEach>
		<a
			href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${requestScope.pageBean.pageNum+1}">下一页</a>
	</c:if>

	<%--如果当前页不是第一页也不是最后一页，则有上一页和下一页这个超链接显示 --%>
	<c:if
		test="${requestScope.pageBean.pageNum > 1 && requestScope.pageBean.pageNum < requestScope.pageBean.totalPage}">
		<a	href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${requestScope.pageBean.pageNum-1}">上一页</a>
		<c:forEach begin="${requestScope.pageBean.start}"
			end="${requestScope.pageBean.end}" step="1" var="i">
			<c:if test="${requestScope.pageBean.pageNum == i}">
                        ${i}
                    </c:if>
			<c:if test="${requestScope.pageBean.pageNum != i}">
				<a
					href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${i}">${i}</a>
			</c:if>
		</c:forEach>
		<a	href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${requestScope.pageBean.pageNum+1}">下一页</a>
	</c:if>

	<%-- 如果当前页是最后一页，则只有上一页这个超链接显示，下一页没有 --%>
	<c:if
		test="${requestScope.pageBean.pageNum == requestScope.pageBean.totalPage}">
		<a
			href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${requestScope.pageBean.pageNum-1}">上一页</a>
		<c:forEach begin="${requestScope.pageBean.start}"
			end="${requestScope.pageBean.end}" step="1" var="i">
			<c:if test="${requestScope.pageBean.pageNum == i}">
                        ${i}
                    </c:if>
			<c:if test="${requestScope.pageBean.pageNum != i}">
				<a
					href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${i}">${i}</a>
			</c:if>
		</c:forEach>
	</c:if>
	<%--尾页 --%>
	<a
		href="${pageContext.request.contextPath}/findAllStudentWithPage.do?pageNum=${requestScope.pageBean.totalPage}">尾页</a>


</body>
</html>