PageHelper分页插件使用

主要记录自己使用PageHelper分页的过程

需要的jar包

<dependency>
	    <groupId>com.github.pagehelper</groupId>
	    <artifactId>pagehelper</artifactId>
	    <version>4.0.1</version>
	</dependency>

插件的配置(SessionFactory bean属性)

	<property name="plugins">
	    <array>
	      <bean class="com.github.pagehelper.PageHelper">
	        <property name="properties">
	          <value>
	            dialect=oracle
	          </value>
	        </property>
	      </bean>
	    </array>
	  </property>

通用的JSP

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ include file="taglibs.jsp"%>
<div id="table_id_wrapper" class="dataTables_wrapper form-inline no-footer">

	<div class="dataTables_length" style="float: left;">
		<label> 共 ${page.total } 条记录 | 每页显示： <select id="pageSize" name="table_id_length" aria-controls="table_id" class="form-control input-sm">
				<option value="10" ${page.pageSize eq 10?'selected':'' }>10</option>
				<option value="25" ${page.pageSize eq 25?'selected':'' }>25</option>
				<option value="50" ${page.pageSize eq 50?'selected':'' }>50</option>
				<!-- <option value="-1" ${page.pageSize eq -1?'selected':'' }>All</option>  -->
		</select>
		</label>
	</div>

	<c:if test="${page.pages gt 1}">
		<div class="dataTables_paginate paging_simple_numbers" id="table_id_paginate" style="float: right;">
			<ul class="pagination">
				<li class="paginate_button previous ${page.pageNum eq 1?'disabled':'paginate_button_js' }" data-index="1"><a href="javascript:void(0)">最前</a></li>
				<li class="paginate_button previous ${page.pageNum eq 1?'disabled':'' }" aria-controls="table_id" tabindex="0" id="table_id_previous"><a href="javascript:void(0)">上页</a></li>
				<c:forEach items="${page.navigatepageNums }" var="index">
					<li class="paginate_button ${page.pageNum eq index?'active':'paginate_button_js' }" aria-controls="table_id" data-index="${index}"><a href="javascript:void(0)">${index }</a></li>
				</c:forEach>
				<li class="paginate_button next ${page.pageNum eq page.pages?'disabled':'' }" aria-controls="table_id" tabindex="0" id="table_id_next"><a href="javascript:void(0)">下页</a></li>
				<li class="paginate_button next ${page.pageNum eq page.pages?'disabled':'paginate_button_js' }" data-index="${page.pages }"><a href="javascript:void(0)">最后</a></li>
				<li class="display_inlineblock paginate_text"> 跳转到第 <input id="page" type="text" class="form-control input-sm" size="2"> 页
					<button id="page-forward" type="button" class="btn btn-primary btn-xs">确定š</button></li>
			</ul>
		</div>
	</c:if>
</div>
<script type="text/javascript">
$(document).ready(function() {
	

    var totalPage = Number('${page.pages}');
    var $queryForm = $('#queryForm');
    	
    $queryForm.submit(function(){
    	//$queryForm.find('input[name=page]').val($('#page').val());
    	$queryForm.find('input[name=pageSize]').val($('#pageSize').val());
    });
    
    $('#btnSubmit').on('click',function(){
    	$queryForm.find('input[name=pageNum]').val(1);
    	$queryForm.submit();
    });
    
    $('#table_id_previous').on('click',function(){
    	var page = Number($queryForm.find('input[name=pageNum]').val());
    	if(page!=1){
    		$queryForm.find('input[name=pageNum]').val(--page);
    		$queryForm.submit();
    	}
    });
    
    $('#table_id_next').on('click',function(){
    	var page = Number($queryForm.find('input[name=pageNum]').val());
    	if((page+1) <= totalPage){
    		$queryForm.find('input[name=pageNum]').val(++page);
    		$queryForm.submit();
    	}
    });
    
    $('#page-forward').on('click',function(){
        var regPage = /^[1-9]*$/;
        var page = $('#page').val();
        if(!regPage.test(page)||page==""){
			return;
            }
    	$queryForm.find('input[name=pageNum]').val($('#page').val());
    	$queryForm.submit();
    });
    
    $('li.paginate_button_js').on('click',function(){
    	var page = Number($(this).data('index'));
    	$queryForm.find('input[name=pageNum]').val(page);
    	$queryForm.submit();
    });

    $('#pageSize').on('change',function(){
    	$queryForm.find('input[name=pageNum]').val(1);
    	$queryForm.submit();
    });
})
</script>
<div class="clearfix"></div>

使用时需要注意的地方

controller

	public String selectTransLogList(TransLog transLog,HttpServletRequest request,HttpSession session,PageInfo<TransLog> page, Model model){
		Logger.info("/selectOrderInfoList");
		if (page.getPageSize() == 0) {
			page.setPageSize(10);
			page.setPageNum(1);
		}

service

	@Override
	public List<TransLog> selectTransLogList(TransLog record, PageInfo<TransLog> page) {
		if(page!=null){
			PageHelper.startPage(page.getPageNum(), page.getPageSize());
		}

JSP

默认form的id为queryForm，查询按钮id为btnSubmit

有其他需要可以重新设置分页参数

	var $queryForm = $('#queryForm');
	$queryForm.find('input[name=pageNum]').val(1);
	$queryForm.find('input[name=pageSize]').val($('#pageSize').val());
	$queryForm.submit();