springboot、mybatis集成pagehelper

添加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>

添加项目配置集成

1. 方式一

在配置文件中添加

pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

2.方式二

通过configuration配置

 
@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;
 }
 
}

使用方法

public Map<String, Object> queryPagingList(TSysRole bean) {
		Map<String, Object> result= new  HashMap<String, Object>();
		TSysRoleExample example = new TSysRoleExample();
		Criteria c = example.createCriteria();
		//省略条件
		....
		Map<String,Object> params = CommonUtils.json2Map(CommonUtils.bean2Json(bean));
		//page、rows为前台传过来的值
		PageHelper.startPage(bean.getPage(), bean.getRows());
		List<Map<String,Object>> listmaps = mapper.queryPagingList(params);
		PageInfo<Map<String,Object>> pageinfo = new PageInfo<>(listmaps);
		result.put("rows",listmaps);
		result.put("total",pageinfo.getTotal());
		return result;
	}