MyBatis实现分页的三种方式
- 利用原生的sql关键字limit来实现
- 利用interceptor来拼接sql,实现和limit一样的功能
- 利用PageHelper来实现
第一步:搭建开发环境
- 创建spring项目
![在这里插入图片描述](https://img-blog.csdnimg.cn/20201223181621263.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQ2MDE3MQ==,size_16,color_FFFFFF,t_70)
- pom.xml需要引入的依赖如下
<dependencies>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>RELEASE</version>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>RELEASE</version>
<scope>compile</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
<version>5.1.45</version>
</dependency>
</dependencies>
- 创建项目结构
![在这里插入图片描述](https://img-blog.csdnimg.cn/20201223182016605.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDQ2MDE3MQ==,size_16,color_FFFFFF,t_70)
import lombok.Data;
import java.util.List;
@Data
public class Pager<T> {
private int page;
private int size;