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

SpringBoot 集成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;
}

编辑UserController 添加分页接口

    
	@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 page(@RequestBody UserReq pageReq) {
		return userMapper.stdPagedEntity(new UcasAuthUserQuery().selectAll().limit(pageReq.getPage() * pageReq.getPageSize(), pageReq.getPageSize()));
	}