JSP如何实现分页功能

最新推荐文章于 2024-08-01 19:31:57 发布

current_person

最新推荐文章于 2024-08-01 19:31:57 发布

阅读量1.1k

点赞数

分类专栏： java 文章标签：分页 jsp

本文链接：https://blog.csdn.net/current_person/article/details/50313597

版权

java 专栏收录该内容

72 篇文章 0 订阅

订阅专栏

public List<Peruser> selectPeruserForpage(int offset,int pageSize)
	{
		// 步骤1：获取一个数据库连接对象
				List<Peruser> lstPeruser=new ArrayList<Peruser>();
				this.conn = this.connectionManager.openConnection();
				// 步骤2：创建SQL语句模板
				String strSQL = "select * from peruser";
				Object[] params = new Object[] {};
				// 步骤4：调用dbutils中的方法完成对数据库的查询操作
				ResultSet resultSet = this.dbUtils.execQuery(conn, strSQL, params);
				// 步骤5：获取结果集合并封装成一个对象
				try {
					for(int i = 0;resultSet.next() && (i < offset+pageSize);i++){
						if(i < offset)
							continue;
						Peruser peruser = new Peruser();
						peruser.setUserid(resultSet.getInt(1));
						peruser.setNickname(resultSet.getString(2));
						peruser.setUserpho(resultSet.getString(3));
						peruser.setSportlabel(resultSet.getString(4));
						// 步骤7：返回对象
						lstPeruser.add(peruser);
						for(int j = 0;j < lstPeruser.size();j++)
							System.out.println(lstPeruser.get(j));
					}
					return lstPeruser;
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
					return null;
				} finally {
					this.connectionManager.closeConnection(conn);
				}
	}

}
Servlet层进行如下调用：
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("UTF-8");
		IUserBiz useBiz=new UserBizImpl();
		HttpSession session=request.getSession();
		Person person=(Person)session.getAttribute("person");
		List<Peruser> lst=new ArrayList<Peruser>();
		if(request.getParameter("action") ==null){
			System.out.println("enter if session.get");
	    lst=useBiz.tuiFriend(person.getRegid(), 0, 4);
	    session.setAttribute("page", 0);
	    request.getSession().setAttribute("lst", lst);
	    response.sendRedirect("jsp/myspace/main.jsp");
		}else{
			System.out.println("enter else session.get");
			if (request.getParameter("action").equals("before")) {
				session.setAttribute("page", (int)(session.getAttribute("page"))-1);
				lst=useBiz.tuiFriend(person.getRegid(),(int)(session.getAttribute("page"))*4, 4);
			    request.getSession().setAttribute("lst", lst);
				response.sendRedirect("jsp/myspace/main.jsp");
			} else {
				
				 session.setAttribute("page", (int)(session.getAttribute("page"))+1);
				 lst=useBiz.tuiFriend(person.getRegid(),(int)(session.getAttribute("page"))*4, 4);
				 request.getSession().setAttribute("lst", lst);
				 response.sendRedirect("jsp/myspace/main.jsp");
			}
		}
		
		System.out.println(lst.toString());
	}

}