分页插件的使用

以Meavn项目为例

1.通用mapper

<!-- 通用Mapper -->
<dependency>
   <groupId>com.github.abel533</groupId>
   <artifactId>mapper</artifactId>
   <version>2.3.4</version>
</dependency>

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

2.mybtis-config.xml中

<!-- 分页查询和通用mapper -->
<plugins>
   <!-- 分页插件 -->
   <!-- com.github.pagehelper为PageHelper类所在包名 -->
   <plugin interceptor="com.github.pagehelper.PageHelper">
      <!-- 设置方言 -->
      <property name="dialect" value="mysql" />
      <!-- 该参数默认为false -->
      <!-- 设置为true时，使用RowBounds分页会进行count查询 （会自动查询总数） -->
      <property name="rowBoundsWithCount" value="true" />
   </plugin>


   <!-- 通用Mapper -->
   <plugin interceptor="com.github.abel533.mapperhelper.MapperInterceptor">
      <!--主键自增回写方法,默认值MYSQL,详细说明请看文档 -->
      <property name="IDENTITY" value="HSQLDB" />

      <!--通用Mapper接口，多个通用接口用逗号隔开 -->
      <property name="mappers" value="com.github.abel533.mapper.Mapper" />
   </plugin>
   
</plugins>

3.使用

public PageInfo<Product> findAllProductSold(int pageNum, Integer pageSize, String sold) {
    Subject subject = SecurityUtils.getSubject();
    User user= (User)subject.getPrincipal();
    String bankCode= userDao.getBankCode(user.getLoginName());
    PageHelper.startPage(pageNum, pageSize);
    Example example = new Example(Product.class);
    // 排序
    example.setOrderByClause("lastUpdateDate desc");
    Example.Criteria criteria = example.createCriteria();
    //添加银行code
  if(bankCode!=null && bankCode!=""){
        criteria.andEqualTo("bankCode",bankCode);
    }
    //end
    criteria.andEqualTo("sold",sold);
    criteria.andEqualTo("deleted","F");
    List<Product> products = productDao.selectByExample(example);
    PageInfo<Product> pageInfo = new PageInfo<Product>(products);
  /*  Subject subject = SecurityUtils.getSubject();
    User user= (User)subject.getPrincipal();
    String bankCode= userDao.getBankCode(user.getLoginName());
    Page<Product> products = productDao.queryApproveSoldProduct(sold,bankCode);
    PageInfo<Product> pageInfo = new PageInfo<Product>(products);*/
    return pageInfo;
}

4.通过pageInfo给到pagelist