class_add_x.asp

综合测评．你自己看着办

<title>福州大学数学与计算机科学学院综合测评分管理系统</title><%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_0.asp" -->
<!--#include file="Connections/conn1.asp" -->
<%

if(String(Request("adminname")) != "undefined"){ cmd1__adminname1 = String(Request("adminname"));}

if(String(Request("adminpsd")) != "undefined"){ cmd1__adminpsd1 = String(Request("adminpsd"));}

if(String(Request("power")) != "undefined"){ cmd1__power1 = String(Request("power"));}

if(String(Request("classid")) != "undefined"){ cmd1__classid1 = String(Request("classid"));}

if(String(Request("truename")) != "undefined"){ cmd1__truename1 = String(Request("truename"));}

if(String(Request("classname")) != "undefined"){ cmd2__classname1 = String(Request("classname"));}

var rs1 = Server.CreateObject("ADODB.Recordset");
rs1.ActiveConnection = MM_conn1_STRING;
rs1.Source = "SELECT adminname FROM admin WHERE adminname='"+cmd1__adminname1+"'";
rs1.CursorType = 0;
rs1.CursorLocation = 2;
rs1.LockType = 1;
rs1.Open();
if(!rs1.EOF||!rs1.BOF)
   {Response.Write("<script language='javascript'>window.alert('管理员帐号已被注册，请换别的帐号！');location=('allclass_list.asp');</script>");
    Response.End();
	}
if(rs1.EOF&&rs1.BOF)
{	
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM_conn1_STRING;
rs.Source = "SELECT classname FROM class WHERE classname='"+cmd2__classname1+"'";
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
if(!rs.EOF||!rs.BOF)
   {Response.Write("<script language='javascript'>window.alert('该班已存在');location=('allclass_list.asp');</script>");
    Response.End();
	}
if(rs.EOF&&rs.BOF)
{
var cmd2 = Server.CreateObject("ADODB.Command");
cmd2.ActiveConnection = MM_conn1_STRING;
cmd2.CommandText = "INSERT INTO class (classid,classname)  VALUES ('"+ cmd1__classid1 + "','"+ cmd2__classname1 + "' ) ";
cmd2.CommandType = 1;
cmd2.CommandTimeout = 0;
cmd2.Prepared = true;
cmd2.Execute();
cmd2.CommandText = "INSERT INTO admin (adminname, adminpsd, power, classid, truename)  VALUES ('"+ cmd1__adminname1 + "','"+ cmd1__adminpsd1 + "','"+ cmd1__power1 + "','"+ cmd1__classid1 + "','"+ cmd1__truename1 + "') ";
cmd2.CommandType = 1;
cmd2.CommandTimeout = 0;
cmd2.Prepared = true;
cmd2.Execute();
Response.Write("<script language='javascript'>window.alert('添加成功');location=('allclass_list.asp');</script>");
}
rs.Close();
}
rs1.Close
%>