exscore_1_updata.asp

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

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_0.asp" -->
<!--#include file="Connections/conn1.asp" -->
<%
var x=Request("term");
var y="ex1";  if(x=="上半年") {y="ex1";} if(x=="下半年") {y="ex2";}
if(String(Request("userno")) != "undefined"){ cm__userno1 = String(Request("userno"));}
if(String(Request("score")) != "undefined"){ cm__score1 = String(Request("score"));}
%>
<%
var cm = Server.CreateObject("ADODB.Command");
cm.ActiveConnection = MM_conn1_STRING;
cm.CommandText = "UPDATE score  SET "+y+"='"+ cm__score1.replace(/'/g, "''") + "'  WHERE userno ='"+ cm__userno1.replace(/'/g, "''") + "' ";
cm.CommandType = 1;
cm.CommandTimeout = 0;
cm.Prepared = true;
cm.Execute();
Response.Write("<script language='javascript'>window.alert('成功插入'); location=('comescore.asp');</script>")
Response.End();
%>