scoreover.asp

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

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_0.asp"-->
<% var MM_paramName = ""; %>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

// create the list of parameters which should not be maintained
var MM_removeList = "&index=";
if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone="";

// add the URL parameters to the MM_keepURL string
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
  var nextItem = "&" + items.item().toLowerCase() + "=";
  if (MM_removeList.indexOf(nextItem) == -1) {
    MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
  }
}

// add the Form variables to the MM_keepForm string
for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
  var nextItem = "&" + items.item().toLowerCase() + "=";
  if (MM_removeList.indexOf(nextItem) == -1) {
    MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
  }
}

// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length > 0)  MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<style type="text/css">
<!--
.style1 {
	font-size: 14px;
	font-weight: bold;
	color: #000000;
}
-->
</style>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p><span class="style1"><A HREF="scoreover_list.asp?<%= Server.HTMLEncode(MM_keepURL) %>">[成绩列表]</A></span></p>
<p>&nbsp;</p>
<p>
      
  <!--#include file="Connections/conn1.asp" -->
  <%
  var x=Request("term");
  Response.Write("数据处理中..............");
  Response.Write("<br>");
  Response.Write("请稍等");
  Response.Write("<br>");
%>
  <%
if(x=="上半年")
{
var rss = Server.CreateObject("ADODB.Recordset");
rss.ActiveConnection = MM_conn1_STRING;
rss.Source ="SELECT userid,s2, s3, s4, s5, s6, ex1  FROM score  WHERE conform=1";
rss.CursorType = 0;
rss.CursorLocation = 2;
rss.LockType = 1;
rss.Open();
var cm = Server.CreateObject("ADODB.Command");
cm.ActiveConnection = MM_conn1_STRING;
var i=0;
while(!rss.EOF)
   {ad=(rss.Fields.Item("s2")+rss.Fields.Item("s3")+rss.Fields.Item("s4")+rss.Fields.Item("s5")+rss.Fields.Item("s6"))/5;
	total=ad+rss.Fields.Item("ex1").Value;
	id=rss.Fields.Item("userid").Value;
	cm.CommandText = "UPDATE score  SET adv1='"+ ad + "' ,total1='"+total + "' WHERE userid ="+id+ " ";
    cm.CommandType = 1;
    cm.CommandTimeout = 0;
    cm.Prepared = true;
    cm.Execute();
		rss.MoveNext();
		i++;
		}
Response.Write("共处理["+[i]+"]条数据");
Response.Write("<script language='javascript'>window.alert('成功生成成绩！');</script>")
}
if(x=="下半年")
{
var rss = Server.CreateObject("ADODB.Recordset");
rss.ActiveConnection = MM_conn1_STRING;
rss.Source ="SELECT userid,s9, s10, s11, s12, ex2  FROM score  WHERE conform=1";
rss.CursorType = 0;
rss.CursorLocation = 2;
rss.LockType = 1;
rss.Open();
var cm = Server.CreateObject("ADODB.Command");
cm.ActiveConnection = MM_conn1_STRING;
var i=0;
while(!rss.EOF)
   {ad=(rss.Fields.Item("s9")+rss.Fields.Item("s10")+rss.Fields.Item("s11")+rss.Fields.Item("s12"))/4;
	total=ad+rss.Fields.Item("ex2").Value;
	id=rss.Fields.Item("userid").Value;
	cm.CommandText = "UPDATE score  SET adv2='"+ ad + "' ,total2='"+total + "' WHERE userid ="+id+ " ";
    cm.CommandType = 1;
    cm.CommandTimeout = 0;
    cm.Prepared = true;
    cm.Execute();
		rss.MoveNext();
		i++;
		}
Response.Write("共处理["+[i]+"]条数据");
Response.Write("<script language='javascript'>window.alert('成功生成成绩！');</script>")
}
%>
  <%
rss.Close();
Response.End();
%>
</p>