📄 del.asp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>数据删除页</title>
<style type="text/css">
<!--
.STYLE1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<%
set conn=server.CreateObject("adodb.connection")
DBPath = Server.MapPath("db1.mdb")
conn.open "provider=microsoft.jet.oledb.4.0; data source="&DBpath
act=request.QueryString("act")
if act="del" then '删除
id=request.QueryString("id")
sql="delete from info where id="&id
conn.execute(sql)
response.Redirect("del.asp")
end if
exec="select * from info"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<table width="350" border="0" cellpadding="5" cellspacing="1" bgcolor="#D6E0EF">
<tr>
<td bgcolor="#698CC3"><div align="center"><span class="STYLE1">编号</span></div></td>
<td bgcolor="#698CC3"><div align="center"><span class="STYLE1">姓名</span></div></td>
<td bgcolor="#698CC3"><div align="center"><span class="STYLE1">地址</span></div></td>
<td bgcolor="#698CC3"> </td>
<td bgcolor="#698CC3"> </td>
</tr>
<%
rs.PageSize=3
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
rs.AbsolutePage=page
for i=1 to rs.PageSize
if rs.EOF then
exit for
end if
%>
<tr>
<td width="46" bgcolor="#FFFFFF"><%=rs("id")%></td>
<td width="86" bgcolor="#FFFFFF"><%=rs("name")%></td>
<td width="92" bgcolor="#FFFFFF"><%=rs("addr")%></td>
<td width="34" bgcolor="#FFFFFF"><a href='?act=del&id=<%=rs("id")%>' onclick='javascript: return confirm("你确定要删除吗? ");'>删除</a></td>
<td width="36" bgcolor="#FFFFFF"><a href="edit.asp?id=<%=rs("id")%>">修改</a></td>
</tr>
<%
rs.movenext
next
%>
</table>
<table width="350" border="0" cellpadding="5" >
<tr>
<td align="right">
<%if page=1 and not page=pagecount then%>
第<%=page%>页
<%for i=1 to pagecount%>
<a href="?page=<%=i%>"><%=i%></a>
<%next%>
<a href="?page=<%=page+1%>">下页</a>
<%elseif page=pagecount and not page=1 then%>
第<%=page%>页
<%for i=1 to pagecount%>
<a href="?page=<%=i%>"><%=i%></a>
<%next%>
<a href="?page=<%=page-1%>">上页</a>
<%elseif page<1 then%>没有任何记录！
<%elseif page>pagecount then%>没有任何记录！
<%elseif page=1 and page=pagecount then%>
<%else%>
第<%=page%>页
<%for i=1 to pagecount%>
<a href="?page=<%=i%>"><%=i%></a>
<%next%>
<a href="?page=<%=page-1%>">上页</a>
<a href="?page=<%=page+1%>">下页</a> </div>
<%end if%>
</td></tr></table>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -