bigclasseditok.asp

来自「这是一个学生毕业时做的教务系统」· ASP 代码 · 共 66 行

<!--#INCLUDE FILE="Conn.asp" -->
<%
IF Session("KEY")<>"super"THEN
response.redirect "login.asp"
response.end
END IF

dim typename
dim ID
ID=request("ID")
typename=request("typename")
if typename="" then
response.write "不能为空！"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from BigClass"
rs.open sql,conn,3,3
do while not rs.eof
if rs("BigClassName")=typename then
response.write "已经存在这个分类名称或没有做任何改动！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
response.end
end if
rs.movenext
loop
rs.close
set rs=nothing

'修改大类库
set rs=server.createobject("adodb.recordset")
sql="select * from BigClass where ID="&ID
rs.open sql,conn,3,3
typen=rs("BigClassName")
rs("BigClassName")=typename
rs.update
rs.close
set rs=nothing

'修改小类库
set rs=server.createobject("adodb.recordset")
sql="select * from SmallClass where BigClassName='"&typen&"'"
rs.open sql,conn,3,3
do while not rs.eof
rs("BigClassName")=typename
rs.update
rs.movenext
loop
rs.close
set rs=nothing

'修改新闻库
set rs=server.createobject("adodb.recordset")
sql="select * from news where BigClassName='"&typen&"'"
rs.open sql,conn,3,3
do while not rs.eof
rs("BigClassName")=typename
rs.update
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing

response.redirect "bigClass.asp"
%>