Spring和SpringBoot集成PageHelper

一、Spring集成PageHelper

1.添加maven依赖

注意：版本号需要对应，不然到处是坑！

<!-- mybatis核心包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.2.4</version>
		</dependency>
		<!-- mybatis/spring包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
		
<!-- pagehelper分页插件-->
       <dependency>
		   <groupId>com.github.pagehelper</groupId>
		   <artifactId>pagehelper</artifactId>
		   <version>5.0.2</version>
	   </dependency>
	   <dependency>
		   <groupId>com.github.jsqlparser</groupId>
		   <artifactId>jsqlparser</artifactId>
		   <version>0.9.5</version>
	   </dependency>

2.配置mybatis-config.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<settings>
		<setting name="lazyLoadingEnabled" value="false" />
	</settings>
	<!-- pagehelper分页插件-->
	<plugins>
		<plugin interceptor="com.github.pagehelper.PageInterceptor">
		</plugin>
	</plugins>
</configuration>

3.在service中使用pagehelper

PageInfo<UserEntity> page = PageHelper.startPage(1, 2).doSelectPageInfo(() -> userMapper.selectByIds());

二、SpringBoot集成PageHelper

1.添加maven依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <dependency>
			<groupId>com.github.pagehelper</groupId>
			<artifactId>pagehelper-spring-boot-starter</artifactId>
			<version>1.2.10</version>
		</dependency>
	

2.在service中使用pagehelper

PageInfo<UserEntity> page = PageHelper.startPage(1, 2).doSelectPageInfo(() -> userMapper.selectByIds());