%@ page language="java" import="java.sql.*" %> %@ page contentType="text/html; charset=gb2312" %> %@ include file="conn.jsp" %> % ....... int pages=0; int pagesize=10; ResultSet result = null; ResultSet rcount = null;
pages = new Integer(request.getParameter("pages")).intValue();
if (pages>0) {
String sql=" state='我不傻'"; int count=0; try { rcount = stmt.executeQuery("SELECT count(id) as id from user where "+sql); catch(SQLException ex) { out.print("aq.executeQuery: " + ex.getMessage()); } if(rcount.next()) count = rcount.getInt("id"); rcount.close();
if (count>0) { sql="select * from user where "+sql; try { result = stmt.executeQuery(sql); } catch(SQLException ex) { out.print("aq.executeQuery: " + ex.getMessage()); }
int i; String name; // result.first(); // result.absolute((pages-1)*pagesize); // 此方法jdbc2.0支持。編譯通過，但執行不過，不知是不是跟驅動有關，只好用下面的笨辦法。 for(i=1;i=(pages-1)*pagesize;i++) result.next(); for(i=1;i=pagesize;i++) { if (result.next()) { name=result.getString("name"); out.print(name); } result.close(); int n= (int)(count/pagesize); if (n*pagesizecount) n++; if (n>1) { for(i=1;i=n;i++) out.print("a href=query.jsp?pages="+i+">"+i+"nbsp;/a>"); } } } %>
