?? adminbackup.asp
字號:
<%
if session("password")<>"" then
session("return")=request.ServerVariables("SCRIPT_NAME")
%>
<!-- #include file="inc/conn.asp" -->
<!-- #include file="images/jav.inc" -->
<!-- #include file="inc/top.asp"-->
<!-- #include file="inc/adminmenu.asp" -->
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign='top'>
<p>
<!--#include file="inc/conn1.asp"-->
<%
page = CLng(request("page")) '利用CLng函數把page值轉換為Long型
judge=request("judge")
judge2=request("judge2")
judge3=0
sqlcmd="select * from bbs1 Order By id desc"
rs.Open sqlcmd,newconn,1,2
%>
</p>
<form method="POST" id=form1 name=form1>
<table width="768" border='0' align="center" cellpadding='0' cellspacing='1' bordercolor="#F0F0F0" id=TabDocMain>
<tr bgcolor="#A0A4AC">
<td width="42" height="25" align=center> 刪除框 </td>
<td width="105" height="25" align=center>年代</td>
<td width="100" height="25" align=center>工號</td>
<td width="90" height="25" align=center>姓名</td>
<td width="99" height="25" align=center>項目</td>
<td width="72" height="25" align=center>分數</td>
<td width="85" height="25" align=center>年度</td>
<td width="80" height="25" align=center>類型</td>
<td width="75" height="25" align=center>操作</td>
</tr>
<%
if not (rs.EOF or rs.BOF) then
rs.MoveFirst
rs.PageSize = 12 '每頁顯示的條數
If page < 1 Then page = 1
If page > rs.PageCount Then page = rs.PageCount
rs.AbsolutePage = page
For ipage = 1 To rs.PageSize
%>
<tr bgcolor="#A0A4AC">
<td width="42" height="25" align=center>
<input type="checkbox" name="answer" value="<%=rs("id")%>" id="Checkbox1"> </td>
<td width="105" height="25" align=left><div align="center"><%=rs("bj")%></div></td>
<td width="100" height="25" align=left><div align="center"><%=rs("xh")%></div></td>
<td width="90" height="25" align=left><div align="center"><%=rs("user")%></div></td>
<td width="99" height="25" align=left nowrap><div align="center"><%=rs("kc")%></div></td>
<td width="72" height="25" align=left><div align="center"><%=rs("cj")%></div></td>
<td width="85" height="25" align=left><div align="center"><%=rs("xq")%></div></td>
<td width="80" height="25" align=left><div align="center"><%=rs("lx")%></div></td>
<td width="75" height="25" align=center><a href="updata.asp?kind=date&id=<%=rs("id")%>">修改</a></td>
</tr>
<%
rs.MoveNext
If rs.EOF Then Exit For
Next
%>
<tr bgcolor="#A0A4AC">
<td height="25" colspan="9">
<input type="checkbox" name="chkall" value="on" onClick="checkall(this)" id="Checkbox2">
選中所有的顯示成績 <input type="button" name="btnDelete" value="刪除" style='font-family: 宋體; font-size: 9pt;' onClick="del()" id="Button1"> <input type="reset" name="b" value="重置" style='font-family: 宋體; font-size: 9pt;' id="Button1"> </td>
</tr>
</table>
</form>
<table border="0" align="center" cellpadding="0" cellspacing="0" width="768">
<tr bgcolor="#A0A4AC">
<form onSubmit="return test();" method="get" action="admin.asp" id=form2 name=form2>
<td width="220" height="25" >
<%
If page = 1 Then
Response.Write "<font class='white'>第一頁 上一頁</font>"
End If
If page <> 1 Then
Response.Write "<a href=admin.asp?page=1 class='yellow'>第一頁</a>"
Response.Write " <a href=admin.asp?page=" & (page - 1) & " class='yellow'>上一頁</a>"
End If
If page <> RS.PageCount Then
Response.Write " <a href=admin.asp?page=" & (page + 1) & " class='yellow'>下一頁</a>"
Response.Write " <a href=admin.asp?page=" & RS.PageCount & " class='yellow'>最后一頁</a>"
End If
If page = RS.PageCount Then
Response.Write " <font class='white'>下一頁 最后一頁</font>"
End If
%></td>
<td height="25" >GOTO頁數:
<%Response.Write "<input type=text size=2 maxlength=4 name=page class=editbox1><input type=hidden name=judge value=1>" '顯示輸入頁數框并將page,judge參數傳遞下去%></td>
</form>
</tr>
<tr>
<td class="white" colspan="2" height="25" >記錄總數:<%=rs.recordCount%> 總頁數:<%=rs.PageCount%> 當前頁次:<%=page%> </td>
</tr>
</table> <table width="752" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><%else%></td>
<td colspan=9><table border="0" cellpadding="0" cellspacing="0" >
<td height="25" >對不起,還沒有記錄!</td>
</table></td>
<td><%end if%></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="inc/copyright.asp"-->
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -