class_updata_x.asp

综合测评．你自己看着办

<%@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("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+"'AND classid<>"+cmd1__classid1+"";
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+"'AND classid<>"+cmd1__classid1+"";
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 = "UPDATE  admin SET adminname='"+cmd1__adminname1+"',adminpsd='"+cmd1__adminpsd1+"',truename='"+cmd1__truename1+"' WHERE classid="+cmd1__classid1+"";
cmd2.CommandType = 1;
cmd2.CommandTimeout = 0;
cmd2.Prepared = true;
cmd2.Execute();
var cmd1 = Server.CreateObject("ADODB.Command");
cmd1.ActiveConnection = MM_conn1_STRING;
cmd1.CommandText = "UPDATE class  SET classname='"+cmd2__classname1+"' WHERE classid="+cmd1__classid1+"";
cmd1.CommandType = 1;
cmd1.CommandTimeout = 0;
cmd1.Prepared = true;
cmd1.Execute();
Response.Write("<script language='javascript'>window.alert('修改成功');location=('allclass_list.asp');</script>");
}
rs.Close();
}
%>