可通過下拉框跳轉到指定頁
<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'> 頁次:</font>
<b><font color=red><%=curpage%></font></b><font color='#000080'>/<b><%=allpages%></b> </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>
