①. 分页插件

①. MyBatis Plus自带分页插件,只要简单的配置即可实现分页功能
②. 添加配置类

@Configuration
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

③. 测试

    @Test
    public void testPage(){
        Page<User>page=new Page<>(1,2);
        Page<User> userPage = userMapper.selectPage(page, null);
        List<User> records = userPage.getRecords();
        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());
    }

②. xml自定义分页

①. UserMapper中定义接口方法

@Repository
public interface UserMapper extends BaseMapper<User> {
    //根据年龄进行分页查询
    Page<User>selectPageVoByAge(@Param("page") Page<User>page, @Param("age") Integer age);
}

<mapper namespace="com.xiaozhi.mybatisplus.mapper.UserMapper">
    <select id="selectPageVoByAge" resultType="com.xiaozhi.mybatisplus.entities.User">
        select * from t_user where age>#{age}
    </select>
</mapper>

②. 测试

    @Test
    public void testSelectPageVoByAge(){
        Page<User>page=new Page<>(1,2);
        Page<User> userPage = userMapper.selectPageVoByAge(page, 20);
        List<User> records = userPage.getRecords();
        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());
    }