add_subject1.asp

来自「managerc.zip」· ASP 代码 · 共 38 行

<!--#include file="conn.asp"-->
<%
if session("user")="" then
	response.write "您无此权限"
	response.end
end if

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

'------------------------------------------------------------------------------------
%>

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

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

<%
if not rs.eof then
	response.write "该考试科目已存在"
	response.end
else
	rs.addnew
	rs("subject")=subject
	rs.update
	rs.close
	set rs=nothing
	response.redirect "add_subject.asp"
end if
%>