addclassok.asp

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

<!--#include file="a25175_conn.asp"-->
<%
	dim depart
	depart=trim(request.Form("depart"))
	class1=trim(request.Form("class1"))
    if depart="" or class1="" then
	response.write"<script>alert('输入院系名称和班级名称！');location='addclass.asp'</script>"	
	'防止非法的登陆
    else
    strsql="select * from department where department='"&depart&"'"
  	set rs=db.execute(strsql)
	departID=rs("id")
				
	strsql="insert into class(classname,department,departID) values('"&class1&"','"&depart&"',"&departID&")"
	db.execute(strsql)
	response.write"<script>alert('添加"&class1&"班级成功！');location='addclass.asp?Department="&depart&"'</script>"	
	end if
%>