Springboot 整合 PageHelper 分页

1. pom.xml

<!-- 分页插件 start-->

<dependency>

   <groupId>com.github.pagehelper</groupId>

   <artifactId>pagehelper</artifactId>

   <version>5.1.2</version>

</dependency>

<dependency>

   <groupId>com.github.pagehelper</groupId>

   <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>

   <version>1.2.3</version>

</dependency>

<dependency>

   <groupId>com.github.pagehelper</groupId>

   <artifactId>pagehelper-spring-boot-starter</artifactId>

   <version>1.2.3</version>

</dependency>

<!-- 分页插件 end-->

2. application.yml

pagehelper:

    helperDialect: mysql

   reasonable: true

   supportMethodsArguments: true

   params: count=countSql

3. ShopMapper.xml 配置

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="com.youhu.vegetable.mapper.ShopMapper">

     <resultMap id="BaseResultMap" type="com.youhu.vegetable.model.Shop">

        <id column="shop_id" property="shopId" jdbcType="INTEGER"/>

       <result column="shop_name" property="shopName" jdbcType="VARCHAR"/>

       <result column=" user_id" property="userId" jdbcType="INTEGER"/>

      <result column="contact number" property="contactNumber" jdbcType="VARCHAR"/>

       <result column="shop_type" property="shopType" jdbcType="INTEGER"/>

       <result column="longitude" property="longitude" jdbcType="VARCHAR"/>

       <result column="latitude" property="latitude" jdbcType="VARCHAR"/>

      <result column="address" property="address" jdbcType="VARCHAR"/>

      <result column="add_time" property="addTime" jdbcType="VARCHAR"/>

     <result column="is_delete" property="isDelete" jdbcType="INTEGER"/>

   </resultMap>

  <select id="getShopAll" resultMap="BaseResultMap">

    select * from shop;

  </select>

</mapper>

4. dao 层

@Repository

public interface ShopMapper extends BaseMapper<Shop> {

     ArrayList<Shop>  getShopAll();

}

5. service 层

public interface ShopService {

    BaseResult getShopAll(Integer pageNum, Integer pageSize);

}

6. serviceImpl 层

@Service

public class ShopServiceImpl implements IShopService {

    @Autowired

   private ShopMapper shopMapper;



@Override

public BaseResult getShopAll(Integer pageNum, Integer pageSize) {

        PageHelper.startPage(pageNum, pageSize); // 这里是开启分页

       ArrayList<Shop> list = shopMapper.getShopAll();

       PageInfo<Shop> pageInfo = new PageInfo<Shop>(list);

       List<Shop> shopList = pageInfo.getList();

      return BaseResult.success(shopList);

  }

}

7. 效果图