📄 scoreupdate.asp
字号:
<!--#include file="conn.asp"-->
<%
id=request("id")
classno=Session.Contents("classno")
Session.Contents("id")=id
%>
<html>
<head>
<title>修改成绩</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="imags/bg.jpg">
<p><font color="#660000" size="6" face="隶书"><b><span lang="zh-cn">修改成绩</span></b></font></p>
<p align="center"><font color="#333366"><%=classno%></font>
<%=xueqi%></p>
<form name="form1" method="post" action="save_scoreupdate.asp">
<div align="center">
<table width="318" border="1" cellpadding="0" cellspacing="0">
<tr>
</tr>
</table>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="46%" id="AutoNumber1" height="149">
<tr>
<td width="24%" height="149" valign="top">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-width:0; border-right-width:0; border-bottom-width:0" bordercolor="#111111" width="170" id="AutoNumber2" height="78">
<tr>
<td width="168" height="23" style="border-left-color: #111111; border-left-width: 1; border-right-color: #111111; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1">
<p align="center">学科<tr><%
set rs=server.createobject("adodb.recordset")
sql="Select * from 上课 where classno='"&classno&"' order by id desc "
rs.open sql,conn,1,1
do while not rs.eof
%>
<td width="168" height="24" style="border-left-color: #111111; border-right-color: #111111; border-top-style: solid; border-top-width: 1; border-bottom-style: solid; border-bottom-width: 1">
<p align="center"><font size="2"><%=rs("lessonname")%></td>
</tr>
<%rs.movenext
i=i+1
loop
%>
</td>
</tr>
<tr>
<td width="168" valign="top" height="17" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-bottom-style: none; border-bottom-width: medium"></td>
</tr>
<tr>
<td width="168" valign="top" height="16" style="border-style: none; border-width: medium"></td>
</tr>
</table>
</td>
<td width="76%" height="149" valign="top">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="99%" id="AutoNumber3" height="261">
<tr>
<%set rs=server.createobject("adodb.recordset")
sql="Select * from 成绩 where id="&id
rs.open sql,conn,1,1
if rs.eof then
response.write("<script language='javascript'>")
response.write("alert('姓名ID出现错误!');")
response.write("history.go(-1);")
response.write("</Script>")
response.end
end if%>
<td width="100%" height="23">
<p align="center">
<%=rs("studentname")%>的成绩</td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson1" size="7" value="<%=rs("lesson1")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson2" size="7" value="<%=rs("lesson2")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson3" size="7" value="<%=rs("lesson3")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson4" size="7" value="<%=rs("lesson4")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson5" size="7" value="<%=rs("lesson5")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson6" size="7" value="<%=rs("lesson6")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson7" size="7" value="<%=rs("lesson7")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson8" size="7" value="<%=rs("lesson8")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson9" size="7" value="<%=rs("lesson9")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson10" size="7" value="<%=rs("lesson10")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson11" size="7" value="<%=rs("lesson11")%>"></td>
</tr>
<tr>
<td width="100%" align="center" height="19">
<input type="text" name="lesson12" size="7" value="<%=rs("lesson12")%>"></td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<p align="center">
<input type="submit" name="Submit" value="录入"></p>
</div>
</form>
<div align="center">
<center>
<p> </p>
</center>
</div>
<div align="center"></div>
<p align="center"><font color="#330000"><a href="scoreadd2.asp"><img src="imags/0000005.gif" width="137" height="30" border="0"></a></font></p>
<div align="center"></div>
<p align="center"><font color="#330000"></font></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -