Connection conn = DB.getConn();
MYSQL利用limit实现分页查询，而SQL Server利用了子查询。1 .//String sql = "select * from user_info limit " + (pageNo - 1) * pageSize // + "," + pageSize;2. String sql = "select top " +pageSize+ " * from user_info where id not in(select top " +pageSize*(pageNo-1)+ " id from user_info order by id asc) order by id";
jsp页面；
<%final int PAGE_SIZE = 5; //每页显示多少条记录int pageNo = 1;String strPageNo = request.getParameter("pageNo");if (strPageNo != null && !strPageNo.trim().equals("")) { try { pageNo = Integer.parseInt(strPageNo); } catch (NumberFormatException e) { pageNo = 1; }}if (pageNo <= 0) pageNo = 1;%><%List<User> users = new ArrayList<User>();int totalRecords = UserMgr.getInstance().getUsers(users, pageNo, PAGE_SIZE);分页查询函数调用。int totalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
if (pageNo > totalPages) pageNo = totalPages;%>
…………………………
<table class="tableborder" cellpadding="2" cellspacing="1"> <tbody> <tr class="smalltxt" bgcolor="#f3f6fa"> <!-- 这行是总页数 --> <td class="header"> <%=totalRecords %> </td> <!-- 这行是显示 “当前页数/总页数” --> <td class="header"> <%=pageNo %>/<%=totalPages %> </td> <td> <a href="UserList.jsp?pageNo=<%=1%>">第一页</a> </td> <td> <a href="UserList.jsp?pageNo=<%=pageNo-1%>">上一页</a> </td> <td> <a href="UserList.jsp?pageNo=<%=pageNo+1%>">下一页</a> </td> <td> <a href="UserList.jsp?pageNo=<%=totalPages%>">最后一页 </a> </td> </tr> </tbody> </table> </td> </tr> <tr> <td height="3"></td> </tr> </tbody> </table> </td> </tr> </tbody> </table>
<input name="formhash" value="93a2a31f" type="hidden"> <table class="tableborder" align="center" cellpadding="4" cellspacing="1" width="97%"> <tbody> <tr class="header"> <td align="center" width="9%">用户名</td> <td align="center" width="6%">UID</td> <td align="center" width="16%">联系电话</td> <td align="center" width="20%">注册时间</td> <td align="center" width="20%">送货地址</td> <td align="center" width="10%">会员等级</td> <td align="center" width="10%">积分</td> <td align="center" width="20%">处理</td> </tr>
<% for (int i = 0; i < users.size(); i++) { User u = users.get(i); %>
<tr> <td class="altbg1" align="center" nowrap="nowrap"> <%=u.getUsername()%> </td> <td class="altbg2" align="center"> <%=u.getId()%> </td> <td class="altbg1" align="center"> <%=u.getPhone()%> </td> <td class="altbg1" align="center"> <%=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss") .format(u.getRdate())%> </td> <td class="altbg1" align="center"> <%=u.getAddr()%> </td> <td class="altbg1" align="center"> <%=u.getGrade()%> </td> <td class="altbg1" align="center"> <%=u.getIntergal()%> </td> <td class="altbg1" align="right"> <a target="detail" href = UserModify.jsp?id=<%=u.getId()%>>修改</a> <% String url = request.getRequestURL() + (request.getQueryString() == null ? "" : "?" + request.getQueryString()); %> <a target="detail" href="UserDelete.jsp?id=<%=u.getId()%>&from=<%=url%>" οnclick="return confirm('真的要删除?')">删除</a> </td> </tr>
<% } %> </tbody> </table>
