首先后台分页需要理清分页思路，把数据库里面需要分页的信息放到List集合中，然后按照页面反馈给后台的页码对List集合进行SubList切割把切完的List传到前端进行显示。
1.分页的demo文件结构图
导入的包
2.代码
SplitPageServlet代码
package ActionServlet; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import Bean.ProjectBean; import Service.SplitPage; /** * Servlet implementation class SplitPageServlet */ @WebServlet("/SplitPageServlet") public class SplitPageServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public SplitPageServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub List<ProjectBean>listArr = new ArrayList<ProjectBean>(); String currrentPageString = request.getParameter("currrentPage"); String numberForSplitPage = request.getParameter("numberForSplitPage"); if( currrentPageString ==null){ currrentPageString = "1"; } if( numberForSplitPage == null){ numberForSplitPage = "5"; } SplitPage splitPage = new SplitPage(); try { listArr = splitPage.AllSplitPage(numberForSplitPage, currrentPageString); request.setAttribute("subResult", listArr); } catch (ClassNotFoundException | SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } System.out.println(SplitPage.pageNumber); System.out.println(SplitPage.currentPageIndex); request.setAttribute("pageNumber", SplitPage.pageNumber); request.setAttribute("currentPageIndex", SplitPage.currentPageIndex); request.getRequestDispatcher("/servlet/ShowViewIndex").forward(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
ProjectBean代码
package Bean; public class ProjectBean { private String projectId = null; private String projectName = null; private String projectType = null; private String userNo = null; private String projectUser = null; public String getProjectId(){ if(projectId==null){ projectId =""; } return this.projectId; } public void setProjectId(String projectId){ this.projectId = projectId; } public void setProjectName(String projectName){ this.projectName = projectName; } public String getProjectName(){ return this.projectName; } public void setType(String projectType){ this.projectType = projectType; } public String getProjectType(){ return this.projectType; } public void setUserNo(String userNo){ this.userNo = userNo; } public String getUserNo(){ return this.userNo; } public void setProjectUser(String projectUser){ this.projectUser = projectUser; } public String getProjectUser(){ return this.projectUser; } }
SplitPageBean 代码
package Bean; public class SplitPageBean { private int allitems;//总的记录数 private int currentRecord;//当前的记录数 private int lastPageRecord ; //上一页记录数开始数 private int nextPageRecord;//下一页记录数开始数 private int lastPageIndex ; //上一页 private int nextPageIndex;//下一页 private int currentPageIndex;//当前页 private int numberForSplitPage;//每页分的数量 private int allPageNumber; public int getAllitems(){ return this.allitems; } public void setAllitems(int allitems){ this.allitems = allitems; } public int getCurrentRecord(){ return this.currentRecord; } public void setCurrentRecord(int currentPageIndex){ this.currentRecord = currentPageIndex * this.numberForSplitPage; } public int getlastPageRecord(){ return this.lastPageRecord; } public void setLastPageRecord(int lastPageIndex){ this.lastPageRecord = lastPageIndex * this.numberForSplitPage; } public int getNextPageRecord(){ return this.nextPageRecord; } public void setNextPageRecord(int nextPageIndex){ this.nextPageRecord = nextPageIndex * this.numberForSplitPage; } public int getLastPageIndex(){ return this.lastPageIndex; } public void setLastPageIndex(int currentPageIndex){ this.lastPageIndex = currentPageIndex - 1; } public int getNextPageIndex(){ return this.nextPageIndex; } public void setNextPageIndex(int currentPageIndex){ this.nextPageIndex = currentPageIndex - 1; } public int getCurrentPageIndex(){ return this.currentPageIndex; } public void setCurrentPageIndex(int currentPageIndex){ this.currentPageIndex = currentPageIndex; } public int getNumberForSplitPage(){ return this.numberForSplitPage; } public void setNumberForSplitPage(int numberForSplitPage){ this.numberForSplitPage = numberForSplitPage; } public int getAllPageNumber(){ return this.allPageNumber; } public void setAllPageNumber(int allitems){ this.allPageNumber = allitems / this.numberForSplitPage + 1; } }
QueryProject代码