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

[code]/***************************************************************************
* 获取分页的全部信息
*/
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>
<%
}
%>[/code]