add_teacher1.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 teacher_name,teacher_number,teacher_zc
teacher_name=trim(request("teacher_name"))
teacher_number=trim(request("teacher_number"))
teacher_zc=trim(request("teacher_zc"))

if teacher_name="" then
	response.write "任课教师名称不能为空"
	response.end
	else if teacher_number="" then
	         response.write "任课教师工号不能为空"
	         response.end
	         else if teacher_zc ="" then
	                  response.write "任课教师职称不能为空"
	                  response.end 
	         end if
	end if
end if

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

<%
if not rs.eof then
	response.write "该任课教师信息已存在"
	response.end
else
	rs.addnew
	rs("teacher_name")=teacher_name
	rs("teacher_number")=teacher_number
	rs("teacher_zc")=teacher_zc
	rs.update
	rs.close
	set rs=nothing
	response.redirect "add_teacher.asp"
end if
%>