如果出现分页页码不对问题,可以先只查ID
1.xml
Mapper
接受类
PageVO
package com.qrkjdiy.common.dto; import com.qrkjdiy.common.utils.StringUtils; import lombok.Data; import java.io.Serializable; /** * 查询参数 * * @author qr.lihailin */ @Data public class PageVO implements Serializable { private static final long serialVersionUID = 1L; // @ApiModelProperty(value = "页号") private Integer pageNumber = 1; // @ApiModelProperty(value = "页面大小") private Integer pageSize = 10; // @ApiModelProperty(value = "总个数") private Long total = 0L; // @ApiModelProperty(value = "总页数") private Long Pages = 0L; // @ApiModelProperty(value = "排序字段") private String sort; // @ApiModelProperty(value = "排序方式 asc/desc") private String order; // @ApiModelProperty(value = "款式去重参数,传0为去重") private String cutRepeat; // @ApiModelProperty(value = "需要驼峰转换蛇形", notes = "一般不做处理,如果数据库中就是蛇形,则这块需要处理。") private Boolean notConvert; public Integer getMongoPageNumber() { int i = pageNumber - 1; if (i < 0) { return pageNumber; } else { return i; } } public String getSort() { if (!StringUtils.isEmpty(sort)) { if (notConvert == null || Boolean.FALSE.equals(notConvert)) { return StringUtils.camel2Underline(sort); } else { return sort; } } return sort; } }