termdel.asp

学生管理功能: 1.添加单个成绩 2.批量添加成绩 3.通过搜索并修改与删除

<!--#include file="a25175_conn.asp"-->
<%
dim id
id=trim(request("id"))
if id="" then
response.write"<script>alert('不要错误操作！');location='addTERM.asp'</script>"	
else

strsql="select * from TERM where id="&id
set rs=db.execute(strsql)
term=rs("term")

'--------------------------------------------------------------------------------------------

strsql="delete from TEACHERSCORE where Term='"&Term&"'"
db.execute(strsql)
strsql="delete from TEACHERNEW where Term='"&Term&"'"
db.execute(strsql)
strsql="delete from TEACHERCOURSE where Term='"&Term&"'"
db.execute(strsql)
'--------------------------------------------------------------------------------------------
''--------------------------删除此学期的课程和分数
strsql="delete from TERM where id="&id
db.execute(strsql)
'----------------------------------------学期删除
response.write"<script>alert('删除成功！');location='addTERM.asp'</script>"	
end if
%>