Mybatis-Plus分页查询

1.添加配置类

@Configuration
public class MybatisPlusConfig {
    //mybatisplus分页配置类
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
    }
}

2.使用

public Page<Resfood> findByPage(int pageno, int pagesize, String sortby, String sort) {
    QueryWrapper wrapper = new QueryWrapper();
    if("asc".equalsIgnoreCase(sort)){
        wrapper.orderByAsc(sortby);
    }else{
        wrapper.orderByDesc(sortby);
    }
    Page<Resfood> page = new Page<>(pageno,pagesize);
    //执行分页查询
    Page<Resfood> resfoodPage = this.resfoodDao.selectPage(page,wrapper);
    log.info("总记录数="+resfoodPage.getTotal());
    log.info("总页数="+resfoodPage.getPages());
    log.info("当前页码="+resfoodPage.getCurrent());
    return resfoodPage;
}