mybatis分页

最新推荐文章于 2024-06-05 11:30:00 发布

计算机界的小学生

最新推荐文章于 2024-06-05 11:30:00 发布

阅读量113

点赞数

本文链接：https://blog.csdn.net/weixin_52188717/article/details/120011665

版权

mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

一.依赖

<!-- pagehelper -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.5</version>
</dependency>

二。application.yml添加相关配置

# pagehelper   
pagehelper:
    helperDialect: mysql
    reasonable: true
    supportMethodsArguments: true
    params: count=countSql

三。代码
1.dao层

List<SysUser> selectPage();

<select id="selectPage"  resultMap="BaseResultMap">
  select 
  <include refid="Base_Column_List" />
  from sys_user
</select>

2.service层

接口

 PageResult findPage(PageRequest pageRequest);

实现类：

 @Override
    public PageResult findPage(PageRequest pageRequest) {
        return PageUtils.getPageResult(pageRequest, getPageInfo(pageRequest));
    }
    
    /**
     * 调用分页插件完成分页
     * @param pageQuery
     * @return
     */
    private PageInfo<SysUser> getPageInfo(PageRequest pageRequest) {
        int pageNum = pageRequest.getPageNum();
        int pageSize = pageRequest.getPageSize();
        PageHelper.startPage(pageNum, pageSize);
        List<SysUser> sysMenus = sysUserMapper.selectPage();
        return new PageInfo<SysUser>(sysMenus);
    }

3.controller层

 @GetMapping("list")
    public ResultMap findAllRoom(PageRequest pageQuery) {
        PageResult result= roomService.pageSelectRoom(pageQuery);
        if(StringUtils.isEmpty(result)){
            return ResultMap.empty();
        }
        return ResultMap.success(result);
    }