ssm整合-pageHelper分页

案例需求：订单分页查询

1.在父工程pom文件导入依赖

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

2.在spring-mvc配置文件配置插件

<!-- 配置SqlSession的工厂 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageInterceptor">
                    <property name="properties">
                        <!--使用下面的方式配置参数，一行配置一个 -->
                        <value>params=value1</value>
                    </property>
                </bean>
            </array>
        </property>
    </bean>

3.控制层代码

    @RequestMapping("/findAll")
    public ModelAndView findAll(@RequestParam(name="page",required = true,defaultValue = "1") int page,@RequestParam(name="size",required = true,defaultValue = "5") int size) throws Exception {
        ModelAndView mv = new ModelAndView();
        List<Orders> list = service.findAll(page,size);
        PageInfo<Orders> info = new PageInfo<>(list);
        mv.addObject("info",info);
        mv.setViewName("orders-list");
        return mv;
    }

4.服务层代码

    @Autowired
    private OrderDao orderDao;
    public List<Orders> findAll(int page,int size) throws Exception {
        //获取第1页，10条内容，默认查询总数count
        PageHelper.startPage(page, size);
        return orderDao.findAll();
    }

5.页面分页栏

<div class="box-tools pull-right">
    <ul class="pagination">
        <li>
            <a href="${pageContext.request.contextPath}/orders/findAll?page=1&size=${info.pageSize}" aria-label="Previous">首页</a>
        </li>
        <li><a href="${pageContext.request.contextPath}/orders/findAll?page=${info.pageNum-1}&size=${info.pageSize}">上一页</a></li>
            <c:if test="${info.pages>5&&info.pages<info.pageNum+4}">
                <c:forEach begin="${info.pages-4}" end="${info.pages}" var="pageNum">
                    <li><a href="${pageContext.request.contextPath}/orders/findAll?page=${pageNum}&size=${info.pageSize}">${pageNum}</a></li>
                </c:forEach>
            </c:if>
            <c:if test="${info.pages>5&&info.pages>=info.pageNum+4}">
                <c:forEach begin="${info.pageNum}" end="${info.pageNum+4}" var="pageNum">
                    <li><a href="${pageContext.request.contextPath}/orders/findAll?page=${pageNum}&size=${info.pageSize}">${pageNum}</a></li>
                </c:forEach>
            </c:if>
            <c:if test="${info.pages<=5}">
                <c:forEach begin="1" end="${info.pages}" var="pageNum">
                    <li><a href="${pageContext.request.contextPath}/orders/findAll?page=${pageNum}&size=${info.pageSize}">${pageNum}</a></li>
                </c:forEach>
            </c:if>
        <li><a href="${pageContext.request.contextPath}/orders/findAll?page=${info.pageNum+1}&size=${info.pageSize}">下一页</a></li>
        <li>
            <a href="${pageContext.request.contextPath}/orders/findAll?page=${info.pages}&size=${info.pageSize}" aria-label="Next">尾页</a>
        </li>
    </ul>
</div>

</div>

用户控制每页有几条纪录

<div class="box-footer">
        <div class="pull-left">
            <div class="form-group form-inline">
                总共${info.pages} 页，共${info.total} 条数据。 每页
                <select class="form-control" id="changePageSize" οnchange="changePageSize()">
                    <option>${info.pageSize}</option>
                    <option>1</option>
                    <option>2</option>
                    <option>3</option>
                    <option>4</option>
                    <option>5</option>
                </select> 条
            </div>
        </div>

js函数

function changePageSize() {
            //获取下拉框的值
            var pageSize = $("#changePageSize").val();

            //向服务器发送请求，改变没页显示条数
            location.href = "${pageContext.request.contextPath}/orders/findAll?page=1&size="
                + pageSize;
        }