del_history.asp

来自「一个java源程序用于气泡法的java」· ASP 代码 · 共 18 行

<!--#include file="include.asp"-->
<%
 if not session("log") then response.redirect "login.asp"
 user=trim(request("user"))

 now_date=now()

 if trim(request("all"))="y" then
  sql="delete cnt_history where user01='"&user&"'"
 else
  sql="delete cnt_history where datediff(""d"",date01,'"&now_date&"')>=7 and user01='"&user&"'"
 end if

 conn.execute(sql)

 response.write "<br> 历史记录已经删除！"
 response.end
%>