exscore_toadd.asp

综合测评．你自己看着办

<%@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";}
var userno1=new Array();
var exx=new Array();

var cmd = Server.CreateObject("ADODB.Command");
cmd.ActiveConnection = MM_conn1_STRING;
var i=1;
var j=0;
for(i=1;i<=20;i++)
  {   userno1[i]=Request(i)
	  if(userno1[i]=="")
	  continue;
	  if(userno1[i]!="")
	  {exx[i]=Request("c"+i);
	   cmd.CommandText = "UPDATE score  SET "+y+"="+exx[i]+"  WHERE userno='"+userno1[i]+"' ";
       cmd.CommandType = 1;
       cmd.CommandTimeout = 0;
       cmd.Prepared = true;
       cmd.Execute();	  
	   j++;
	   }
  }
 Response.Write("成功插入["+j+"]条记录") ;
 Response.Write("<script language='javascript'>window.alert('成功插入'); location=('comescore.asp');</script>")
%>