pageHelper分页

首先maven的pom.xml中配置pagehelper，引入它的jar包

    <!--   分页架包      -->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.2</version>
    </dependency>

接下里创建配置文件 ，并将分页配置好

我在resouce中创建的是applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
		http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/aop
		http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
    <!--   spring + Mybatis的整合      -->
    <!-- 1.  配置数据库相关的参数  -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 2. 配置数据源   -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}" />
        <property name="maxPoolSize" value="30"/>
        <property name="minPoolSize" value="2"/>
    </bean>
    <!--  3. 配置SQLSessionFactory环境   -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入数据库连接池                -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 扫描bean，使用别名      -->
        <property name="typeAliasesPackage" value="com.zrgj.bean"></property>
        <!--  配置加载映射文件       -->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
        <!--    分页配置      -->
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                        <props>
                            <prop key="helperDialect">mysql</prop>
                            <prop key="reasonable">true</prop>
                        </props>
                    </property>
                </bean>
            </array>
        </property>
    </bean>
    <!--  4.  自动生成dao，mapper       -->
    <!--  配置扫描dao接口包，动态实现dao接口，注入到Spring容器中   -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--  给出需要扫描的dao的接口包           -->
        <property name="basePackage" value="com.zrgj.dao"/>
        <!--  注入sqlsessionfactory       -->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>
    <!--  扫描整个包  -->
    <context:component-scan base-package="com.zrgj"/>
    <!--  5. 配置事物管理器   -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--  6. 开启事物注解      -->
    <tx:annotation-driven></tx:annotation-driven>
</beans>

controller层
注意数据多了页码，还有总页数

    @RequestMapping("findAll.do")
    public ModelAndView findAll(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "5") Integer size){

        List<UserInfo> userInfoList = userInfoService.findAll(page,size);
        // 将数据保存到pageInfo - PageHelper中的内置对象
        PageInfo pi = new PageInfo(userInfoList);

        // 如果需要将数据返回到页面，都需要将数据保存到ModelAndView中进行返回
        ModelAndView mv = new ModelAndView();
        mv.addObject("pi",pi);
        mv.setViewName("user-list");

        return mv;

    }    

页面配置
原先是写死的

<div class="box-tools pull-right">
							<ul class="pagination">
								<li><a href="#" aria-label="Previous">首页</a></li>
								<li><a href="#">上一页</a></li>
								<li><a href="#">1</a></li>
								<li><a href="#">2</a></li>
								<li><a href="#">3</a></li>
								<li><a href="#">4</a></li>
								<li><a href="#">5</a></li>
								<li><a href="#">下一页</a></li>
								<li><a href="#" aria-label="Next">尾页</a></li>
							</ul>
						</div>

更改后

						     <a href="javascript:void(0);οnclick=search(1)">首页</a>
								<c:when test="${list.hasPreviousPage}">
									 <a
									 href="javascript:void(0);οnclick=search(${list.pageNum-1})">上一页
									</a>
								</c:when>
								<c:otherwise>
									<span>上一页</span>
								</c:otherwise>
							</c:choose>
							<c:forEach var="item" items="${list.navigatepageNums}">
								<c:choose>	
									<c:when test="${list.pageNum==item}">
										<span class="current">${list.pageNum}</span>
									</c:when>					
							</c:forEach>
							<c:choose>
								<c:when test="${!list.isLastPage}">
									 <a
										href="javascript:void(0);οnclick=search(${list.pageNum+1})">下一页
									</a>
								<a href="javascript:void(0);οnclick=search(${list.lastPage})">尾页</a>
								</c:when>
								<c:otherwise>
									<span>下一页</span>
									<span>尾页</span>
								</c:otherwise>
							</c:choose>
						</div>
					</div>
				</c:when>