目录

1、分页插件

a>添加配置类

 b>测试

2.xml自定义分页

a>UserMapper中定义接口方法

b>UserMapper.xml中编写SQL

c>测试

a>添加配置类

package com.csdn.mybatisplus.onfig;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;


@Configuration
@MapperScan("com.csdn.mybatisplus.mapper")
public class MyBatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor()
    {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL)); return interceptor;
    }
}

 b>测试

  @Test
    public void testPage(){
        Integer a=null;
        Page page = new Page<>(2,3);
        LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.gt(User::getAge,20);

        Page userPage = userMapper.selectPage(page, queryWrapper);
//        当前的集合对象
        List records = userPage.getRecords();
        records.forEach(System.out::println);

//        当前页码
        System.out.println(page.getCurrent());
//        当前的条数
        System.out.println(page.getSize());
//        总条数
        System.out.println(page.getTotal());
//        总页数
        System.out.println(page.getPages());
//        是否有上一页
        System.out.println(page.hasPrevious());
//        是否有下一页
        System.out.println(page.hasNext());

    }


sql语句
SELECT uid AS id,name,age,email,is_deleted FROM t_user WHERe is_deleted=0 AND (age > ?) LIMIT ?,?

2.xml自定义分页

很多时候我们需要写我们自己的分页查询条件，mp提供的分页有时候是不适用于我们的。

a>UserMapper中定义接口方法

  
    IPage getUserByAge(@Param("page") Page page,@Param("age") Integer age);

b>UserMapper.xml中编写SQL

  
        select uid as id, name, age, email,is_deleted as isDeleted
        from t_user
        where age > #{age}
    

c>测试

   @Test
    public void testPage2(){
        Page page = new Page<>(2,5);
        IPage userByAge = userMapper.getUserByAge(page, 50);
        Page pages = (Page) userByAge;
        List records = pages.getRecords();
        records.forEach(System.out::println);
    }