tozero.asp

来自「c++builder开发系统实现了成绩查寻」· ASP 代码 · 共 49 行

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_0.asp"-->
<!--#include file="Connections/conn1.asp" -->
<%
var rs__adminname1 = "0";
if (String(Request("adminname")) != "undefined" && 
    String(Request("adminname")) != "") { 
  rs__adminname1 = String(Request("adminname"));
}
%>
<%
var rs__adminpsd1 = "1";
if (String(Request("adminpsd")) != "undefined" && 
    String(Request("adminpsd")) != "") { 
  rs__adminpsd1 = String(Request("adminpsd"));
}
%>
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM_conn1_STRING;
rs.Source = "SELECT rank  FROM admin  WHERE adminname='"+ rs__adminname1.replace(/'/g, "''") + "' AND adminpsd='"+ rs__adminpsd1.replace(/'/g, "''") + "' AND rank=1";
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
if(rs.EOF||rs.BOF)
{Response.Write("<script language='javascript'>window.alert('您输入的用户名或密码有误');history.go(-1);</script>")
 Response.End();}
if(!rs.EOF&&!rs.BOF)
{     {var pass=rs.Fields.Item("rank").Value}
      if(pass==1)
     {
 var cmd = Server.CreateObject("ADODB.Command");
cmd.ActiveConnection = MM_conn1_STRING;
cmd.CommandText = "UPDATE score  SET s2=null, b2='无', s3=null, b3='无', s4=null, b4='无',s5=null,b5='无', s6=null, b6='无', adv1=0, ex1=0, total1=0, s9=null, b9='无', s10=null, b10='无', s11=null, b11='无', s12=null, b12='无', adv2=0, ex2=0, total2=0  WHERE conform =1 ";
cmd.CommandType = 1;
cmd.CommandTimeout = 0;
cmd.Prepared = true;
cmd.Execute();
Response.Write("<script language='javascript'>window.alert('已成功清零！');history.go(-1);</script>")
Response.End();

     }
}
%>
<%
rs.Close();
%>