id=request.form("checkbox")
id=Split(id,",")
shu=0
for i=0 to UBound(id)
sql="select * from stu_info_book where user="&user(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 stu_info_book where user="&user(i)     
conn.execute sql,shu1
shu=shu+1
next   
if shu>0 then
response.Write("<script>alert('删除成功');location.href='student_mg';</script>")
else
response.write("<Script>alert('删除失败');javascript: history.back();</script>")
end if
conn.close
set conn=nothing

代码太复杂也不好，这样的好
id=request.form("checkbox") '得到要删除的id
sql="delete from stu_info_book where user in("&id&")" '删除语句
conn.execute(sql) '执行语句
response.Write("<script>alert('删除成功');location.href='student_mg';</script>")


2楼方法的确很好，一直以为要循环才行的 原来用in更方便。

都是可以的

曾经我用这个循环方法导致程序死机，后面就用一句in sql就解决了。