方法一:- id=request.form("checkbox")
- id=Split(id,",")
- shu=0
- for i=0 to UBound(id)
- sql="select * from jiang_fname where id="&id(i)
- set rs=conn.execute(sql)
- if not rs.eof then
- delete_file(rs("fname"))
- end if
- rs.close
- set rs=nothing
- sql="delete from jiang_fname where id="&id(i)
- conn.execute sql,shu1
- shu=shu+1
- next
- if shu>0 then
- response.Write("<script>alert('删除成功');location.href='"&url&"';</script>")
- else
- response.write("<Script>alert('删除失败');javascript: history.back();</script>")
- end if
- conn.close
- set conn=nothing
复制代码
方法二:巧用in关键字实现数据的批量删除
managenews.asp
delnews.asp文件- <!--#include file="conn.asp"-->
- <%
- arrdel=Request("id")
- 'Response.Write arrdel
- sql="delete from news where id in ("&arrdel&")"
- 'Response.Write sql
- conn.Execute sql
- set conn=nothing
- response.write"<SCRIPT language=JavaScript>alert('删除成功!');"
- response.write"javascript: history.go(-1)</SCRIPT>"
- response.end
- %>
复制代码 |