首页 > 代码库 > jsp数据显示分页
jsp数据显示分页
从数据库获得数据就不写了,直接写如何进行分页,为了方便,把方法和实体类都写到一个java文件里面了
这只是一种简单的分页方法,肯能会有比较多的bug
这是java里的构造实体类和方法,
1 public class PageUtilServices { 2 3 private int pageSize;//每页显示的条数 4 private int recordCount;//总共的条数 5 private int currentPage;//当前页面 6 //构造方法 7 public PageUtilServices(int pageSize, int recordCount, int currentPage) { 8 super(); 9 this.pageSize = pageSize;10 this.recordCount = recordCount;11 this.currentPage = currentPage;12 }13 public PageUtilServices() {14 super();15 }16 17 //总页数18 public int getPageCount() {19 int size = recordCount/pageSize;//总条数/每页显示的条数=总页数20 int mod = recordCount % pageSize;//最后一页的条数21 if(mod != 0)22 size++;23 return recordCount == 0 ? 1 : size;24 }25 //当前页的起始索引为026 public int getFromIndex() {27 return (currentPage-1) * pageSize;28 }29 //当前页应展示的最后索引30 public int getToIndex() {31 return Math.min(recordCount, currentPage * pageSize);32 }33 34 public int getCurrentPage() {35 return currentPage;36 }37 public void setCurrentPage(int currentPage) {38 39 this.currentPage = currentPage;40 }41 public int getPageSize() {42 return pageSize;43 }44 public void setPageSize(int pageSize) {45 this.pageSize = pageSize;46 }47 public int getRecordCount() {48 return recordCount;49 }50 public void setRecordCount(int recordCount) {51 this.recordCount = recordCount;52 }53 }
这是jsp界面
<style type="text/css"> table{ margin: 0 auto; border-collapse:collapse; border-color: #666; } .lowstore{ color:red; } td{ text-align: center; } </style> </head> <body> <table border="1px"> <% BookInfoDao dao = new BookInfoDao(); List<Books> bookList = dao.showBooks(); String pageStr = request.getParameter("page"); int currentPage = 1; if (pageStr==null){ currentPage = 1; }else if(Integer.parseInt(pageStr)<=0){ currentPage = 1; }else if(Integer.parseInt(pageStr)>bookList.size()/3){ currentPage =bookList.size()/3+1; }else{ currentPage=Integer.parseInt(pageStr); } PageUtilServices pUtil = new PageUtilServices(3, bookList.size(), currentPage); currentPage = pUtil.getCurrentPage(); BookInfoDao bd=new BookInfoDao(); //ArrayList<Books> books=bd.showBooks(); if(bookList.isEmpty()==false){ %> <tr bgcolor="#eeeeee" colspan=13 align="center" > <td>编号</td> <td>名称</td> <td>作者</td> <td>价格</td> <td>发布日期</td> <td>库存</td> <td>操作</td> <td>修改</td> <td>入库</td> <td>出库</td> <td>评论</td> <td>查看评论</td> <td>购买图书</td> </tr> <% SimpleDateFormat sf=new SimpleDateFormat("yyyy-MM-dd"); //ArrayList<Books> bookList=bd.showBooks(); %> <a href="addbooks.jsp">添加图书</a><br/> <a href="searchbook.jsp">查找图书</a><br/> <a href="userlist.jsp?id=3">查看用户</a><br/> <a href="login.jsp">返回登录</a> <% for (int i = pUtil.getFromIndex(); i < pUtil.getToIndex(); i++) { Books book = bookList.get(i); %> <tr class=<%=bookList.get(i).getReserve()<10?"lowstore":""%>> <td><%=bookList.get(i).getBookId() %></td> <td><%=bookList.get(i).getBookName() %></td> <td><%=bookList.get(i).getAuther() %></td> <td><%=bookList.get(i).getPrice() %></td> <td><%=sf.format(bookList.get(i).getBookTime()) %></td> <td><%=bookList.get(i).getReserve() %></td> <td><a href="servlet/do_bookdelServlet?id=<%=bookList.get(i).getBookId() %>">删除</a></td> <td><a href="servlet/do_updatebookServlet?id=<%=bookList.get(i).getBookId() %>">修改</a></td> <td><a href="servlet/do_inbooksServlet?id=<%=bookList.get(i).getBookId() %>">入库</a></td> <td><a href="servlet/do_outbooksServlet?id=<%=bookList.get(i).getBookId() %>">出库</a></td> <td><a href="addcomment.jsp?id=<%=bookList.get(i).getBookId() %>">评论</a></td> <td><a href="servlet/do_showcomServlet?id=<%=bookList.get(i).getBookId() %>">查看评论</a></td> <td><a href="servlet/do_sellbookServlet?id=<%=bookList.get(i).getBookId() %>">购买</a></td> </tr> <% } }else{ %> <tr> <td>对不起,没有图书收录,请添加!</td> </tr> <a href="addbooks.jsp">添加</a><br/> <a href="login.jsp">返回登录</a> <% } %> <tr><td bgcolor="#eeeeee" colspan=13 align="center"> 记录总数<%=pUtil.getRecordCount()%>条 当前页/总页数<%=currentPage%> /<%=pUtil.getPageCount()%> 每页显示<%=pUtil.getPageSize()%>条 <a href="booklist.jsp?page=1">首页</a> <a href="booklist.jsp?page=<%=(currentPage - 1)%>">上页</a> <a href="booklist.jsp?page=<%=(currentPage + 1)%>">下页</a> <a href="booklist.jsp?page=<%=pUtil.getPageCount()%>">末页</a> </td></tr> </table> </body>
jsp数据显示分页
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。