myclass_score_toupdata.asp

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

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_1.asp" -->
<!--#include file="Connections/conn1.asp" -->
<%

if(String(Request("userno")) != "undefined"){ Command1__userno1 = String(Request("userno"));}

if(String(Request("score")) != "undefined"){ Command1__score = String(Request("score")); if(Command1__score=="") Command1__score=null;}

if(String(Request("bscore")) != "undefined"){ Command1__bscore = String(Request("bscore"));}

if(String(Request("month")) != "undefined"){ Command1__month = String(Request("month"));}

if(String(Request("bmonth")) != "undefined"){ Command1__bmonth = String(Request("bmonth"));}

%>
<%
var Command1 = Server.CreateObject("ADODB.Command");
Command1.ActiveConnection = MM_conn1_STRING;
Command1.CommandText = "UPDATE score SET "+ Command1__month + "="+ Command1__score + ","+ Command1__bmonth + "='"+ Command1__bscore + "' WHERE userno ='"+ Command1__userno1 + "'";
Command1.CommandType = 1;
Command1.CommandTimeout = 0;
Command1.Prepared = true;
Command1.Execute();
Response.Write("<script language='javascript'>window.alert('修改/添加成功！');location=('myclass_score_view.asp');</script>");
Response.End();
%>