今天做mybatis查询的时候 不管是用框架查询sql还是手动写sql,查询分页都不生效,很简单,你配置不对,或者缺少了配置。我下面是直接配置 不用写代码配置。框架查询sql还是手动写sql都支持
这是我查询的sql (注意!!!!PageHelper.startPage(request.initPage()); 这个要在你查询的sql上面一行才行,或者是你上面没有查询也行,因为你写这个方法后,下面的第一个查询就是启用分页。)
QueryWrapper<AttendanceConfig> queryWrapper = new QueryWrapper<>();String name = request.getName();if (StringUtils.isNoneBlank(name)) {queryWrapper.like("name", name); // 设置模糊查询条件}PageHelper.startPage(request.initPage());List<AttendanceConfig> fenceSigns = attendanceConfigPgMapper.selectList(queryWrapper);
或者这种分页方式
PageHelper.startPage(input.getPageNum(), input.getPageSize());
POM 配置
<!--mybatis-plus-->
<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.4.3.4</version>
</dependency><!--分页插件依赖 -->
<dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.1.11</version>
</dependency>
在application.yml 中配置
# pageHelper分页插件配置
#分页设置
pagehelper:helper-dialect: mysqlreasonable: truesupportMethods-arguments: truepageSizeZero: false #pageSize=0 返回所有params: count=countSql
或者在application.properties文件中配置
#pagehelper分页插件配置
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
分页类,分页的直接继承就行了
package com.mote.request;import com.mote.resp.SessionContext;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;import java.io.Serializable;/*** 分页请求的分页数据*/
@ApiModel("基本request")
@Data
public class PageRequest implements Serializable {@ApiModelProperty(value = "页码", example = "0", required = true)private Integer pageNum;@ApiModelProperty(value = "页数", example = "30", required = true)private Integer pageSize;@ApiModelProperty(value = "排序")private String sort;private SessionContext sessionContext;public PageRequest() {}public PageRequest(Integer pageNum, Integer pageSize) {this.pageNum = pageNum;this.pageSize = pageSize;}public static PageRequest of(int pageNum, Integer pageSize) {return new PageRequest(pageNum, pageSize);}public PageRequest initPage() {if (getPageNum() == null) {setPageNum(0);}if (getPageSize() == null) {setPageSize(100);}return this;}
}
配置完成 刷新下POM ,然后启动~!完美解决~~ 各位小伙伴 ,有问题请跟我说哈