JSP翻页功能代码

<%

int intpagesize; //一页显示的记录数 

int introwcount; //记录总数 

int intpagecount; //总页数 

int intpage; //待显示页码 

string strpage; 

//设置一页显示的记录数 

intpagesize = 25; 

//取得待显示页码 

strpage = request.getparameter("page"); 

if(strpage==null){//表明在querystring中没有page这一个参数，此时显示第一页数据 

intpage = 1; 

}else{//将字符串转换成整型 

intpage = java.lang.integer.parseint(strpage); 

if(intpage< 1){ 

} 

rs=connjb.executequery(sql); 

rs.absolute(1); 

//获取记录总数 

rs.last(); 

introwcount = rs.getrow(); 

//记算总页数 

intpagecount = (introwcount+intpagesize-1) / intpagesize; 

//调整待显示的页码 

if(intpage >intpagecount) intpage = intpagecount; 

if(intpagecount >0){ 

//将记录指针定位到待显示页的第一条记录上 

rs.absolute((intpage-1) * intpagesize+1); 

//显示数据 

i = 0; 

while(i< intpagesize && !rs.isafterlast()){ 

if(!classname.equals("行业分类")){ 

//id=rs.getint("information_id"); 

strid=rs.getstring("information_id"); 

subjectname=rs.getstring("information_name"); 

informationrank=rs.getstring("information_rank"); 

%> 

<tr> 

<td width="4%" height="25" valign="middle"><div align="center">◇</div></td> 

<td width="96%"><a href="index2.jsp?information_id=<%=strid%>&information_rank=<%=informationrank%>" class="t8"><%=subjectname%></a></td> 

</tr> 

<% }else{ 

strid=rs.getstring("sub_class_value"); 

subjectname=rs.getstring("sub_class_value"); 

<td width="96%"><a href="index_way.jsp?small_class=<%=strid%>" class="t8"><%=subjectname%></a></td> 

<%}%> 

<% 

rs.next(); 

i++; 

}rs.close(); 

i=0; 

</table> 

<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#cccccc"> 

<td valign="top" bgcolor="#f2f2f2"> 

<div align="left"> 

</div></td> 

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#8c8c8c"> 

<td height="22" align="center" bgcolor="#ffffff">第<%=intpage%>页 共<%//=introwcount%>条记录/共<%=intpagecount%>页 

if(intpage<2){ 

out.print("首页 | 上一页"); 

}else{%> 

<a href="index.jsp?class_name=<%=classname%>&subject_name=<%=titlename%>">首页 </a> | <a href="index.jsp?page=<%=intpage-1%>&class_name=<%=classname%>&subject_name=<%=titlename%>">上一页</a> 

| 

if((intpagecount-intpage)<1) 

{ 

out.print("下一页 | 尾页"); 

<a href="index.jsp?page=<%=intpage+1%>&class_name=<%=classname%>&subject_name=<%=titlename%>">下一页</a> | <a href="index.jsp?page=<%=intpagecount%>&class_name=<%=classname%>&subject_name=<%=titlename%>">尾页</a> 

<%} 

else{ 

out.print("<center><table width=776 border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#000000><tr><td bgcolor=#ffffff><center>目前还没有内容！</center></td></tr></table></centre>"); 

}%> 

其中sql为具体的sql语句.