smallclassadd.asp

一个不错的代码 一个不错的代码 一个不错的代码

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

function changechr(str) 
    changechr=replace(replace(replace(replace(str,"<","&lt;"),">","&gt;"),chr(13),"<br>")," "," ") 
    changechr=replace(changechr,"'","‘")
    changechr=replace(changechr,mid(" "" ",2,1),"&quot;")
end function

dim typename
dim howmany
BigClassName=request.form("bigclassName")
typename=changechr(trim(request.form("type")))
howmany=request.form("howmany")

If typename="" Then
response.write "不能为空！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
response.end
end if

set rs=server.createobject("adodb.recordset")
sql="select * from smallclass"
rs.open sql,conn,3,3
do while not rs.eof
if rs("SmallClassName")=typename then
response.write "已经存在这个SmallClassName名称！请<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 bigclassname='" & bigclassname & "'"
rs.open sql,conn,1,1
bigclassid=rs("bigclassid")
rs.close
set rs=nothing

Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from smallclass"
rs.open sql,conn,1,3
rs.addnew
rs("SmallClassName")=typename
rs("SmallClassID")=howmany+1
rs("BigClassName")=BigClassName
rs("BigClassID")=BigClassID
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "SmallClass.asp"
%>