Spring Boot 配置PageHelper（Mybatis分页插件）

骑猪看日落 2023-01-13 10:52 156阅读 0赞

### 1 PageHelper ###

PageHelper是Github上开源的MyBatis分页插件，使用起来非常的简单，方便，并且支持任何复杂的单表、多表分页。

### 2 pom.xml（Maven依赖文件） ###

<dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.4</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.3.0</version>
            </dependency>

### 3 application.properties（配置文件） ###

#数据库连接池设置
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
    spring.datasource.username=root
    spring.datasource.password=root
    
    #mybatis的相关配置
    mybatis.mapper-locations=classpath:mapper/*.xml
    #pagehelper分页插件的数据库类型配置
    pagehelper.helper-dialect=mysql

### 4 UserController ###

package com.controller;
    
    import com.entity.User;
    import com.github.pagehelper.PageHelper;
    import com.github.pagehelper.PageInfo;
    import com.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    
    import java.util.List;
    
    @RestController
    @RequestMapping("/user")
    public class UserController {
        @Autowired
        private UserService userService;
    
        /**
         * 显示用户信息（分页）
         *
         * @param pageNum  页号
         * @param pageSize 每页显示记录数
         * @return
         */
        @GetMapping("/getUserList")
        public PageInfo<User> getUserList(@RequestParam int pageNum, @RequestParam int pageSize) {
            PageHelper.startPage(pageNum, pageSize);
            List<User> userList = userService.getUserList();
            PageInfo<User> pageInfo = new PageInfo<>(userList);
            return pageInfo;
        }
    }

###  5 调试结果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: /images/20221022/85ec5111575e478094da359b8bbcb866.png