效果
前端
使用theamleaf超链接传参给后台
<div class="pagination-wrap" style="position: relative;left: 363px;width: 259px">
<ul class="pagination">
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = ${pageNo-7})}"><</a></li>
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = 0)}">1</a></li>
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = 1)}">2</a></li>
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = 2)}">3</a></li>
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = 3)}">4</a></li>
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = 4)}">5</a></li>
<li><a th:href="@{/pages/back/goods/goodsList(pageNumber = ${pageNo+7})}">></a></li>
</ul>
</div>
后台接收并返回数据以及当前页码
/**
* 后台管理商品
* @param pageNumber 页数
* @return
*/
@RequestMapping("goodsList")
String goodsList(Model model,String pageNumber){
String spPage = pageNumber;
int pageSize = 7;//每页有多少条数据
int pageNo = 0;
if(spPage==null){
pageNo=0;
}else {
pageNo = Integer.valueOf(spPage);
if (pageNo < 0) {
pageNo = 0;
}
}
//设置最大页数
int totalCount=0;
int count=goodsService.getCount();//查询数据库中一共拥有多少条数据
if(count>0){
totalCount=count;
}
int maxPage=totalCount%pageSize==0?totalCount/pageSize:totalCount/pageSize+7;
if(pageNo>maxPage){
pageNo=maxPage;
}
Map map = new HashMap();
map.put("pageNo",pageNo);
map.put("pageSize",pageSize);
List<Map> goodsList = goodsService.selectAllForMap(map);
model.addAttribute("goodsList",goodsList);
model.addAttribute("pageNo",pageNo);
return "pages/back/index/goodsList";
}
Mapper
<select id="selectAllForMap" resultType="java.util.Map">
select * from goods LIMIT #{pageNo},#{pageSize};
</select>