效率比较高的jsp分页程序

可通过下拉框跳转到指定页

<script language="javascript">
function gopage()
{
document.listpage.submit();
}
function previouspage()
{
if ( (parseInt(document.listpage.page.value) ) < 1)
document.listpage.page.value = 1;
else
{
document.listpage.page.value = parseInt(document.listpage.page.value) - 1;
document.listpage.submit();
}
}
function nextpage()
{
document.listpage.page.value = parseInt(document.listpage.page.value) + 1;
document.listpage.submit();
}
function gopagebyno(pageno)
{
document.listpage.page.value = pageno;
document.listpage.submit();
}

</script>
<%
Connection m_Connection=null;
Statement m_Statement=null;
ResultSet m_ResultSet=null;
String sql;
String dbpath = application.getRealPath("/数据库位置"); //将相对路径转化成物理路径
String connStr ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
m_Connection=DriverManager.getConnection(connStr);
m_Statement=m_Connection.createStatement(1004,1007);
sql=查询语句;
m_ResultSet=m_Statement.executeQuery(sql);
%>
<div>
<table class="list" width="580" >
<%
int i=1;
int rscount=0;//记录条数
int allpages=1;//所有页数
if(m_ResultSet!=null)
{m_ResultSet.last();
rscount=m_ResultSet.getRow();
if(rscount>0)
{allpages=rscount / 10;
if(rscount>(allpages * 10)){allpages=allpages+1;}
if(curpage==1){m_ResultSet.first();}
else{m_ResultSet.absolute(10*(curpage-1)+1);}
while(!m_ResultSet.isAfterLast())
{%>
<tr valign="top" height="15">
<td><%=m_ResultSet.getString("d_d_name")%></td>
<td><%=m_ResultSet.getString("d_t_name")%></td>
<td><input　style="margin:0px;" type="button" name="Submit2" onClick="actiondo('del','<%=m_ResultSet.getString("d_d_id")%>','<%=curpage%>')" value="删除"><input　style="margin:0px;"　type="button" name="Submit3" onClick="actiondo('edit','<%=m_ResultSet.getString("d_d_id")%>','<%=curpage%>')" value="编辑"></td>
</tr>
<%
i++;
if(i>10){break;}
m_ResultSet.next();
}
}
m_ResultSet.close();
}
%>
</table>
</div>
<div align="center">
<form name="listpage">
<font color='#000080'>&nbsp;页次:</font>
<b><font color=red><%=curpage%></font></b><font color='#000080'>/<b><%=allpages%></b>&nbsp;</font>
<font color='#000080'>
<% if (curpage!=1)
{out.print("<a href='javascript:gopagebyno(1)'>首页</a>");}
else
{out.print("首页");}
%>
</font>
<font color='#000080'>
<%if(curpage!=1)
{out.print("<a href='javascript:previouspage()'>上页</a>");}
else
{out.print("上页");}
%>
</font>
<font color='#000080'>
<% if(allpages!=0&&(curpage<allpages))
{out.print("<a href='javascript:nextpage()'>下页</a>");}
else
{out.print("下页");}
%>
</font>
<font color='#000080'>
<% if(allpages!=0&&(curpage<allpages))
{out.print("<a href='javascript:gopagebyno("+allpages+")'>尾页</a>");}
else
{out.print("尾页");}
%>
</font>
<select name="page" onChange="javascript:gopagebyno(document.listpage.page.value)" >
<%for(i=1;i<=allpages;i++)
{if(curpage==i){out.print("<option value='"+i+"' selected='selected'>"+i+"</option>");}
else{out.print("<option value='"+i+"'>"+i+"</option>");}
}
%>
</select>
</form>
</div>