?? table_print_top2.asp
字號:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=DataBase/conn.asp-->
<%
sql=request("sql")
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
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標題文檔</title>
<style type="text/css">
<!--
.style1 { font-size: 16px;
font-style: italic;
}
body,td,th {
font-size: 12px;
}
a:link {
color: #0000FF;
}
a:visited {
color: #0000FF;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<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_fk.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_f.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=javascript:parent.mainFrame.fcous;window.print();>打印</a></td>
</form>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -