spring boot集成pagehelper(两种方式)

参看了pagehelper-spring-boot，使用起来非常放方便，关于更多PageHelper可以点击https://github.com/pagehelper/Mybatis-PageHelper。

当spring boot集成好mybatis时候需要进行分页，我们首先添加maven支持

									<dependency>

									 <groupId>com.github.pagehelper</groupId>

									 <artifactId>pagehelper</artifactId>

									 <version>5.1.2</version>

									</dependency>

									<dependency>

									 <groupId>com.github.pagehelper</groupId>

									 <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>

									 <version>1.2.3</version>

									</dependency>

									<dependency>

									 <groupId>com.github.pagehelper</groupId>

									 <artifactId>pagehelper-spring-boot-starter</artifactId>

									 <version>1.2.3</version>

									</dependency>

方式一：我们在application.yml(spring 需要读取的yml)中加入

									pagehelper:

									 helperDialect: mysql

									 reasonable: true

									 supportMethodsArguments: true

									 params: count=countSql

然后重启即可。

配置文件最终会被java所读取，最终注入到spring bean中，所以我们方法二是配置其bean类，热加载方便修改当然方式一更简单，

方式二：在注解涵盖package下面新建PageHeleperConfig

									import com.github.pagehelper.PageHelper;

									import java.util.Properties;

									import org.springframework.context.annotation.Bean;

									import org.springframework.context.annotation.Configuration;

									/**

									 * @author zhuxiaomeng

									 * @date 2018/1/2.

									 * @email 154040976@qq.com

									 */

									@Configuration

									public class PageHelperConfig {

									 @Bean

									 public PageHelper getPageHelper(){

									 PageHelper pageHelper=new PageHelper();

									 Properties properties=new Properties();

									 properties.setProperty("helperDialect","mysql");

									 properties.setProperty("reasonable","true");

									 properties.setProperty("supportMethodsArguments","true");

									 properties.setProperty("params","count=countSql");

									 pageHelper.setProperties(properties);

									 return pageHelper;

									 }

									}