本文主要介绍在SSM框架下使用pagehelper插件来实现分页。主要实现步骤如下:
1.导jar包
在pom.xml文件添加jar包如下:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
2.告诉mybatis要用pagehelper 添加到sqlsessionfactroy
在applicationContext.xml添加语句如下:
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<props>
<prop key="helperDialect">mysql</prop>
<prop key="reasonable">true</prop>
</props>
</property>
</bean>
</array>
</property>
3.在service层,在执行具体sql之前 PageHelper.startPage(page,size);
public List<UserInfo> findAll(int page, int size) {
PageHelper.startPage(page, size);
return this.userDao.findAll(page, size);
}
4.controler 把得到的list装到pageinfo里面
修改控制层查找用户的函数
@RequestMapping("findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue = "1") int page, @RequestParam(defaultValue = "4") int size){
List<UserInfo> infos = userService.findAll(page,size);
PageInfo pageinfo = new PageInfo(infos);
ModelAndView mv=new ModelAndView();
mv.addObject("pageInfos",pageinfo);
mv.setViewName("user-list");
return mv;
}
5,在页面展示
修改前端的代码让用户列表分列显示
<div class="box-tools pull-right">
<ul class="pagination">
<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=1&size=4" aria-label="Previous">首页</a></li>
<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfos.pageNum-1}&size=4">上一页</a></li>
<c:forEach begin="1" end="${pageInfos.pages}" var="pageNum">
<li>
<a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageNum}&size=4">${pageNum}</a></li>
</li>
</c:forEach>
<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfos.pageNum+1}&size=4">下一页</a></li>
<li><a href="${pageContext.request.contextPath}/user/findAll.do?page=${pageInfos.pages}&size=4" aria-label="Next">尾页</a></li>
</ul>
</div>
查询结果如下: