sb整合pagehelper

最近用上了SB+MP,开发挺快的,关于分页还是喜欢用pagehelper
下面记录一下如何整合进SB项目

pom依赖

	<dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>4.1.6</version>
 	</dependency>

启动类添加

	//配置mybatis的分页插件pageHelper
    @Bean
    public PageHelper pageHelper(){
        PageHelper pageHelper = new PageHelper();
        Properties properties = new Properties();
        properties.setProperty("offsetAsPageNum","true");
        properties.setProperty("rowBoundsWithCount","true");
        properties.setProperty("reasonable","true");
        properties.setProperty("dialect","mysql");    //配置mysql数据库的方言
        pageHelper.setProperties(properties);
        return pageHelper;
    }
    

使用

PageHelper.startPage(page, limit);
 List<Video> selectByExample = videoMapper.selectByExample(videoExample);
  PageInfo<Video> pageInfo = new PageInfo<>(selectByExample);