📄 scoremodifydel.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/StudentConn.asp" -->
<!--#include file="CheckLogin.asp"-->
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_StudentConn_STRING
Recordset1.Source = "SELECT * FROM TestName ORDER BY id DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>学生成绩修改</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2600.0" Name=GENERATOR>
<link href="home.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<!--#include file="Top.asp"-->
<TABLE cellSpacing=0 cellPadding=0 width=750 align=center border=0>
<TBODY>
<TR>
<TD vAlign=top width=46 background=images/p_left_2.gif></TD>
<TD width=20> </TD>
<TD> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<tr>
<td height=30 width="20%"><img src="images/friendsite.GIF" width="19" height="19">
<a href="ScoreInputStep1.asp">录入学生成绩</a></td>
<td height=30 width="20%"><img src="images/friendsite.gif" width="19" height="19">
<a href="ScoreQueryStep1.asp">查询学生成绩</a></td>
<td height=30 width="20%"><img src="images/friendsite.gif" width="19" height="19">
<a href="ScoreModifyDel.asp">修改/删除学生成绩</a></td>
<td height=30 width="20%"><img src="images/friendsite.gif" width="19" height="19">
<a href="ScoreOrder.asp">计算总分与排名</a></td>
<td height=30 width="20%"><img src="images/friendsite.gif" width="19" height="19"><a href="TargetManage.asp">目标分管理</a></td>
</tr>
</TABLE>
<table cellspacing=0 cellpadding=0 width="100%" border=0>
<br>
<br>
<tbody>
<tr>
<td valign=top width="120" align="center">
<p><font size="4"><b>修<br>
改<br>
/<br>
删<br>
除<br>
学<br>
生<br>
成<br>
绩</b></font></p>
</td>
<td width="504">
<form Name="form1" action="ScoreQuery2.asp" method="post">
<b><font color="#0066cc">请先查询要修改或删除的记录:</font></b><br>
<br>
<table border="0" cellpadding="5" cellspacing="0">
<tr>
<td align="right" nowrap>请选择考试：</td>
<td colspan="2"> <select Name="SheetName">
<%
While (NOT Recordset1.EOF)
%>
<option value="<%=(Recordset1.Fields.Item("SheetName").Value)%>" selected ><%=(Recordset1.Fields.Item("TestName").Value)%></option>
<%
Recordset1.MoveNext()
Wend
If (Recordset1.CursorType > 0) Then
Recordset1.MoveFirst
Else
Recordset1.Requery
End If
%>
</select> </td>
</tr>
<tr>
<td align="right" nowrap>请输入学号：</td>
<td width="160"> <input Name="StudentNum" type="text" id="StudentNum" size="18" maxlength="8"></td>
<td rowspan="3"><b><font color="#0066cc">注：</font></b><br>
1 、若输入了学号，则优先按学号进行查询。 <br> <font color="#FF0000">2、支持模糊查询！</font><br>
例如：<br> 在学号查询框中输入2001，则查询结果为学号中包含“2001”的学生</td>
</tr>
<tr>
<td align="right" nowrap>请选择班级：</td>
<td nowrap> <select name="Grade"> <option value="0" selected>高一级</option> <option value="1">高二级</option> <option value="2">高三级</option> </select> <select name="ClassSelect">
<option value="01">1班</option>
<option value="02">2班</option>
<option value="03">3班</option>
<option value="04">4班</option>
<option value="05">5班</option>
<option value="06">6班</option>
<option value="07">7班</option>
<option value="08">8班</option>
<option value="09">9班</option>
<option value="10">10班</option>
<option value="11">11班</option>
<option value="12">12班</option>
<option value="All" selected>全级</option>
</select></td>
</tr>
<tr align="center">
<td colspan="2"><input name="Submit1" type="submit" id="Submit1" value="查询"></td>
</tr>
</table>
</form>
</td>
</tr>
</tbody>
</table>
</TD>
</TR>
</TBODY>
</TABLE>
<!--#include file="CopyRight.asp"-->
</BODY>
</HTML>
<%
Recordset1.Close()
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -