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