SpringBoot 集成FluentMyBatis 框架之集成分页功能

我会带着你远行 2023-10-10 13:26 93阅读 0赞

## 本文基于上一篇：[SpringBoot 集成FluentMyBatis 框架之完善][SpringBoot _FluentMyBatis] ##

## FluentMyBatis 官方分页 ##

官方提供的写法是Query语句中有limit方法，**和mysql的limit关键字一致。**

**定义分页请求参数实体**

package com.single.req;
    
    import java.io.Serializable;
    import lombok.Data;
    
    @SuppressWarnings("serial")
    @Data
    public class UserReq implements Serializable {
    	/**
    	 * 每页数量
    	 */
    	private Integer pageSize;
    	/**
    	 * 页码
    	 */
    	private Integer page;
    }

## Controller层添加分页请求接口 ##

编辑UserController 添加分页接口

/**
    	 * 分页
    	 * 
    	 * @param userEntity
    	 * @return
    	 */
    	@Operation(summary = "分页")
    	@RequestMapping(value = "/page", method = RequestMethod.POST)
    	@ResponseBody
    	 @ApiImplicitParams({
             @ApiImplicitParam(name="pageSize",value="每页数量",dataTypeClass = String.class),
             @ApiImplicitParam(name="page",value="页码",dataTypeClass = String.class)
    	 })
    	public StdPagedList<UcasAuthUserEntity> page(@RequestBody UserReq pageReq) {
    		return userMapper.stdPagedEntity(new UcasAuthUserQuery().selectAll().limit(pageReq.getPage() * pageReq.getPageSize(), pageReq.getPageSize()));
    	}

## PostMan 模拟请求分页接口 ##

![watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16][]

[SpringBoot _FluentMyBatis]: https://blog.csdn.net/zhouzhiwengang/article/details/121126681
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/0eddcaf4502f43808bdfa5742c47fff2.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5Zyo5aWL5paX55qE5aSn6YGT,size_20,color_FFFFFF,t_70,g_se,x_16