delete_ach.asp

一个学生管理系统 ASP+ACCE

<!--#include file="conn.asp"-->
<%
if session("admin")="" then
	response.write "<script>alert('您无此权限');document.location.href='index.asp';</script>"
	response.end
end if
%>

<%
dim id,user_number,ach,testno,user_class
id=trim(request("id"))

set rs=server.createobject("adodb.recordset")
sql="select * from ach where id="& id
rs.open sql,conn,1,3
user_number=rs("user_number")
ach=rs("ach")
testno=rs("testno")
user_class=rs("user_class")
%>

<%
rs.delete
rs.close
set rs=nothing
%>

<%
set rs1=server.createobject("adodb.recordset")
sql1="select * from total_ach where user_number='"&user_number&"' and testno='"&testno&"' and user_class='"&user_class&"'"
rs1.open sql1,conn,1,3
%>
<%
rs1("total_ach")=rs1("total_ach")-ach
if rs1("total_ach")=0 then
	rs1.delete
end if
rs1.update
rs1.close
response.write "<script language='javascript'>window.confirm('成绩已经成功的从成绩表和总分表中删除！')</script>"
response.write "<script language='javascript'>parent.window.history.go(-1);</script>"
%>