delete_data.asp

来自「不错的ASP整站源代码。在IIS环境下运行都没有问题」· ASP 代码 · 共 20 行

<!--#include file="security.asp"-->

<%
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("tu.asp")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
i=0
sql="select * from data" 
rs.open sql,conn,3,2
do while now()-rs("addtime")>30 and not rs.eof
response.write rs("addtime")
response.write "<br>"
rs.delete
i=i+1
rs.movenext
loop
rs.close
response.write i &"个贺卡已经删除！"
%>