【www.gdgbn.com--excel】

批量删除数据方法一

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("删除失败");网页特效: history.back();</script>")
end if
conn.close
set conn=nothing

方法二 使用了sql in

<%
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
%>

上面的二个批量删除实例代码，利用in的效益更高，也简单一些，用遍历的感觉代码多了一些。

本文来源：http://www.gdgbn.com/bangongshuma/27242/