adddepartok.asp

来自「学生管理功能: 1.添加单个成绩 2.批量添加成绩 3.通过搜索并修改与删除」· ASP 代码 · 共 23 行

<!--#include file="a25175_conn.asp"-->
<%
	dim depart,showID
	depart=trim(request.Form("depart"))
	showID=trim(request.Form("ShowID"))

	if depart="" then
	response.write"<script>alert('输入院系名称呀！');location='adddepart.asp'</script>"	
	'防止非法的登陆
   		else
  	            strsql="select * from department where SHOWID="&showid
  	            set rs=db.execute(strsql)
   			 	if not rs.eof then
   			 	response.write"<script>alert('已经有此显示顺序的院系了，请更换显示顺序！');location='adddepart.asp'</script>"
   			 	response.End()
    			end if
				'编号不能相同
				
	strsql="insert into department(department,SHOWID) values('"&depart&"',"&showID&")"
	db.execute(strsql)
	response.write"<script>alert('添加院系成功！');location='adddepart.asp'</script>"	
	end if
%>