分页插件的使用

以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