SpringBoot Mybatis 分页插件PageHelper

最新推荐文章于 2024-08-30 19:07:59 发布

转载最新推荐文章于 2024-08-30 19:07:59 发布 · 119 阅读

文章标签：

#java #数据库

本文介绍如何在MyBatis中配置PageHelper插件实现分页功能，包括Maven依赖添加、Spring配置Bean、SqlSessionFactory配置及PageInfo封装返回等步骤。

添加maven配置：

    <!-- 分布插件 -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>4.1.6</version>
        </dependency>

添加Bean:

//配置mybatis的分页插件pageHelper
    @Bean
    public PageHelper pageHelper(){
        PageHelper pageHelper = new PageHelper();
        Properties properties = new Properties();
        //设置为true时，会将RowBounds第一个参数offset当成pageNum页码使用
        properties.setProperty("offsetAsPageNum","true");
        //设置为true时，使用RowBounds分页会进行count查询
        properties.setProperty("rowBoundsWithCount","true");
        //设置为true时，如果pageSize=0或者RowBounds.limit = 0就会查询出全部的结果
        //properties.setProperty("pageSizeZero","true");
        //禁用合理化，启用合理化时，如果pageNum<1会查询第一页，如果pageNum>pages会查询最后一页
        properties.setProperty("reasonable","false");
        //配置mysql数据库的方言
        properties.setProperty("dialect","mysql");    //配置mysql数据库的方言
        pageHelper.setProperties(properties);
        return pageHelper;
    }

SqlSessionFactory:

    @Bean
    public SqlSessionFactory sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource,PageHelper pageHelper) throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        Resource[] mappers = (new PathMatchingResourcePatternResolver())
                .getResources("classpath*:mybatis_mapper/*Mapper.xml");
        sessionFactory.setMapperLocations(mappers);
        sessionFactory.setPlugins(new Interceptor[]{pageHelper});
        return sessionFactory.getObject();
    }

应用：

    public PageInfo<DataDict> selectListByParentKey(String parentKey){
        PageHelper.startPage(2,3);
        List<DataDict> list=mapper.selectListByParentKey(parentKey);
        PageInfo<DataDict> pageInfo = new PageInfo<>(list);
        return pageInfo;
    }

封装返回的PageInfo

public class PageResult {

    private ModelMapper modelMapper=SpringUtils.getBean(ModelMapper.class);

    private PageInfo pageInfo;

    private Class aClass;

    public PageResult(PageInfo _pageInfo ){
        this.pageInfo=_pageInfo;
    }

    /**
     *
     * @param _pageInfo  pageHelper的实例
     * @param _aClass list输出类型，如果aClass不为空，就将list转换为aClass类型，反之则不进行转换
     */
    public PageResult(PageInfo _pageInfo,Class _aClass){
      this.pageInfo=_pageInfo;
      this.aClass=_aClass;
    }

    private Integer pageIndex;

    private Integer pageSize;

    private Long totalCount;

    private Integer totalPages;

    private List list;

    public Integer getPageIndex() {
        return pageInfo.getPageNum();
    }

    public Integer getPageSize() {
        return pageInfo.getPageSize();
    }

    public Long getTotalCount() {
        return pageInfo.getTotal();
    }

    public Integer getTotalPages(){
        return pageInfo.getPages();
    }

    public List getList() {
        List list= pageInfo.getList();
        if(null!=aClass) {
            List list2 = new ArrayList();
            list.forEach(x -> {
                list2.add(modelMapper.map(x, aClass));
            });
            return list2;
        }else{
            return list;
        }
    }
}

调用：

        PageHelper.startPage(request.getPageIndex(),request.getPageSize());
        List<DataDict> list=dataDictBizFacade.selectListByCondition(request.getDictKey(),request.getDictDesc(),request.getParentKey());
        PageResult result=new PageResult(new PageInfo<>(list),DataDictResponse.class);
        response.setData(result);

https://www.ciphermagic.cn/mybatis-page-2.html#Spring%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6

https://www.cnblogs.com/1315925303zxz/p/7364552.html

http://www.imooc.com/article/15451

https://blog.youkuaiyun.com/liangwenmail/article/details/77864267

https://github.com/pagehelper/Mybatis-PageHelper/issues/166