1、定义mapper类
@Repository
public interface UserMapper extends BaseMapper<User> {
/**
* 自定义sql分页
* @param page
* @return
*/
Page<User> GetUserListByPage(@Param("page") Page<User> page);
}
2、xml文件
<select id="GetUserListByPage" resultType="com.example.springbootmybatisplus.pojo.User">
select * from user
</select>
3、测试用例
void GetUserCustomize(){
Page<User> page = new Page<>(2,2);
Page<User> userPage = userMapper.GetUserListByPage(page);
System.out.println("查询结果");
System.out.println(userPage.getRecords());
System.out.println("总数");
System.out.println(userPage.getTotal());
}
4、如果关闭分页,则page和pageSize都传-1即可