本文实例为大家分享了Java实现分页功能的具体代码,供大家参考,具体内容如下
不用根据改变SQL的形式去查询;
直接查询所有的数据,根据页码自动显示数据;
分页对象
public class PageUtils implements Serializable { /** * */ private static final long serialVersionUID = -5247614532234782640L; public final static String PAGE = "page"; public final static String PAGE_NO = "pageno"; public final static String PAGE_SIZE = "pagesize"; private long pageSize=10;//每页显示记录数 private long firstResult=0;//当页第一条记录号 private long totalCount;//总记录数 private long totalPage;//总页码 private long pageNo=1;//当前页码 private List<?> sumData;//此集合可用来保存 合计数据 private List<?> data;//查询结果 public long getPageSize() { return pageSize; } public void setPageSize(long pageSize) { this.pageSize = pageSize; } public long getFirstResult() { if(pageNo>0){ firstResult=pageSize * (pageNo -1); }else{ firstResult = 0; } return firstResult; } public long getNextPageResult(){ if(pageNo>0){ return pageSize*(pageNo-1); }else{ return pageNo; } } public void setFirstResult(long firstResult) { this.firstResult = firstResult; } public long getTotalCount() { return totalCount; } public void setTotalCount(long totalCount) { this.totalCount = totalCount; totalPage = this.totalCount/pageSize; if (totalPage == 0 || totalCount % pageSize != 0) { totalPage++; } } public long getTotalPage() { return totalPage; } public void setTotalPage(long totalPage) { this.totalPage = totalPage; } public long getPageNo() { return pageNo; } public void setPageNo(long pageNo) { this.pageNo = pageNo; } public List<?> getData() { return data; } public void setData(List<?> data) { this.data = data; } /** * 是否第一页 */ public boolean isFirstPage() { return pageNo <= 1; } /** * 是否最后一页 */ public boolean isLastPage() { return pageNo >= getTotalPage(); } /** * 下一页页码 */ public long getNextPage() { if (isLastPage()) { return pageNo; } else { return pageNo + 1; } } /** * 上一页页码 */ public long getPrePage() { if (isFirstPage()) { return pageNo; } else { return pageNo - 1; } } public PageUtils(){} public PageUtils(long pageNo){ this.pageNo=pageNo; } public PageUtils(long pageNo,long pageSize){ this.pageNo=pageNo; this.pageSize = pageSize; } public List<?> getSumData() { return sumData; } public void setSumData(List<?> sumData) { this.sumData = sumData; } }
查询的数据实体
在查询的实体里添加页码和每页显示条数参数;
private int pageSize; //每页显示的条数 private int pageNo; //当前页码 public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; }
控制层Controller
@RequestMapping("/list") public String list(Model model,ChannelValueInfoView input) { // input:传入的参数为对象 PageUtils page=new PageUtils(); //如果传入的当前条数为0,则赋予值(首次查询不带参); if(input.getPageSize()==0){ //当前页码第一页 input.setPageNo(1); //每页显示条数,当前每页显示10条数据; input.setPageSize(10); } page.setPageNo(input.getPageNo()); page.setPageSize(input.getPageSize()); //核心分页代码 PageHelper p=new PageHelper(); Page<ChannelValueInfoList> l=p.startPage(input.getPageNo(),input.getPageSize()); //紧跟着的第一个select查询将会被分页 channelValueService.getChannelValueInfoViewList(input); model.addAttribute("input", input); page.setData(l); page.setTotalCount(l.getTotal()); model.addAttribute("page", page); return "index"; }
页面处理
//循环穿过来的PAGE.data数据 <tr th:each="ts : ${page.data}"> <td th:text="${ts.channelValueName}"></td> ---------- <form id="content_form" action="/channelValue/list" method="post" > <div> 总数:<span id="totalCount" th:text="${page.totalCount}">0</span> </div> <ul class="pagination"> <li class="disabled"> <a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="onFirst()">首页</a> </li> <li class="disabled"> <a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="onPre()"><</a> </li> <li class="active"> <a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" > <span id="beginRow" th:text="${page.pageNo}">0</span> </a> </li> <li class="disabled"> <a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="onNext()">></a> </li> <li class="disabled"> <a href="#" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" onclick="onLast()">尾页</a> </li> </ul> </for m> ---------- <script> function onFirst() { onList(1); } function onPre() { var beginRow = parseInt($('#beginRow').html()); if (beginRow - 1 > 0) { onList(beginRow - 1); } } function onNext() { var beginRow = parseInt($('#beginRow').html()); var totalCount = parseInt($('#totalCount').html()); var pageSize = parseInt($('#pageSize').val()); if (parseInt(totalCount / pageSize + 1) > beginRow + 1) { onList(beginRow+1); } } function onLast() { var totalCount = parseInt($('#totalCount').html()); var pageSize = parseInt($('#pageSize').val()); onList(parseInt(totalCount / pageSize + 1) - 1); } function onList(pageNo) { if (pageNo == 0) pageNo = 1; $('#pageNo').val(pageNo); $("#content_form").submit(); } </script>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持呐喊教程。
声明:本文内容来源于网络,版权归原作者所有,内容由互联网用户自发贡献自行上传,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任。如果您发现有涉嫌版权的内容,欢迎发送邮件至:notice#nhooo.com(发邮件时,请将#更换为@)进行举报,并提供相关证据,一经查实,本站将立刻删除涉嫌侵权内容。