?? delete_all.asp
字號:
<%if session("password")<>"" then%>
<!--#include file="conn.asp" -->
<script language="JavaScript">
function test(){
if (document.form2.page.value=="" || isNaN(document.form2.page.value)) {
alert("輸入頁數必須為數值型");
document.form2.page.focus();
return false;
}
return true;
}
</script>
<script>
function del() //用于判斷記錄有沒有選中的函數
{
var flag=true;
var temp="";
var tmp;
if((document.form1.answer.length+"")=="undefined") {tmp=1}else{tmp=document.form1.answer.length}
if (tmp==1){
if (document.form1.answer.checked){
flag=false;
temp=document.form1.answer.value
}}else
{
for (i=0;i<document.form1.answer.length;i++) {
if (document.form1.answer[i].checked){
if (temp=="")
{
flag=false;
temp=document.form1.answer[i].value
}
else
{flag=false;
temp = temp +","+ document.form1.answer[i].value
}}}}
if (flag){ alert("對不起,你還沒有選擇!")}
else
{name=document.form1.name.value
if (confirm("確定要批量刪除?")){ window.location="delnews_all.asp?id=" + temp;}}
return !flag;
}
</script>
<script language=Javascript>
function checkall(all)//用于判斷全選記錄的函數
{
var a = document.getElementsByName("answer");
for (var i=0; i<a.length; i++) a[i].checked = all.checked;
}
</script>
<link href="css.css" rel="stylesheet" type="text/css">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><a href="index.asp">首頁</a> <a href="add.asp">添加試題</a> <a href="delete_all.asp">刪除試題</a> <a href="SEARCH.ASP">列出試題答案</a> <a href="change_password.asp">修改密碼</a> <a href="login.asp">登入</a> <a href="20050130_logout.asp">退出</a> <a href="http://www.25175.com">powered by 25175</a></td>
</tr>
</table>
<%
sql="select * from test order by id desc"
rs.open sql,conn,1,3
page = CLng(request("page")) '利用CLng函數把page值轉換為Long型
judge=request("judge")
judge2=request("judge2")
judge3=0
%>
<title>25175.com</title>
<link href="css.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
if not (rs.EOF or rs.BOF) then
rs.MoveFirst
rs.PageSize =20 '每頁顯示的條數
If page < 1 Then page = 1
If page > rs.PageCount Then page = rs.PageCount
rs.AbsolutePage = page
For ipage = 1 To rs.PageSize
%>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<form method="POST" id=form1 name=form1>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50" height="25"><%=rs("id")%></td>
<td width="190"><%=rs("question")%></td>
<td>
<div align="center">
<input type="checkbox" name="answer" value="<%=rs("id")%>" id="Checkbox1">
</div></td>
</tr>
<%
rs.MoveNext
If rs.EOF Then Exit For
Next
%>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" valign="top">
<div align="right">
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" bgcolor="#21B639"><div align="center"></div></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="3"><div align="center"></div></td>
</tr>
</table>
<input type="checkbox" name="chkall" value="on" onClick="checkall(this)" id="Checkbox2">選中所有的顯示信息
<input type="button" name="btnDelete" value="刪除" onClick="del()" id="Button1">
</div></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25" bgcolor="#F7F7F7">
<form onSubmit="return test();" method="get" action="delete_all.asp" id=form2 name=form2>
頁數:<%Response.Write "<input type=text size=2 maxlength=4 name=page class=editbox1><input type=hidden name=judge value=1>" '顯示輸入頁數框并將page,judge參數傳遞下去%>
<% If page = 1 Then
Response.Write "第一頁 上一頁 "
End If
If page <> 1 Then
Response.Write "<a href=delete_all.asp?page=1>第一頁</a> "
'Response.Write "<a href=delete_all.asp?page="&(page-1)&">上一頁</a> "
Response.Write "<a href=delete_all.asp?page="&(page-9)&">前十頁</a> "
End If
If page <> RS.PageCount Then
Response.Write "<a href=delete_all.asp?page="&(page)&">"&(page)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+1)&">"&(page+1)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+2)&">"&(page+2)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+3)&">"&(page+3)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+4)&">"&(page+4)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+5)&">"&(page+5)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+6)&">"&(page+6)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+7)&">"&(page+7)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+8)&">"&(page+8)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+9)&">"&(page+9)&"</a> "
Response.Write "<a href=delete_all.asp?page="&(page+10)&">后十頁</a> "
Response.Write "<a href=delete_all.asp?page="&RS.PageCount&">最后一頁</a> "
End If
If page = RS.PageCount Then
Response.Write "下一頁 最后一頁"
End If
%>
</form>
</td>
</tr>
<tr>
<td height="25">記錄總數:<%=rs.recordCount%> 總頁數:<%=rs.PageCount%> 當前頁次:<%=page%> </td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><%else%></td>
<td><table border="0" align=center cellpadding="0" cellspacing="0" >
<td >對不起,還沒有記錄!</td>
</table></td>
<td><%end if%></td>
</tr>
</table>
<%
else
Response.Redirect "20050130_loginagine.asp"
end if
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -