springboot3 mybatis-plus 分页

一、自带查询的分页

1、mapper

public interface UserMapper extends BaseMapper<User> {

}

2、获取

Page<User> page = new Page<>(1, 3);
userMapper.selectPage(page, null);
System.out.println("pageSize = " + page.getSize());
System.out.println("总数 = " + page.getTotal());
System.out.println("当前页 = " + page.getCurrent());
System.out.println("当前数据 = " + page.getRecords());

 

二、自定义查询的分页

1、mapper

package com.wt.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.wt.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserMapper extends BaseMapper<User> {
    List<User> queryAll();
    // 自定义的分页查询
    IPage<User> queryByAge(IPage<User> page, @Param("age") Integer age);

}

2、mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wt.mapper.UserMapper">
    <select id="queryAll" resultType="User">
        select * from user
    </select>
    <!--自定义分页查询-->
    <select id="queryByAge" resultType="User">
        select * from user where age =#{age}
    </select>
</mapper>

3、获取

Page<User> page = new Page<>(1, 3);
userMapper.queryByAge(page, 18);
System.out.println("pageSize = " + page.getSize());
System.out.println("总数 = " + page.getTotal());
System.out.println("当前页 = " + page.getCurrent());
System.out.println("当前数据 = " + page.getRecords());