javaweb之jsp+servlet简单实现学生信息管理系统

package dbservlet; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import bean.Page; import bean.StudentInfo; public class SetAndGetPage { Select se=new Select(); //设置分页相关参数方法 public Page setpage(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException{ String crd=request.getParameter("currentRecord"); //String id=request.getParameter("id"); // String name=request.getParameter("name"); ArrayList<StudentInfo> result=se.select("",""); Page pager=new Page(); pager.setTotalRecord(result.size()); pager.setTotalPage(result.size(),pager.getPageSize()); if(crd!=null) { int currentRecord=Integer.parseInt(crd); pager.setCurrentRecord(currentRecord); pager.setCurrentPage(currentRecord,pager.getPageSize()); } return pager; } //获得分页显示的子集 public void difpage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException{ // String id=request.getParameter("id"); // String name=request.getParameter("name"); ArrayList<StudentInfo> result=se.select("",""); //返回查询的结果集 Page pager=new Page(); pager=setpage(request,response); List<StudentInfo> subResult=null; int currentRecord=pager.getCurrentRecord(); if(currentRecord==0){ if(pager.getTotalRecord()<8){ subResult=(List<StudentInfo>) result.subList(0,pager.getTotalRecord()); } else{ subResult=(List<StudentInfo>) result.subList(0,pager.getPageSize()); } } else if(pager.getCurrentRecord()+pager.getPageSize()<result.size()) { subResult=(List<StudentInfo>) result.subList(pager.getCurrentRecord(),pager.getCurrentRecord()+pager.getPageSize()); } else { subResult=(List<StudentInfo>) result.subList(pager.getCurrentRecord(),result.size()); } request.setAttribute("pager", pager); request.setAttribute("subResult", subResult); request.getRequestDispatcher("layout.jsp").forward(request, response); } }