Mybatis的5种分页方式

喜欢ヅ旅行 2023-09-24 19:54 21阅读 0赞

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.mapper.UserMapper">
        
    
        
        <select id="selectAllUserByLimitPage" resultType="User">
            select * from user limit #{startIndex},#{pageSize}
        </select>
    
        
        
        <select id="selectAllUserByInterceptorByPage" parameterType="map" resultType="User">
            select * from user
        </select>
    
        
        <select id="selectAllUserByPageHelperPage" resultType="User">
            select * from user
        </select>
    
        
        <select id="selectAllUserByRowBounds" resultType="User">
            select * from user
        </select>
    </mapper>

**附：项目的目标结构和关键代码**

![e1ba1536e0894bf18d82595682473b96.png][]

application.yml文件：

spring:
      datasource:
        type: com.zaxxer.hikari.HikariDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://10.203.5.185:3306/fLearn?serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false
        username: root
        password: MySQL#567890
    mybatis-plus:
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
      type-aliases-package: com.pojo
      mapper-locations: classpath:mapper/*.xml
    # PageHelper分页插件
    pagehelper:
      helperDialect: mysql
      reasonable: false
      supportMethodsArguments: true
      params: count=countSql

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.5.6</version>
            <relativePath/> 
        </parent>
        <groupId>com.example</groupId>
        <artifactId>boot_recieve_data</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>boot_recieve_data</name>
        <description>Demo project for Spring Boot</description>
        <properties>
            <java.version>8</java.version>
            <mybatis-plus-boot-starter.version>3.3.2</mybatis-plus-boot-starter.version>
            <druid.version>1.2.8</druid.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus-boot-starter.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.46</version>
            </dependency>
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.4.0</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering> false </filtering>
                </resource>
            </resources>
        </build>
    
    </project>

[e1ba1536e0894bf18d82595682473b96.png]: https://img-blog.csdnimg.cn/e1ba1536e0894bf18d82595682473b96.png