Mybatis-plus分页查询实现

1.导入分页插件

@MapperScan("com.atguigu.mapper")
@SpringBootApplication
public class Main {
    public static void main(String[] args) {
        SpringApplication.run(Main.class, args);
    }
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        //mybatis-plus插件集合【加入到集合中,分页插件，乐观锁】
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        //分页插件
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return  mybatisPlusInterceptor;
        
    }

}

测试

    @Test
    public void testPage() {
        //分页查询
        //1.设置当前页和每页显示的条数
        Page<User> objectPage = new Page<>(1,3);
        userMapper.selectPage(objectPage,null);
        long current = objectPage.getCurrent();//当前页
        long pages = objectPage.getPages(); //总页数
        long size = objectPage.getSize(); //每页显示的条数
        long total = objectPage.getTotal(); //总记录数
        List<User> records = objectPage.getRecords(); //当前页的数据

    }

在控制台打印日志application.yml配置

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 将sql日志输出到控制台