原始分页

Jsp ：

<div style="float: right;">
   当前为${currentPage}页，共有${totalRow}条数据，共${totalPage}页 
    <select style="border-radius: 18px;" id="pageSize" name="pageSize" onchange="chagePagesize()">
    <c:forEach var="i" begin="1" end="20">
    <option value="${i*5}" ${i*5 eq pageSize ? "selected":""}>${i*5}</option>
    </c:forEach>
    </select>
	<button type="button" class="btn btn-xs btn-info"style="border-radius: 18px;" onclick="firstPage()">首页</button>
	<button type="button" class="btn btn-xs btn-warning"style="border-radius: 18px;" onclick="previousPage()">上一页</button>
	<button type="button" class="btn btn-xs btn-warning"style="border-radius: 18px;" onclick="nextPage()">下一页</button>
	<button type="button" class="btn btn-xs btn-info"style="border-radius: 18px;" onclick="lastPage()">尾页</button>
</div>

<script type="text/javascript">
    var strMsg="${sessionScope.strMsg}";
		if (strMsg!="") {
			alert(strMsg);
		}
		var currentPage=${currentPage};
		var totalPage=${totalPage};
		function firstPage() {
		var pageSize=document.getElementById("pageSize").value;
	    window.location.href="${ctx}/servlet/LoginServlet?fun=autonym&currentPage=1&pageSize="+pageSize; }
		function nextPage() {
		var pageSize=document.getElementById("pageSize").value;
			console.log(pageSize);
			currentPage=currentPage+1;
			if (currentPage>totalPage) {
				alert("已经是最后一页");
				return; 
        }
       window.location.href="${ctx}/servlet/LoginServlet?fun=autonym&currentPage="+currentPage+"&pageSize="+pageSize;
		}
		function previousPage() {
			var pageSize=document.getElementById("pageSize").value;
			currentPage=currentPage-1;
			if (currentPage<1) {
				alert("已经是第一页");
				return;
			}	
		window.location.href="${ctx}/servlet/LoginServlet?fun=autonym&currentPage="+currentPage+"&pageSize="+pageSize;
		}
	   function lastPage() {
			var pageSize=document.getElementById("pageSize").value;
			window.location.href="${ctx}/servlet/LoginServlet?fun=autonym&currentPage="+totalPage+"&pageSize="+pageSize;
		}
	  function chagePagesize(){
		    var pageSize=document.getElementById("pageSize").value;
	        window.location.href="${ctx}/servlet/LoginServlet?fun=autonym&currentPage=1&pageSize="+pageSize;
};	
</script>

Servlet ：

public void autonym(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {	
		String currentPageStr=request.getParameter("currentPage");
		String pageSizeStr=request.getParameter("pageSize");
		int currentPage=1;
		int pageSize=10;
		if (currentPageStr!=null && Tools.isNum(currentPageStr)) {
			currentPage=Integer.parseInt(currentPageStr);
		}
		if (pageSizeStr!=null &&Tools.isNum(pageSizeStr)) {
			 pageSize=Integer.parseInt(pageSizeStr);
		}
		int startIndex=(currentPage-1)*pageSize;
		IUserService userService = new UserServiceImpl();
		List<Userautonym> userautonyms = userService.selectautonym(startIndex,pageSize);
		int totalRow=userService.getTotalRowautonym();
		int totalPage=totalRow/pageSize+1;
		if (totalRow%pageSize==0) {
			totalPage=totalRow/pageSize;
		}
		request.setAttribute("currentPage", currentPage);
		request.setAttribute("pageSize", pageSize);
		request.setAttribute("totalRow", totalRow);
		request.setAttribute("totalPage", totalPage);	
		request.setAttribute("userautonyms", userautonyms);
		request.getRequestDispatcher("/jsp/autonym.jsp").forward(request, response);
	}

Dao 实现：

@Override
	public List<Userautonym> selectautonym(int startIndex, int pageSize) {
		List<Userautonym> userautonyms = new ArrayList<Userautonym>();
		Userautonym userautonym = null;
		try {
			con=DbUtil.getConnection();
			ps=con.prepareStatement(selectRows);//主要查询分页limit ?,? 
			ps.setInt(1, startIndex);
			ps.setInt(2, pageSize);
			rs=ps.executeQuery();
			while (rs.next()) {
			userautonym = new Userautonym();
	        userautonym.setUserAthenticationID(rs.getInt("UserAthenticationID"));
			userautonym.setUserID(rs.getInt("UserID"));
		    userautonym.setAthenticationID(rs.getInt("AthenticationID"));
			userautonym.setExamineStateID(rs.getInt("ExamineStateID"));
	        userautonym.setExamineStatename(rs.getString("ExamineStatename"));	
	        userautonym.setUserName(rs.getString("UserName"));
			userautonym.setCellphone(rs.getString("Cellphone"));
			userautonym.setApply(rs.getString("Apply"));
			userautonym.setPass(rs.getString("Pass"));
			userautonym.setRemarks(rs.getString("Remarks"));
			userautonyms.add(userautonym);
			}				
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DbUtil.close(con, ps, rs);
		}	
		return userautonyms;
	}