if sql="" then
sql=session("sql")
end if
session("sql")=sql
show=request("show")
set rs=server.CreateObject("adodb.recordset")
sql=sql
rs.open sql,conn,1,1
if not rs.eof then
tol=rs.recordcount
rs.pagesize=show
maxpage=rs.pagecount
requestpage=clng(request("p"))
else
maxpage=0
tol=0
show=0
end if
%>
<table width="649" border="0" align="center">
<tr valign="middle">
<form name="form1">
<td width="14%" valign="middle">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<%for i=1 to 200%>
<option value="Table_print_p.asp?show=<%=i%>" <%if i=int(show) then%>selected<%end if%>>每页显示<%=i%>条记录</option>
<%next%>
</select> </td></form>
<form name="form2">
<td width="7%" valign="middle">
<select name="menu3" onChange="MM_jumpMenu('parent.mainFrame',this,0)">
<%for i=1 to maxpage%>
<option value="Table_print.asp?p=<%=i%>&show=<%=show%>&sql=<%=request("sql")%>" >第<%=i%>页</option>
<%next%>
</select> </td>
<td width="64%" height="23" valign="middle"> 总页数：<%=maxpage%> 总条数：<%=tol%></td>
<td width="15%" align="right"><a href=java script:parent.mainFrame.fcous;window.print();>打印</a></td>
</form>
</tr>
</table>
打印预览页面代码如下：
<%
sql=request("sql")
if request("sql")="" then
sql=session("sql")
end if
session("sql")=sql
show=request("show")
set rs=server.CreateObject("adodb.recordset")
sql=session("sql")
rs.open sql,conn,1,1
%>
<%
if not rs.eof then
tol=rs.recordcount
rs.pagesize=show
maxpage=rs.pagecount
requestpage=clng(request("p"))
if requestpage="" or requestpage=0 then
requestpage=1
end if
if requestpage>maxpage then
requestpage=maxpage
end if
if requestpage<>1 then
rs.move (requestpage-1)*rs.pagesize
end if
for i=1 to rs.pagesize and not rs.eof
%>
<tr align="center">
<td height="30"><%=rs("ClientName")%></td>
<td><%=rs("ClientCountry")%></td>
<td><%=rs("ClientCity")%></td>
<td><%=rs("ClientTel")%></td>
<td><%=rs("Cli
