myclass_user_del.asp

c++builder开发系统实现了成绩查寻

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_1.asp" -->
<!--#include file="Connections/conn1.asp" -->
<% 
Response.Write("<script language='javascript'>if(confirm('真的要删除该学生吗?')==true) {} else {window.alert('您没有删除该学生！');history.go(-1);}</script>")
%>
<%
if(String(Request("userid")) != "undefined"){ Command1__userid1 = String(Request("userid"));}
%>
<%
var Command1 = Server.CreateObject("ADODB.Command");
Command1.ActiveConnection = MM_conn1_STRING;
Command1.CommandText = "DELETE FROM user  WHERE userid ="+ Command1__userid1 + "";
Command1.CommandType = 1;
Command1.CommandTimeout = 0;
Command1.Prepared = true;
Command1.Execute();
var Command2 = Server.CreateObject("ADODB.Command");
Command2.ActiveConnection = MM_conn1_STRING;
Command2.CommandText = "DELETE FROM score  WHERE userid ="+ Command1__userid1+ "";
Command2.CommandType = 1;
Command2.CommandTimeout = 0;
Command2.Prepared = true;
Command2.Execute();
{Response.Write("<script language='javascript'>window.alert('已成功删除！');location=('myclass_user_list.asp');</script>");
 Response.End();
}
%>