分页 （利用 数据库 存储过程 rownum）

/***************************************************************************
     * 获取分页的全部信息
     */
    public List getAllI(int UserID, int nPageSize,int nPageNum)
    {
        ArrayList list = new ArrayList();
        String sql = "select ID,to_Char(AddDate,'yyyy-mm-dd') as sDate, rowNum as rn                            from  tData_Inquire " + "where  State = 0 ";           
        sSQL=sql;
        
        sql="select * from ("+sql+") temp where temp.rn>"+(nPageSize*(nPageNum-1))
                            +" and temp.rn<="+(nPageSize*(nPageNum));
        try
        {            
            openDB();
            rs = st.executeQuery(sql);
            while (rs.next())
            {                    
                InquireAttr attr = new InquireAttr();
                attr.setNID(rs.getInt("ID"));              
                。。。。
                list.add(attr);
            }
        }
        catch (SQLException e)
        {
            。。。。
        }
        finally
        {
            closeDB();
        }
        return list;
    }
    

 /******************************
     * 分页 得到数据个数
     */
    public int getPageInfo(){
        sql="select count(*) from ("+sSQL+")";
        int nRecordCount = bean.changeInt(getOneValue(sql));

        return nRecordCount;
    }

                        
 <%
                         int nRecordCount = inquireBean.getPageInfo();
                         int nPageCount = (nRecordCount+nPageSize-1)/nPageSize;
  %>
                              共 <%=nRecordCount%> 条记录   
<%                            if(nRecordCount>0){ %>
                             <%=nPageNum%>/<%=nPageCount%>
                            <a href="Inquire.jsp?pageNum=1">首页</a>
<%                            if(nPageNum>1){%>
                            <a href="Inquire.jsp?pageNum=<%=nPageNum-1%>">上一页</a>
<%    
                            } 
%>
<%                            if(nPageNum<nPageCount){%>
                            <a href="Inquire.jsp?pageNum=<%=nPageNum+1%>">下一页</a>
<%    
                            }
 %>