try{
DataConn Conn=new DataConn(); 
String sql="select * from test"
Statement smt=Conn.getConn().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); 
ResultSet rs=smt.executeQuery(sql);  
ResultSet rs=(ResultSet)request.getAttribute("rs");
if(!rs.next()){ 
out.println("没有添加成员"); 
}else{ 
int pagesize=5; 
int showpage=1; 
int rowcount=0; 
int pagecount=0;
  
rs.last(); 
rowcount=rs.getRow(); 
 
pagecount=(((rowcount%pagesize)==0)?(rowcount/pagesize):(rowcount/pagesize+1)); 
String topage=request.getParameter("topage"); 
if(topage!=null){ 
showpage=Integer.parseInt(topage); 
if(showpage>pagecount){ 
showpage=pagecount; 
}else if(showpage<=0){ 
showpage=1; 
} 

} 
rs.absolute((showpage-1)*pagesize+1); 

for(int i=1;i<=pagesize;i++){
int resources_id=rs.getInt("Id");
String name=rs.getString("resources_name");
String summary=rs.getString("resources_summary");
String download=rs.getString("resources_download");        
%>
      <tr>
                <td width="90" height="22" valign="top" class="d1"><span style="font-size:12px"><%=name%></span></td>
                <td width="308" valign="top" scope="col" class="d1"><span style="font-size:12px">&nbsp;&nbsp;<%=summary %></span></td>
                <td width="51"  valign="top" scope="col" class="d1"><span style="font-size:12px"><div align="center"><a href="<%=download %>">下载</a></div></span></td>
              </tr>
<%
if(!rs.next())break;
} 
 
%> 

<tr>
<td colspan="3">
<p align="right"><span class="STYLE1">
<a href="?topage=1">第一页</a>
<a href="?topage=<%=showpage-1%>">上一页</a>
<a href="?topage=<%=showpage+1%>">下一页</a>
<a href="?topage=<%=pagecount %>">最后页</a><%= showpage + "/" + pagecount %></span></p></td>
</tr>
<%
}
}catch(Exception h){
System.out.println(h);
} %>