mybatis-plus 分页小结

记录贴，主要内容来源于
1.https://baomidou.com/guide/page.html
2.https://gitee.com/baomidou/mybatis-plus-samples/tree/master/mybatis-plus-sample-pagination

pagehelper 请移步https://blog.csdn.net/weixin_51084602/article/details/108814071

1.环境准备略

默认你的项目已经使用mybatis并能正常连接数据库进行增删改查了

2.引入分页插件

请看链接1，我是用的是

//Spring boot方式
@Configuration
@MapperScan("com.baomidou.cloud.service.*.mapper*")
public class MybatisPlusConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        return paginationInterceptor;
    }
}

这样，我们的mapper就能使用selectPage方法了

3.使用分页

新建测试类略

    @Resource
    UserMapper userMapper;
	/*最简单的使用方式*/
    @Test
    public void test1(){
    	IPage<User> result = userMapper.selectPage(new Page<User>(1,2), null);
    	List<User> list = result.getRecords();
    	for(User user : list){
            System.out.println(user.getUserId());
        }
    }
    /*序列化,导包fastjson*/
    @Test
    public void test2(){
    	IPage<User> result = userMapper.selectPage(new Page<User>(1,2), null);
    	List<User> list = result.getRecords();       
    	String json = JSON.toJSONString(list);
    	System.out.println(json);
   	}
   	/*增加条件*/
    @Test
    public void test3(){
    	IPage<User> result1 = userMapper.selectPage(new Page<User>(1,2).addOrder(OrderItem.asc("user_id")), null);
    	IPage<User> result2 = userMapper.selectPage(new Page<User>(1,2), Wrappers.<User>lambdaQuery().orderByAsc(User::getUserId));
    	IPage<User> result3 = userMapper.selectPage(new Page<User>(1,2), Wrappers.<User>lambdaQuery().like(User::getUsername,"赵").orderByAsc(User::getUserId));
    	List<User> list = result1.getRecords();//展示result1       
    	String json = JSON.toJSONString(list);
    	System.out.println(json);
   	}

还可以用注解，感兴趣的自己下载链接2的代码学习吧