user_updata.asp

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

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_1.asp"-->
<!--#include file="Connections/conn1.asp" -->
<%
if(String(Request("username")) != "undefined"){ cmd1__username1 = String(Request("username"));}
if(String(Request("userno")) != "undefined"){ cmd1__userno1 = String(Request("userno"));}
if(String(Request("userid")) != "undefined"){ cmd1__userid1 = String(Request("userid"));}
var userno111 = String(Request("userno11"));

var rs1 = Server.CreateObject("ADODB.Recordset");
rs1.ActiveConnection = MM_conn1_STRING;
rs1.Source = "SELECT userno FROM user WHERE  userno='"+cmd1__userno1+"' AND userno<>'"+userno111+"'";
rs1.CursorType = 0;
rs1.CursorLocation = 2;
rs1.LockType = 1;
rs1.Open();
if(!rs1.EOF||!rs1.BOF)
   {Response.Write("<script language='javascript'>window.alert('该学号已存在！修改不成功！');history.go(-1);</script>");
    Response.End();
	}
if(rs1.EOF&&rs1.BOF)
{
var cmd2 = Server.CreateObject("ADODB.Command");
cmd2.ActiveConnection = MM_conn1_STRING;
cmd2.CommandText = "UPDATE  user SET userno='"+cmd1__userno1+"',username='"+cmd1__username1+"' WHERE userid="+cmd1__userid1+"";
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  score SET userno='"+ cmd1__userno1 + "' WHERE userid="+cmd1__userid1+"";
cmd1.CommandType = 1;
cmd1.CommandTimeout = 0;
cmd1.Prepared = true;
cmd1.Execute();
Response.Write("<script language='javascript'>window.alert('修改成功');location=('myclass_user_list.asp');</script>");
}
rs1.Close();
%>