- Spring集成 PageHelper插件:
在pom.xml中引入插件jar包
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.0.1</version>
</dependency>
在引入Mybatis的配置文件中,配置pagehelper信息
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageHelper">
<!-- 配置数据库类型 -->
<property name="properties">
<value>
dialect=${connect.db}
offsetAsPageNum=true
rowBoundsWithCount=true
</value>
</property>
</bean>
</array>
</property>
其中 ${connect.db} 是变量 可以直接写成 ORACLE/MYSQL等主流数据库,pagehelper默认支持
Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL 数据库
完成上述配置后,核心代码如下:
public @ResponseBody JSONResponse dictList(@RequestParam(value="codeGroupId", required=false) String codeGroupId,
@RequestParam(value="codeGroupName", required=false) String codeGroupName,
@RequestParam(value="codeId", required=false) String codeId,
@RequestParam(value="codeName", required=false) String codeName,
@RequestParam(value="codeStatusId", required=false) String codeStatusId,
@RequestParam(value="pageNo", required=false) int pageNo,
@RequestParam(value="pageSize", required=false) int pageSize,
HttpServletRequest request, HttpServletResponse response) throws Exception{
logger.info("RequestMapping : "+REQUEST_URL+" -> GET");
Map<String, Object> params = Maps.newHashMap();
params.put("codeGroupId", codeGroupId);
params.put("codeGroupName", codeGroupName);
params.put("codeId", codeId);
params.put("codeName", codeName);
params.put("codeStatusId", CommenUtils.splitToList(CommenUtils.trim(codeStatusId)));
logger.info("参数:" + params);
startPage(pageNo, pageSize);
List<Dictionary> list = dictionaryService.getDictionary(params);
System.out.println(list.size());
PageInfo<Dictionary> pageInfo = new PageInfo<Dictionary>(list);
logger.info("pageInfo " + pageInfo.toString());
Page page = PageUtils.getPage(pageInfo);
logger.info("page " + page);
if(CommenUtils.isNotEmpty(list)){
return successed(list, page);
}
return null;
}
其中 successed 是自己封装的方法,可以自己来写;
- SpringBoot集成 PageHelper插件:
如果 不使用配置文件来配置Mybatis信息,则在主启动类Application.java中添加如下代码:
@Bean
public PageHelper pageHelper(){
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("offsetAsPageNum","true");
properties.setProperty("rowBoundsWithCount","true");
properties.setProperty("reasonable","true");
properties.setProperty("dialect","oracle"); //配置mysql数据库的方言
pageHelper.setProperties(properties);
return pageHelper;
}
其它相同;
至此结束,谢谢 ... ...