📄 scoreadda11111.asp
字号:
<!--#include file="conn.asp"-->
<%
classno=Session.Contents("classno")
xueqi=Session.Contents("xueqi")
%>
<html>
<head>
<title>录入成绩1</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>录入成绩---</b></font><font color="#660000">先选择学生，再录入成绩。</font></p>
<p align="center"><font color="#333366"><%=classno%></font>
<%=xueqi%></p>
<form name="form1" method="post" action="save_scoreadda.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" valign="top" height="21" 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">
<%
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="left"><font face="宋体">◆</font><font size="2"><%=rs("lessonname")%></td>
<%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">
<tr>
<td width="100%">
<p align="center"> <select name="studentname" size="1">
<option value="--选择学生--" selected>--选择学生--</option>
<% set rs=server.createobject("ADODB.Recordset")
sql="select * from 学生 where classno='"&classno&"'"
rs.open sql,conn,1,1
do while not rs.eof
studentno=rs("studentno")
%>
<option value="<%=rs("studentname")%>"><%=rs("studentname")%></option>
<% rs.movenext
loop
%>
<%
Session.Contents("studentno")=studentno
%>
</select></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson1" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson2" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson3" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson4" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson5" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson6" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson7" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="20">
<input type="text" name="lesson8" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="10">
<input type="text" name="lesson9" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="10">
<input type="text" name="lesson10" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="10">
<input type="text" name="lesson11" size="7" value="0"></td>
</tr>
<tr>
<td width="100%" align="center" height="10">
<input type="text" name="lesson12" size="7" value="0"></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 + -