springboot + mybatis + pagehelper 实现分页

1，pom引入依赖

   						<!--mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        		<!-- pagehelper 分页插件 -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.12</version>
        </dependency>

2，实现的核心代码：

//sevice 中方法
    @Override
    public ResposeEntity queryEventInfoByCondition(EventParamModel epm, int pageNum, int pageSize) {
        //这个要放在查询sql语句的前面
        PageHelper.startPage(pageNum,pageSize);
        List<EventModelResult> eventModelResList = eventInfoDao.queryEventBy(epm);
        //将结果放入分页对象中
        PageInfo pi = new PageInfo<>(eventModelResList);

        return new ResposeEntity(200,"请求成功！",pi);

        //return null;
    }

//dao 中方法
    List<EventModelResult> queryEventBy(@Param("pmodel") EventParamModel pmodel);

3，sql 语句

<select id="queryEventBy" resultMap="EventModelResult"
            parameterType="com.transfar.entity.EventParamModel">

 select * from table t
 <if test="pmodel.order == 0">
      order by t.time  desc
  </if>
  
</select>