javabean+jsp+DAO实现分页

最新推荐文章于 2020-12-23 14:28:29 发布

zhangshaonian

最新推荐文章于 2020-12-23 14:28:29 发布

阅读量117

点赞数

分类专栏： JAVA 文章标签： JSP DAO CSS Servlet 工作

JAVA 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

PageBean.java

package com.servlet;
import java.util.*;
public class PageBean {
private List arrayList;//存放总数据
// 分页信息定义
private int totalRows = 0; // 总数据数
private int pageRecorders = 20;// 每页显示记录数
private int totalPages = 0; // 总页数
private int pageStartRow = 0;// 每页的起始数
private int pageEndRow = 0; // 每页显示数据的终止数
private int currentPage = 1;// 当前页
private boolean hasNextPage = false; // 是否有下一页
private boolean hasPreviousPage = false; // 是否有前一页
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(int currentPage) {
this.currentPage = currentPage;
}
public boolean isHasNextPage() {
return hasNextPage;
}
public void setHasNextPage(boolean hasNextPage) {
this.hasNextPage = hasNextPage;
}
public boolean isHasPreviousPage() {
return hasPreviousPage;
}
public void setHasPreviousPage(boolean hasPreviousPage) {
this.hasPreviousPage = hasPreviousPage;
}
public int getPageEndRow() {
return pageEndRow;
}
public void setPageEndRow(int pageEndRow) {
this.pageEndRow = pageEndRow;
}
public int getPageRecorders() {
return pageRecorders;
}
public void setPageRecorders(int pageRecorders) {
this.pageRecorders = pageRecorders;
}
public int getPageStartRow() {
return pageStartRow;
}
public void setPageStartRow(int pageStartRow) {
this.pageStartRow = pageStartRow;
}
public int getTotalPages() {
return totalPages;
}
public void setTotalPages(int totalPages) {
this.totalPages = totalPages;
}
public int getTotalRows() {
return totalRows;
}
public void setTotalRows(int totalRows) {
this.totalRows = totalRows;
}

public PageBean(List arrayList, int pageRecorders) {
this.arrayList = arrayList;
this.pageRecorders = pageRecorders;
totalRows = arrayList.size();// 获得总数据数
// 获得总页数
if ((totalRows % pageRecorders) == 0) {
totalPages = totalRows / pageRecorders;
} else {
totalPages = totalRows / pageRecorders + 1;
}
totalPages = (totalPages == 0) ? 1 : totalPages;
// 设置第一页开始位置和结束位置
if (totalRows < pageRecorders) {
this.pageStartRow = 0;
this.pageEndRow = totalRows;
} else {
this.pageStartRow = 0;
this.pageEndRow = pageRecorders;
}
// 是否有下一页
if (currentPage >= totalPages) {
hasNextPage = false;
} else {
hasNextPage = true;
}
}
// 转到页面
public List getPageList(int currentPage) {
//当前页小于1
if (currentPage <= 0) {
currentPage = 1;
}
//当前页大于总页数
if (currentPage >= totalPages) {
currentPage = totalPages;
hasNextPage = false;
} else {
hasNextPage = true;
}
//当前页大于1
if (currentPage > 1) {
hasPreviousPage = true;
} else {
hasPreviousPage = false;
}
//判断是否为最后一页
if (currentPage * pageRecorders < totalRows) {
pageEndRow = currentPage * pageRecorders;
pageStartRow = pageEndRow - pageRecorders;
} else {
pageEndRow = totalRows;
pageStartRow = pageRecorders * (totalPages - 1);
}
List<Object> pagelist = new ArrayList<Object>();
for (int i = pageStartRow; i < pageEndRow; i++) {
pagelist.add(arrayList.get(i));
}
return pagelist;
}
}

MyJsp.jsp

<%@ page c%>
<%@ page import="java.util.*" %>
<%@ page import="com.vo.*"%>
<%@ page import="com.servlet.PageBean"%>
<jsp:useBean id="right" scope="request" class="com.factory.Factory"/>
<html>
<head>
<title>熊猫眼工作室</title>
<link rel="stylesheet" href="css/shop.css" type="text/css">
</head>
<body>
<%!
int currentPage=1;
int Recorders= 4;
%>
<%
if(request.getParameter("page")==null||request.getParameter("page")=="")
{
currentPage=1;
}
else
{
currentPage=Integer.parseInt(request.getParameter("page"));
}
List shoplist=right.getShopInstance().queryAll();//数据库查询的数据
PageBean pages=new PageBean(shoplist,Recorders);//传入要分页的数据和每页的记录数
pages.setCurrentPage(currentPage);//设置当前页
List all=pages.getPageList(currentPage);//调用当前页的数据
Iterator cart=all.iterator();//迭代
while(cart.hasNext())//输出数据
{
ShopVo bv = (ShopVo)cart.next() ;
String name=bv.getGoodsname();
%>
<%=name %>
<%}%>
<p>

<form name="form1" method="post" action="MyJsp.jsp">
共<%=pages.getTotalRows() %>条 <%=Recorders %>条/页第<%=pages.getCurrentPage() %>页/共<%=pages.getTotalPages() %>页
<%if(pages.getCurrentPage()<=1){ %>
首页
<%}else{ %>
<a href="MyJsp.jsp?page=1">首页</a>
<%} %>
<%if(pages.isHasPreviousPage()){ %>
<a href="MyJsp.jsp?page=<%=currentPage-1 %>">上一页</a>
<%}else{ %>
上一页
<%}%>
<%if(pages.isHasNextPage()) {%>
<a href="MyJsp.jsp?page=<%=currentPage+1 %>">下一页</a>
<%}else{ %>
下一页
<%}%>
<%if(pages.getCurrentPage()<pages.getTotalPages()){ %>
<a href="MyJsp.jsp?page=<%=pages.getTotalPages() %>">尾页</a>
<% }else{%>
尾页
<%} %>
<select name="page">
<%for(int i=1;i<=pages.getTotalPages();i++)
{%>
<option value="<%=i%>" <%if(i==pages.getCurrentPage()){ out.println("selected");} %>><%=i%></option>
<%}%>
</select>
<input type="submit" name="Submit" value="跳到">
</form>
</p>
</body>
</html>