add_class1.asp

来自「网上学生管理信息系统,能够方便高校老师管理学生的信息,同时也便于学生网上查询」· ASP 代码 · 共 36 行

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

<%
dim stclass,class_number
stclass=trim(request("stclass"))
class_number=trim(request("class_number"))
if stclass="" then
	response.write "不能为空"
	response.end
end if

set rs=server.createobject("adodb.recordset")
sql="select * from class where stclass='"&stclass&"'"
rs.open sql,conn,1,3
%>

<%
if not rs.eof then
	response.write "该班级已存在"
	response.end
else
	rs.addnew
	rs("stclass")=stclass
	rs("class_number")=class_number
	rs.update
	rs.close
	set rs=nothing
	response.redirect "add_class.asp"
end if
%>