spring boot 与pagehelper 实现分页

1、引入pom 坐标

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

2、创建PageDTO 工具类

package com.deo.common.util;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class PageDTO {

    @ApiModelProperty(value = "当前页", name = "pageNum")
    private  int pageNum=1;

    @ApiModelProperty(value = "每页条数", name = "pageSize")
    private  int pageSize=10;

}

3、创建config 配置文件

package com.deo.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.util.Properties;

/**
 * 乔亚涛 2019年10月12日11:32:01
 */
@Configuration
public class PageHelperCF {
    @Bean
    public com.github.pagehelper.PageHelper pageHelper(){
        com.github.pagehelper.PageHelper pageHelper = new com.github.pagehelper.PageHelper();
        Properties properties = new Properties();
        properties.setProperty("offsetAsPageNum","true");
        properties.setProperty("rowBoundsWithCount","true");
        properties.setProperty("reasonable","true");
        properties.setProperty("dialect","mysql");    //配置mysql数据库的方言
        pageHelper.setProperties(properties);
        return pageHelper;
    }



}

3、实现自动分页

@Override
    public PageInfo<TmcDTO> queryPage(PageDTO dto) {
        PageHelper.startPage(dto);
        return new PageInfo(tmcMapper.queryPage());
 }

<select id="queryPage" resultMap="PageMap">
    SELECT * FROM `sys_tmc` WHERE `is_del` =0
  </select>

这样就可以实现分页了