<%@ page language="java" contentType="text/html; charset=GB18030" pageEncoding="GB18030" import="java.sql.*"%> Insert title here
 
<% int C_page = 0; int C_row = 1; int M_size = 12; int CountRow = 0; String StrPage = request.getParameter("Page"); if (StrPage == null) { C_row = 1; } else { C_row = Integer.parseInt(StrPage); } Connection con=yonghu.getCon(); if (con != null) { try { String sqlyy = "Select * from reg "; ResultSet rs=yonghu.GetRs(sqlyy); if(!rs.next()) { out.println("对不起,暂时没有信息"); } else{ rs.last(); int i = 0; CountRow = rs.getRow(); C_page = (CountRow/M_size); if (CountRow%M_size>0) C_page++; Integer n = (C_row-1)*5+1; rs.first(); rs.absolute(C_row*M_size-M_size+1); while (i <% rs.next(); i++; } } } catch (SQLException e) { out.println(e.getMessage()); } finally { con.close(); } } %>
账户 密码 车牌号 金额 姓名 电话 删除
<%=rs.getString("username")%> <%=rs.getString("password")%> <%=rs.getString("chepaihao")%> <%=rs.getString("jine")%> <%=rs.getString("truename")%> <%=rs.getString("tel")%> &j=1">删除
[<%=C_row%>/<%=C_page %>] 每页<%=M_size %>条 共<%=CountRow%>条记录
<% for (int i = 1;i<=C_page;i++){%> [<%=i%>] <%}%>