springboot添加PageHelper分页查询插件

[b][size=x-large]springboot添加PageHelper分页查询插件[/size][/b]

[b][size=medium]1、POM文件中引入PageHelper包[/size][/b]
[size=medium]<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.4</version>
</dependency>[/size]

[b][size=medium]2、在resources目录下创建mybatis-config.xml文件配置PageHelper分页查询插件[/size][/b]
[size=medium]<?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>
<!-- 配置pageHelper分页查询插件 -->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<property name="helperDialect" value="mysql"/>
</plugin>
</plugins>
</configuration>[/size]

[b][size=medium]3、在application.properties中添加PageHelper插件[/size][/b]
[size=medium]mybatis.configLocation=classpath:mybatis-config.xml[/size]


[b][size=medium]4、在controller层的方法中调用PageHelper分页查询[/size][/b]
[size=medium]@RequestMapping(value="/pushList",method={RequestMethod.POST,RequestMethod.GET})
public ModelAndView pushManageList(@RequestParam(defaultValue="1",required=true)Integer page)
{
//利用PageHelper进行分页查询
//pageNum为当前页码;pageSize每页显示记录数;count=true则进行count查询总记录数
PageHelper.startPage(page, 2,true);

List<PushManageTaskInfo> pushList = pushManageTaskService.queryPushManageInfoList();

PageInfo<PushManageTaskInfo> pageQuery=new PageInfo<PushManageTaskInfo>(pushList);

ModelAndView mview=new ModelAndView("pushList");
mview.addObject("pushList", pushList);
mview.addObject("page",pageQuery);
return mview;
}[/size]


[b][size=medium]5、前端页面分页查询[/size][/b]
[size=medium]<a href="pushList?page=${page.firstPage}">第一页</a>
<a href="pushList?page=${page.prePage}">上一页</a>
<a href="pushList?page=${page.nextPage}">下一页</a>
<a href="pushList?page=${page.lastPage}">尾页</a>
当前第${page.pageNum}页    一共${page.pages}页[/size]

最后用浏览器访问页面效果

[img]http://dl2.iteye.com/upload/attachment/0130/3516/379731a9-caa3-3409-afea-2156c2ec82d8.png[/img]