根据我给你的代码可以在页面显示所有的记录 但是数据太多的话不能分页就很麻烦了!我现在要根据可滚动的结果集实现分页。要求每页显示15条记录分页功能有: 首页,下一页 上一页 末页  希望高手门能实现,并给出代码!望能与其结为朋友联系:qq:59431800 email:[email protected]
 //操作数据的executeMe.java
package method;
import testdemo1.DBConnection;
import method.userBean;
import java.sql.*;
import java.util.*;
import java.util.Iterator;
public class executeMe{
    private  Connection dbconn =  null;
    public executeMe() {
    try {
             dbconn =DBConnection.getConnection();
            if (dbconn != null) {
                System.out.println("数据库已经连接!");
            }
        }catch (Exception ex) {
            ex.printStackTrace();
        }    }
    //查询所有
    public Iterator select(){
        Vector v = new Vector();
  String sqlstr = "select * from user_info where quanx<>'系统管理员' order by RIG_TIME desc";
        try{
        Statement stmt = dbconn.createStatement();
        ResultSet rs= stmt.executeQuery(sqlstr);
        while(rs.next()){
            userBean u=new userBean();
            u.setUSER_ID(rs.getString("USER_ID"));
            u.setUSERNAME(rs.getString("USERNAME"));
            u.setPASSWORD(rs.getString("PASSWORD"));
            u.setGENDER(rs.getString("GENDER"));
            u.setREALNAME(rs.getString("REALNAME"));
            u.setEMAIL(rs.getString("EMAIL"));
            u.setTELEPHONE(rs.getString("TELEPHONE"));
            u.setCOMPANY(rs.getString("COMPANY"));
            u.setADDRESS(rs.getString("ADDRESS"));
            u.setCODING(rs.getString("CODING"));
            u.setRIG_TIME(rs.getString("RIG_TIME"));
            u.setQUANX(rs.getString("QUANX"));
            v.add(u);
        }
        rs.close();
        stmt.close();
        }catch(Exception ex){
        ex.printStackTrace();
    }finally{
        try{
            if (dbconn != null) dbconn.close();
            System.out.println("断开连接!");
        }catch(SQLException ex){
            ex.printStackTrace();
        }
    }
      Iterator it=v.iterator();
        return it;    }
    public Iterator select(String USER_ID){
       Vector v = new Vector();
       String sqlstr = "select * from user_info where USER_ID='"+USER_ID+"' order by RIG_TIME desc";
       try{
       Statement stmt = dbconn.createStatement();
       ResultSet rs= stmt.executeQuery(sqlstr);
       while(rs.next()){
            userBean u=new userBean();
            u.setUSER_ID(rs.getString("USER_ID"));
            u.setUSERNAME(rs.getString("USERNAME"));
            u.setPASSWORD(rs.getString("PASSWORD"));
            u.setGENDER(rs.getString("GENDER"));
            u.setREALNAME(rs.getString("REALNAME"));
            u.setEMAIL(rs.getString("EMAIL"));
            u.setTELEPHONE(rs.getString("TELEPHONE"));
            u.setCOMPANY(rs.getString("COMPANY"));
            u.setADDRESS(rs.getString("ADDRESS"));
            u.setCODING(rs.getString("CODING"));
            u.setRIG_TIME(rs.getString("RIG_TIME"));
            u.setQUANX(rs.getString("QUANX"));
           v.add(u);
       }
       rs.close();
       stmt.close();
       }catch(Exception ex){
       ex.printStackTrace();
   }finally{
       try{
           if (dbconn != null) dbconn.close();
           System.out.println("断开连接!");
       }catch(SQLException ex){
           ex.printStackTrace();
       }
   }
     Iterator it=v.iterator();
       return it;   }
}
代码后面还有