📄 myclass_score_updata.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="session_1.asp" -->
<!--#include file="Connections/conn1.asp" -->
<%
var rs__month1 = "19";
if (String(Request("month")) != "undefined" &&
String(Request("month")) != "") {
rs__month1 = String(Request("month"));
}
%>
<%
var rs__userno1 = "0";
if (String(Request("userno")) != "undefined" &&
String(Request("userno")) != "") {
rs__userno1 = String(Request("userno"));
var month=String(Request("month"));
var x=month.charAt(1)+month.charAt(2);
var y='b'+x;
var z='s'+x;
}
%>
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM_conn1_STRING;
rs.Source = "SELECT "+y+" ,"+z+" FROM score WHERE userno='"+ rs__userno1+ "' ";
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
%>
<!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);
}
.style18 {
font-style: italic;
font-size: 14px;
color: #FFFF66;
}
.style19 {color: #666666}
.style28 {font-size: 12px}
.style29 {color: #FF0000}
-->
</style></head>
<body>
<table width="700" height="514" 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="614" height="106"></div></td>
<td width="48"></td>
</tr>
<tr>
<td height="395"></td>
<td valign="top"><table width="570" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="850" height="395"><table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<th width="37" scope="col"> </th>
<th width="626" height="358" scope="col">
<form action="myclass_score_toupdata.asp" method="post" name="form" target="_self" id="form" onSubmit="return chk()">
<table width="550" height="42" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="#99FF66">
<th height="21" class="style28" scope="col"><div align="center" class="style28">月份 </div></th>
<th height="21" class="style28 style29" scope="col"><%Response.Write(x)%>月</th>
<th height="21" class="style28" scope="col"><div align="center" class="style28">
<div align="right">学号</div>
</div></th>
<th height="21" class="style28" scope="col"><%Response.Write(rs__userno1)%></th>
<th height="21" class="style28" scope="col"> </th>
</tr>
<tr bgcolor="#CCCCCC">
<th width="39" height="21" scope="col"><div align="center" class="style28">成绩</div></th>
<th width="56" scope="col"><input name="score" type="text" id="score" value="<%=rs.Fields.Item(z).Value%>" size="8"></th>
<th width="58" scope="col"><div align="center" class="style28">
<div align="right">备注</div>
</div></th>
<th width="355" scope="col"><input name="bscore" type="text" id="bscore" value="<%=rs.Fields.Item(y).Value%>" size="50"></th>
<th width="42" scope="col"><div align="left" class="style28">
<input name="提交" type="submit" value="确认">
</div></th>
</tr>
</table><input name="bmonth" type="hidden" id="bmonth" value="<%Response.Write(y)%>">
<input name="month" type="hidden" id="month" value="<%Response.Write(z)%>">
<input name="userno" type="hidden" id="userno" value="<%Response.Write(rs__userno1)%>">
</form></th>
<th width="37" scope="col"> </th>
</tr>
</table>
</td>
</tr>
</table></td>
<td></td>
</tr>
<tr>
<td height="13"></td>
<td></td>
<td></td>
</tr>
</table>
</body>
</html>
<%
rs.Close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -