addschool.asp

来自「网络教学管理系统」· ASP 代码 · 共 30 行

<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
body {
	background-color: #B1DB99;
}
-->
</style><!--#include file = "inc/conn.asp" -->
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<%
	Dim strName 
	strName = trim(Request.Form("name"))
	Dim rs ,strSql 
	Set rs = Server.CreateObject("ADODB.Recordset")
	strSql = "SELECT * FROM School WHERE name = '"& strName &"'"
	rs.open strSql,conn,1,1
	If Not rs.EOF  Then
		Response.Write("<Br><Br>对不起，您不能添加该学院，因该学院已经存在！")
		Response.End
	End If
	rs.Close
	strSql = "INSERT INTO School (name) Values('"& strName &"')"
	rs.open strSql,conn,3,1
	Response.Write("<BR><BR><BR><Div align=center>添加成功！<Br><BR><a href=index_School.asp>返回</a></div>")
	
	
%>