class_del.asp

来自「综合测评．你自己看着办」· ASP 代码 · 共 45 行

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_0.asp" -->
<!--#include file="Connections/conn1.asp" -->
<% 
Response.Write("<script language='javascript'>if(confirm('真的要删除该班吗?请慎重！')==true) {} else {window.alert('您没有删除该班！');history.go(-1);}</script>")
%>
<%
if(String(Request("classid")) != "undefined"){ Command1__classid1 = String(Request("classid"));}
%>
<%
var Command1 = Server.CreateObject("ADODB.Command");
Command1.ActiveConnection = MM_conn1_STRING;
 {
  Command1.CommandText = "DELETE FROM admin  WHERE classid ="+ Command1__classid1 + "";
  Command1.CommandType = 1;
  Command1.CommandTimeout = 0;
  Command1.Prepared = true;
  Command1.Execute();
  }
 {
   Command1.CommandText = "DELETE FROM class  WHERE classid ="+ Command1__classid1+ "";
   Command1.CommandType = 1;
   Command1.CommandTimeout = 0;
   Command1.Prepared = true;
   Command1.Execute();
  }
  
 {Command1.CommandText = "DELETE FROM user WHERE classid ="+ Command1__classid1+ "";
  Command1.CommandType = 1;
  Command1.CommandTimeout = 0;
  Command1.Prepared = true;
  Command1.Execute();
 }
 
 {Command1.CommandText = "DELETE FROM score WHERE classid ="+ Command1__classid1+ "";
  Command1.CommandType = 1;
  Command1.CommandTimeout = 0;
  Command1.Prepared = true;
  Command1.Execute();
 }

{Response.Write("<script language='javascript'>window.alert('已成功删除！');location=('allclass_list.asp');</script>");
 Response.End();
}
%>