📄 exscore_updata.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 rs__userno1 = "0";
if (String(Request("userno")) != "undefined" &&
String(Request("userno")) != "") {
rs__userno1 = String(Request("userno"));
}
%>
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM_conn1_STRING;
rs.Source ="SELECT "+y+" FROM score WHERE userno='"+ rs__userno1.replace(/'/g, "''") + "'";
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
var rs_numRows = 0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>福州大学数学与计算机科学学院综合测评分管理系统</title>
<style type="text/css">
<!--
body {
background-image: url(imag/bjx.jpg);
}
.style28 {font-size: 12px}
.style29 {color: #000000}
.style30 {font-size: 12px; color: #000000; }
.style31 {color: #CCCCCC}
-->
</style></head>
<body>
<script language="javascript">
function chk()
{
if(document.form.score.value=="")
{alert("成绩不能空");return false;}
return true;
}
</script>
<table width="714" height="528" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="89" height="13"></td>
<td width="713"><div align="center"><img src="imag/Top_logo.jpg" width="613" height="103"></div></td>
<td width="48"></td>
</tr>
<tr>
<td height="502"></td>
<td valign="top"><table width="570" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="850" height="395"><table width="666" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<th width="34" scope="col"> </th>
<th width="592" height="41" bgcolor="#FFFFFF" scope="col">
<form action="exscore_1_updata.asp" method="get" name="form" target="_self" id="form" onSubmit="return chk()">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#66FF66">
<th height="20" colspan="5" scope="col"><div align="left" class="style28 style29">
<div align="center" class="style29"><%=Request("term")%></div>
</div></th>
</tr>
<tr bgcolor="#CCCCCC">
<th width="13%" scope="row"><div align="center" class="style30">学号</div></th>
<td width="31%"><div align="center" class="style30"><%=Request("userno")%></div></td>
<td width="11%"><div align="center" class="style30">特加分</div></td>
<td width="17%"><div align="center" class="style30">
<input name="score" type="text" id="score2" value="<%=(rs.Fields.Item(y).Value)%>" size="8">
</div></td>
<td width="28%"><div align="center" class="style30">
<input name="提交" type="submit" value="提交">
<span class="style31">-</span>
<input name="button" type="reset" value="重置">
</div></td>
</tr>
</table><input name="userno" type="hidden" id="userno" value="<%=Request("userno")%>">
<input name="term" type="hidden" id="term" value="<%=Request("term")%>">
</form></th>
<th width="40" scope="col"></th>
</tr>
</table></td>
</tr>
</table></td>
<td></td>
</tr>
<tr>
<td height="13"></td>
<td><!--DWLayoutEmptyCell--> </td>
<td></td>
</tr>
</table>
</body>
</html>
<%
rs.Close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -