PageHelper基本使用

1.引入Maven依赖

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

2.进行配置

在将Mybatis交由Spring管理时，在MyBatis中引入pageHelper的插件

<!--    3.sqlSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="datasource"/>
<!--        传入pagehelper插件-->
        <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>
        <property name="configLocation" value="classpath:mybatis-conf.xml"/>
    </bean>

3.基本使用

DAO层：orderMapper.xml实现查询所有订单的操作

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.echo.dao.OrdersMapper">
    <select id="findAll" resultType="com.echo.pojo.Orders">
        select * from orders
    </select>
<!--    todo result map-->
    <resultMap id="orderProduct" type="com.echo.pojo.Orders">
        <result property="id" column="id" />
        <result property="orderNum" column="orderNum"/>
        <result property="orderTime" column="orderTime"/>
        <result property="orderStatus" column="orderStatus"/>

        <result property="peopleCount" column="peopleCount"/>
        <result property="payType" column="payType" />
        <result property="orderDesc" column="orderDesc"/>
<!--       productId是数据库中所存储的列的名字 -->
        <association property="product" column="productId" select="getProduct" />
    </resultMap>
    <select id="getProduct" resultType="com.echo.pojo.Product">
        select * from product
    </select>
</mapper>

Service层：主要就是在Service层进行使用，使用时在查询结果的语句之前进行配置就好了，使用很简单

import java.util.List;
@Service
@Transactional
public class OrdersServiceImpl implements OrdersService {
    @Autowired
    private OrdersMapper ordersMapper;

    @Override
    public List<Orders> findAll(int page,int size) {
        //pageHelper的使用就是这么简单，做完配置，然后在查询的方法前调用一下，设置一下就行，一定要和查询的代码写在一块
        //pageNum是页码值，pageSize是每页的条数
        PageHelper.startPage(page,size);
        return ordersMapper.findAll();
    }
}

Controller层：controller层在拿到分页查询的结果后，要将查询到的list结果封装到PageHelper所提供的PageInfo中进行封装，然后将这个PageInfo传递给前端，这个PageInfo是一个分页bean，里面提供了很多与分页有关的信息，包含总页数，总数据条数等等，方便使用

@Controller
@RequestMapping("/orders")
public class OrdersController {
    @Autowired
    private OrdersService ordersService;

    //查询全部订单，未分页
//    @RequestMapping("/findAll")
//    public String findAll(Model model){
//        List<Orders> orders = ordersService.findAll();
//        System.out.println(orders);
//        model.addAttribute("ordersList",orders);
//        return "orders-list";
//    }

    @RequestMapping("/findAll")
    public String findAll(@RequestParam(name="page",required = true,defaultValue = "1") int page,
                          @RequestParam(name="size",required = true,defaultValue = "4") int size,
                          Model model){
        List<Orders> orders = ordersService.findAll(page,size);
        System.out.println(orders);
        //这个pageinfo 是PageHelper提供的一个分页Bean，里面存了有关分页的很多信息，如总记录数，当前页码等
        //将分页后的list传入这个pageInfo中进行存储，然后传给页面中，然后再从页面中取
        PageInfo pageInfo = new PageInfo(orders);
        model.addAttribute("pageInfo",pageInfo);
        return "orders-list";
    }
}

视图层：从PageInfo中拿到相应的数据，进行展示

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

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