1.在pom.xml中导入maven依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.8</version>
</dependency>
2.mybatis配置文件中添加插件(配置到sql)
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<!--使用下面的方式配置参数,一行配置一个 -->
<value>
pagehelper.helper-dialect=mysql
pagehelper.params=count=countSql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
</value>
</property>
</bean>
</array>
</property>
3.前端代码
<span id=pagelink>
<div style="LINE-HEIGHT: 20px; HEIGHT: 20px; TEXT-ALIGN: right; margin-top:10px">
共[<B>${p.total}</B>]条记录,共[<B>${p.pages}</B>]页
,
<c:if test="${ p.pageNum > 1 }">
[<A href="javascript:to_page(${p.prePage})">前一页</A>]
</c:if>
<form name="blogForm" id="blogForm"
action="/findByUId"
method=post >
<input type="hidden" name="pageNum" id="page" value=""/>
<input type="hidden" name="uid" value="${user.id}"/>
</form>
第<B>${p.pageNum}</B>页
<c:if test="${ p.pageNum < p.pages }">
[<A href="javascript:to_page(${p.nextPage})">后一页</A>]
</c:if>
</div>
</span>
4.将表单中的uid,pageNum传给后端
controller-----控制器
@RequestMapping("/findByUId")
public String findByUId(@RequestParam("uid") String uid,Model model,
@RequestParam(required=false,defaultValue="1")
Integer pageNum, @RequestParam(required=false,defaultValue="8")
Integer pageSize){
List<Blog> list= blogService.findByUId(uid,pageNum,pageSize);
PageInfo<Blog> p=new PageInfo<Blog>(list);
model.addAttribute("p",p);
model.addAttribute("blog",list);
return "MyBlog.jsp";
}
serviceImpl -----业务层
PageHelper.startPage(pageNum,pageSize);
return blogMapper.findByUId(uid,pageNum,pageSize);
dao层
List<Blog> findByUId(@Param("uid") String uid, Integer pageNum, Integer pageSize);