JSP 分页查询数据

1、JSP页面 引用

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

JSP代码：

<pre name="code" class="javascript"><table><tr><td colspan="8" align="right"><c:if test="${page != 1 }"><a href="pagtingServlet?page=${page-1 }">上一页</a>  </c:if><c:if test="${page != maxPage }"><a href="pagtingServlet?page=${page+1 }">下一页</a></c:if></td></tr></table>

2、Servlet页面：

private static int pageSize = 1;   //pageSize 是每页显示多少条数据  我这里只显示1条@Overrideprotected void service(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {request.setCharacterEncoding("utf-8");response.setCharacterEncoding("utf-8");response.setContentType("utf-8");String pageTemp = request.getParameter("page");// 当前页int page;if(pageTemp != null){page = Integer.valueOf(pageTemp);}else{page = 1;       }int startPage = (page - 1) * pageSize ;ServiceIn service = new Service();List<User> lstStu =  service.findStudentPating(startPage,pageSize);//总数据数int dataCount = service.ChaXun().size();//调用查询数据库方法int maxPage = dataCount/pageSize;if(dataCount % pageSize != 0){maxPage++;}request.setAttribute("lstStu", lstStu);request.setAttribute("page", page);request.setAttribute("maxPage", maxPage);request.getRequestDispatcher("filter/page.jsp").forward(request, response);//将数据传回JSP页面}}

3、显示效果

效果1：

效果2：

效果3：

如果要加首页和尾页只需多加一个<a>标签 并把 href设置成第一页或最后一页

显示当前页数也是同理