1,首先需要在SqlMapconfig.xml配置文件中配置
<plugins>
<!-- com.github.pagehelper为PageHelper类所在包名 -->
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 使用下面的方式配置参数,后面会有所有的参数介绍 -->
<!-- 分页合理化参数,默认值为false。当该参数设置为 true 时,pageNum<=0 时会查询第一页,
pageNum>pages(超过总数时),会查询最后一页。默认false 时,直接根据参数进行查询 -->
<property name="reasonable" value="true"/>
</plugin>
</plugins>
需要的jar包
pagehelper-5.0.0.jar
jsqlparser-0.9.5.jar
2,后台
@RequestMapping("select.do")
public String sss(@RequestParam(value="pageno",defaultValue="1")Integer pageno,
@RequestParam(value="pagesize",defaultValue="3")Integer pagesize,Model model){
PageHelper.startPage(pageno, pagesize);
List<Address> list = userMapper.selectAddress();
System.out.println(list.size());
PageInfo<Address> pageinfo = new PageInfo<>(list);
model.addAttribute("adds", pageinfo);
return "reg";
}
前台
<div class="container">
<table class="table table-hover">
<tr>
<td>编号</td><td>地址<td>
</tr>
<c:forEach items="${adds.list }" var="a">
<tr>
<td>${a.aid }</td><td>${a.aname }<td>
</tr>
</c:forEach>
</table>
<!-- 分页条 -->
<div class="row">
<div class="col-md-6">共有${adds.total}条数据,共有${adds.pages}页</div>
<nav aria-label="Page navigation">
<ul class="pagination">
<li ng-show="adds.hasPreviousPage"><a href="select.do?pageno=1">首页</a></li>
<li>
<a ng-show="adds.hasPreviousPage" href="/select.do?pageno=${adds.pageNum-1}" aria-label="Previous">
<span aria-hidden="true">«</span>
</a>
</li>
<li>
<a ng-hide="pageInfo.hasPreviousPage" href="#" aria-label="Previous" class="disabled">
<span aria-hidden="true">«</span>
</a>
</li>
<li ng-repeat="num in adds.navigatepageNums" ng-class="num==adds.pageNum?'active':''">
<a href="#" >${adds.pageNum}</a>
</li>
<li>
<a href="select.do?pageno=${adds.pageNum+1}" aria-label="Next">
<span aria-hidden="true">»</span>
</a>
</li>
<li><a href="#" ng-click="toPage(adds.pages)">尾页</a></li>
</ul>
</nav>
</div>
</div>