資料庫分頁演算法java實現

//分頁的方法之所以使用ArrayList來儲存結果，是因為要是用ResultSet來儲存的話，ResultSet要求資料庫要時刻儲存串連才可以，一旦斷開資料庫，rs的資料就沒有了。public ArrayList getFenYe(int pageNow){ArrayList al = new ArrayList();//1.串連資料庫ct = new ConnDb().getConn();//分頁技術的基本演算法String sql = "select * from (select t.*, rownum rn from" +"(select * from users order by userId) t " +"where rownum<="+pageSize*pageNow+") where rn>="+(pageSize*(pageNow-1)+1);try {ps = ct.prepareStatement(sql);rs = ps.executeQuery();//取出記錄//每取出一條記錄，就放入到一個UserBean中while(rs.next()){UserBean ub = new UserBean();ub.setUserId(rs.getInt(1));ub.setUserName(rs.getString(2));ub.setPasswd(rs.getString(3));ub.setEmail(rs.getString(4));ub.setGrade(rs.getInt(5));//將ub添加到ArrayList中al.add(ub);}} catch (SQLException e) {e.printStackTrace();}finally{//關閉資源DbClose dc = new DbClose();dc.Close();}return al;}