MyBatis分页插件

一：导入依赖

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

二:添加配置

@SpringBootApplication
@MapperScan(basePackages = "com.hjy.essays.mapper")
public class EssaysApplication {

    public static void main(String[] args) {
        SpringApplication.run(EssaysApplication.class, args);
    }

    //配置mybatis的分页插件pageHelper
    @Bean
    public PageHelper pageHelper() {
        PageHelper pageHelper = new PageHelper();
        Properties props = new Properties();
        props.setProperty("dialect", "mysql");
        // 表示支持从接口中读取pageNum和pageSize
        props.setProperty("supportMethodsArguments", "true");
        pageHelper.setProperties(props);
        return pageHelper;
    }


}

 

三：mapper的sql正常写，不用加限制。

 

四：分页实现

调用mapper前加上下面代码，curPageIn表示当前页数，pageNumIn表示每页数据量

PageHelper.startPage(curPageIn, pageNumIn);

@Override
    public RespBean getEssaysByPage(String curPage, String pageNum) {
        int curPageIn = Integer.parseInt(curPage);
        int pageNumIn = Integer.parseInt(pageNum);
        PageHelper.startPage(curPageIn, pageNumIn);
        List<Essay> list=essayMapper.getEssaysByPage();
        PageInfo<Essay> pageInfo=new PageInfo<>(list);
        RespBean respBean=new RespBean();
        respBean.setStatus(200);
        respBean.setMsg("success");
        respBean.setObj(pageInfo.getList());
        return respBean;
    }

封装list到PageInfo对象进行分页