MybatisPlus 分页查询

一、数据库

二、POM.XML

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.5</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.paging</groupId>
    <artifactId>fenye</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>fenye</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

三、application.properties配置

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/jiangfujiajiu?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver


#对调试错误有帮助（发布就可以把这个干掉）
logging.level.com.paging.fenye.mapper=debug
#扫描mapper路径
#mybatis.type-aliases-package=com.paging.fenye.mapper
#扫描映射xml路径
#mybatis.mapper-locations=classpath:/mapper/*.xml

四、pojo类

package com.paging.fenye.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author LunarYouI
 * @create 2021-05-17 9:27
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
//指定数据库中的哪一张表
@TableName("user")
public class TabOne {
    //id 自增
    @TableId(value = "id",type = IdType.AUTO)
    private Integer id;
    private String username;
    private String password;
}

五、mapper接口

package com.paging.fenye.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.paging.fenye.pojo.TabOne;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Component;

/**
 * @author LunarYouI
 * @create 2021-05-17 9:32
 */
@Mapper
@Component
public interface ItMapper extends BaseMapper<TabOne> {

}

六、config类

package com.paging.fenye.config;

import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @author LunarYouI
 * @create 2021-05-17 10:04
 */
@Configuration
public class MyBatisPlusConfig {
	
	/**
     * 分页插件  新版
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
        return interceptor;
    }

    //注入拦截器  （旧版不推荐使用了）
    //@Bean
    //public PaginationInterceptor paginationInterceptor(){
      //  return new PaginationInterceptor();
    //}
}

七、controller类

package com.paging.fenye.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.paging.fenye.mapper.ItMapper;
import com.paging.fenye.pojo.TabOne;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

/**
 * @author LunarYouI
 * @create 2021-05-17 9:32
 */
@Controller
public class TestController {
    //如果下面的itMapper出现红色波浪线，那么可以在mapper里面加上@Component
    @Autowired
    ItMapper itMapper;

    @ResponseBody
    @RequestMapping(value = "/")
    public Object index(){
        TabOne tabOne = itMapper.selectById(1);
        return tabOne;
    }

    @ResponseBody
    @RequestMapping(value = "/testPage/{pageNo}")
    public Object testPage(@PathVariable("pageNo") Integer pageNo,@PathVariable("size") Integer size){
        //pageNo：当前页   size：每页显示N条记录数
        Page<TabOne> page = new Page<>(pageNo,size);
        //调用mp分页查询的方法,查询条件为空
        Page<TabOne> tabOnePage = itMapper.selectPage(page, null);

        //通过tabOnePage对象获取分页数据
        System.out.println("当前页码：" + page.getCurrent());//获取当前页
        System.out.println("数据的list集合：" + page.getRecords());//每页数据的list集合
        System.out.println("每页显示的记录数：" + page.getSize());//每页显示的记录数
        System.out.println("总记录数：" + page.getTotal());//总记录数
        System.out.println("总页数：" + page.getPages());//总页数
        System.out.println("是否有下一页：" + page.hasNext());//是否有下一页
        System.out.println("是否有上一页：" + page.hasPrevious());//是否有上一页

        return tabOnePage;
    }
}

如果有兴趣可以看看以前我手写的分页效果——>分页效果