博客展示了使用ASP进行数据库操作的代码，通过conn对象开启事务，执行了一系列delete语句，分别从supervisor、config等多个表中删除符合条件的数据，最后提交事务。
conn.BeginTrans
conn.execute("delete from supervisor where id="&id)
conn.execute("delete from config where uid='"&uid&"'")
conn.execute("delete from filterconfig where uid='"&uid&"'")
conn.execute("delete from ipconfig where uid='"&uid&"'")
conn.execute("delete from main where uid='"&uid&"'")
conn.execute("delete from reply where uid='"&uid&"'")
conn.execute("delete from stats where uid='"&uid&"'")
conn.CommitTrans
conn.execute("delete from supervisor where id="&id)
conn.execute("delete from config where uid='"&uid&"'")
conn.execute("delete from filterconfig where uid='"&uid&"'")
conn.execute("delete from ipconfig where uid='"&uid&"'")
conn.execute("delete from main where uid='"&uid&"'")
conn.execute("delete from reply where uid='"&uid&"'")
conn.execute("delete from stats where uid='"&uid&"'")
conn.CommitTrans
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
