乐将秘书 发表于 2009-8-25 17:31:15

带跳转的分页

<p style="FONT-SIZE: 16px">带跳转的分页</p>
<p>function fy(sql,page,pagelistnum,link)<br/>&nbsp; dim rs,znum,zpage<br/>&nbsp; page=cint(page) '将page转换为整型<br/>&nbsp; set rs=server.createobject("adodb.recordset")<br/>&nbsp; rs.open sql,conn,1,1<br/>&nbsp; znum=rs.recordcount&nbsp; '得到总记录条数<br/>&nbsp; zpage=znum\pagelistnum&nbsp; '总记录除以每页条数得到总页数<br/>&nbsp; if znum mod pagelistnum &gt;0 then zpage=zpage+1<br/>&nbsp; response.Write("&lt;form name=MyForm method=get&gt;")<br/>&nbsp;&nbsp;&nbsp; response.write "共" &amp; zpage &amp; "页&amp;nbsp;&amp;nbsp;第" &amp; page &amp; "页&amp;nbsp;&amp;nbsp;"<br/>&nbsp; if page=1 then<br/>&nbsp;&nbsp;&nbsp; response.write "第一页&amp;nbsp;&amp;nbsp;上一页&amp;nbsp;&amp;nbsp;"<br/>&nbsp; else<br/>&nbsp;&nbsp;&nbsp; response.write"&lt;a href=" &amp; link &amp; "&amp;page=1&gt; 第一页&amp;nbsp;&amp;nbsp;&lt;/a&gt; &lt;a href=" &amp; link &amp; "&amp;page="&amp;page-1&amp;"&gt;上一页&amp;nbsp;&amp;nbsp;&lt;/a&gt;"<br/>&nbsp; end if<br/>&nbsp; if page&lt;zpage then<br/>&nbsp;&nbsp;&nbsp; response.write "&lt;a href=" &amp; link &amp; "&amp;page=" &amp; page+1 &amp; "&gt;下一页&amp;nbsp;&amp;nbsp;&lt;/a&gt; &lt;a href=" &amp; link &amp; "&amp;page=" &amp; zpage &amp; "&gt;最后页&amp;nbsp;&amp;nbsp;&lt;/a&gt;"<br/>&nbsp; else <br/>&nbsp;response.write "下一页&amp;nbsp;&amp;nbsp;最后一页&amp;nbsp;&amp;nbsp;"<br/>&nbsp; end if</p>
<p>&nbsp; '创建下拉列表<br/>&nbsp; Response.Write("第&lt;select size=1 name=Page onchange=PageCurrent()&gt;") <br/>&nbsp; For i=1 to zpage <br/>&nbsp;&nbsp;&nbsp; if page="" then <br/>&nbsp;if zpage=1 then Response.Write("&lt;option selected&gt;1&lt;/option&gt;")<br/>&nbsp;Response.Write("&lt;option selected&gt;"&amp;i&amp;"&lt;/option&gt;") ''当前页码<br/>&nbsp;else<br/>&nbsp;Response.Write("&lt;option&gt;"&amp;i&amp;"&lt;/option&gt;")<br/>&nbsp;end if <br/>&nbsp;Next <br/>&nbsp; response.Write("&lt;/select&gt;&lt;/form&gt;")<br/>&nbsp;&nbsp;&nbsp; rs.close<br/>&nbsp; set rs=nothing<br/>end function</p>
页: [1]
查看完整版本: 带跳转的分页