分页插件源自: https://github.com/rosegun/mybatis-generator-pagination

使用方法

1. 加入maven依赖

  1. ...
  2.         <dependency>
  3.             <groupId>com.rosegun</groupId>
  4.             <artifactId>mybatis-generator-pagination</artifactId>
  5.             <version>1.0.1</version>
  6.         </dependency>
  8. ...
  10. <!-- 插件依赖 -->
  11.             <plugin>
  12.                 <groupId>org.mybatis.generator</groupId>
  13.                 <artifactId>mybatis-generator-maven-plugin</artifactId>
  14.                 <version>1.3.6</version>
  15.                 <configuration>
  16.                     <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
  17.                     <overwrite>true</overwrite>
  18.                     <verbose>true</verbose>
  19.                 </configuration>
  20.                 <dependencies>
  21.                     <dependency>
  22.                         <groupId>mysql</groupId>
  23.                         <artifactId>mysql-connector-java</artifactId>
  24.                         <version>5.1.47</version>
  25.                     </dependency>
  26.                     <dependency>
  27.                         <groupId>org.mybatis.generator</groupId>
  28.                         <artifactId>mybatis-generator-core</artifactId>
  29.                         <version>1.3.6</version>
  30.                     </dependency>
  31.                     <dependency>
  32.                         <groupId>com.rosegun</groupId>
  33.                         <artifactId>mybatis-generator-pagination</artifactId>
  34.                         <version>1.0.1</version>
  35.                     </dependency>
  36.                 </dependencies>
  37.             </plugin>

2. generatorConfig.xml

  1. <plugin type="com.rosegun.plugin.MysqlLimitPlugin"/>

同时开启 selectByExample

3. java(Repository)

  1.     public List<Contract> pageQueryContracts(int pageNum, int pageSize) {
  2.         // 构建分页请求
  3.         ContractDOExample example = new ContractDOExample();
  4.         example.setPage(new Page(pageNum * pageSize, pageSize));
  6.         List<ContractDO> contractDOS = contractDOMapper.selectByExample(example);
  7.         if (CollectionUtils.isEmpty(contractDOS)) {
  8.             logger.error("分页查询合约DO结果为空");
  9.             return new ArrayList<>();
  10.         }
  11.         logger.debug("分页查询模板, contractDOS={}", contractDOS);
  12.         return ModelListConverter.convertList(contractDOS, ContractConverter::convertDO2Model);
  13.     }