springboot2.0系列五（Mybatis整合分页插件）

Mybatis整合分页插件

pageHelper

PageHelper 是一款好用的开源免费的 Mybatis 第三方物理分页插件

物理分页

支持常见的 12 种数据库。Oracle,MySql,MariaDB,SQLite,DB2,PostgreSQL,SqlServer 等

支持多种分页方式

支持常见的 RowBounds(PageRowBounds)，PageHelper.startPage 方法调用，Mapper 接口参数调用

Maven依赖

<parent>             <groupId>org.springframework.boot</groupId>             <artifactId>spring-boot-starter-parent</artifactId>             <version>2.0.0.RELEASE</version>       </parent>       <dependencies>             <dependency>                   <groupId>org.projectlombok</groupId>                   <artifactId>lombok</artifactId>             </dependency>               <dependency>                   <groupId>org.springframework.boot</groupId>                   <artifactId>spring-boot-starter</artifactId>             </dependency>             <!-- 测试 -->             <dependency>                   <groupId>org.springframework.boot</groupId>                   <artifactId>spring-boot-starter-test</artifactId>                   <scope>test</scope>             </dependency>             <dependency>                   <groupId>org.mybatis.spring.boot</groupId>                   <artifactId>mybatis-spring-boot-starter</artifactId>                   <version>1.1.1</version>             </dependency>             <!-- mysql 依赖 -->             <dependency>                   <groupId>mysql</groupId>                   <artifactId>mysql-connector-java</artifactId>             </dependency>             <!-- springboot-web组件 -->             <dependency>                   <groupId>org.springframework.boot</groupId>                   <artifactId>spring-boot-starter-web</artifactId>             </dependency>             <!-- springboot 整合 pagehelper -->             <dependency>                   <groupId>com.github.pagehelper</groupId>                   <artifactId>pagehelper-spring-boot-starter</artifactId>                   <version>1.2.5</version>             </dependency>             <dependency>                   <groupId>org.apache.commons</groupId>                   <artifactId>commons-lang3</artifactId>                   <version>3.7</version>             </dependency>       </dependencies>

 

配置文件

spring.datasource.url=jdbc:mysql://localhost:3306/test spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.jdbc.Driver     logging.level.com.example.demo.dao=DEBUG pagehelper.helperDialect=mysql pagehelper.reasonable=true pagehelper.supportMethodsArguments=true pagehelper.params=count=countSql pagehelper.page-size-zero=true

 

 

 

Entity层

@Data public class User {         private Integer id;       private String name;       private Integer age; }

 

Mapper层

 

@Mapper public interface UserMapper {       @Select("SELECT * FROM USERS ")       List<User> findUserList(); }

 

Service层

@Service public class UserService {       @Autowired       private UserMapper userMapper;         /**        * page 当前页数<br>        * size 当前展示的数据        *        * @param page        * @param size        * @return        */       public PageInfo<User> findUserList(int page, int size) {             // 开启分页插件,放在查询语句上面             PageHelper.startPage(page, size);             List<User> listUser = userMapper.findUserList();             // 封装分页之后的数据             PageInfo<User> pageInfoUser = new PageInfo<User>(listUser);             return pageInfoUser;       }   }

 

Controller层

 

@RestController public class IndexController {       @Autowired       private UserService userService;         @RequestMapping("/findUserList")       public PageInfo<User> findUserList(int page, int size) {             return userService.findUserList(page, size);       }   }

 

启动项目

//@MapperScan("com.example.demo.mapper") @SpringBootApplication public class PageHelper {         public static void main(String[] args) {             SpringApplication.run(PageHelper.class, args);       }   }

效果