📄 editscorex.asp
字号:
<!--#include file ="connection.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加教师信息</title>
<style type="text/css">
<!--
.STYLE1 {
color: #FFFFFF;
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head>
<body bgcolor="#FBC2AD">
<div align=center>
<%
teacherno=session("user")
lb=session("lb")
if teacherno=""or lb<>"teacher" then
response.redirect"index.asp"
else
xueqi=request.Form("xueqi")
lessonno=request.Form("lessonno")
%>
<%
action=request("action")
if action="" then
%>
<table width="144" height="84">
<tr>
<td> </td>
</tr>
</table>
<form action="" method="post">
<table width="391" border="0" cellpadding="3" cellspacing="1" bordercolor="#000000" bgcolor="#000000" class="sft">
<tr>
<td height="30" colspan="4" bgcolor="#FF903C"><div align="center" class="STYLE1">选择班级
<input type="hidden" name="xueqi" value=<%=xueqi%>>
<input type="hidden" name="lessonno" value=<%=lessonno%>>
</div> </td>
</tr>
<tr>
<td width="48" height="30" bgcolor="#FF903C"><div align="center">年级：</div></td>
<td width="131" bgcolor="#FFFFFF"><select name="jino" size="1" id="jino" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
<option value="--选择年级--" selected>--选择年级--</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</select></td>
<td width="51" bgcolor="#FF903C"><div align="center">班级：</div></td>
<td width="132" height="30" bgcolor="#FFFFFF"><select name="banno" size="1" id="select" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" >
<option value="--选择班级--" selected>--选择班级--</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
</select></td>
</tr>
<tr>
<td height="20" colspan="4" bgcolor="#FFFFFF"><div align="center">
<div align="center">
<input type="submit" name="action" value="修改学生成绩" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
</div>
</table>
</form>
<%
else
banno=request.form("banno")
jino=request.form("jino")
xueqi=request.Form("xueqi")
lessonno=request.Form("lessonno")
'response.write "banno=" & banno
'response.write "jino=" & jino & "'" & xueqi & lessonno
if banno <> "--选择班级--" and jino<> "--选择年级--"then
if banno<>"" and jino <>"" then
sql = "select * from 学生 where jino='" & jino &"' and banno='"& banno &"'"
set rs=Server.Createobject("ADODB.RecordSet")
rs.Open sql,CN
if rs.Eof then
response.Write "该班级无此门课程！"
response.End()
else
sqlstr="select 成绩.*,学生.studentname from 成绩,学生 where 成绩.lessonno='" & lessonno & "' and 成绩.xueqi='" & xueqi &"' and 成绩.studentno=学生.studentno and 学生.jino='" & jino &"' and 学生.banno='" & banno &"'"
set rs1=Server.Createobject("ADODB.RecordSet")
rs1.Open sqlstr,CN
%>
<form action="editscorez.asp" method="post">
<table width="391" border="0" cellpadding="3" cellspacing="1" bordercolor="#000000" bgcolor="#000000" class="sft">
<tr>
<td height="30" colspan="2" bgcolor="#FF903C"><div align="center" class="STYLE1">修改学生成绩
<input type="hidden" name="xueqi" value=<%=xueqi%>>
<input type="hidden" name="lessonno" value=<%=lessonno%>>
</div> </td>
</tr>
<%
i=0
while not rs1.eof %>
<tr>
<td width="165" height="30" bgcolor="#FF903C"><div align="center"><%=rs1("studentname")%><input type="hidden" name="studentno<%=i%>" value=<%=rs1("studentno")%>></div> </td>
<td width="211" height="30" bgcolor="#FFFFFF"><input name="score<%=i%>" type="text" style="border-style: dotted; border-width: 0; background-color: #FCB4BC" size="20" value=<%=rs1("score")%>></td>
</tr>
<%
rs1.movenext
i=i+1
wend %>
<tr>
<td height="20" colspan="2" bgcolor="#FFFFFF"><div align="center">
<div align="center">
<input type="hidden" name="scount" value=<%=i%>>
<input type="submit" name="action" value="修改学生成绩" style="border-style: dotted; border-width: 0; background-color: #FCB4BC">
</div>
</table>
</form>
<p class=sft>
</div>
<% end if
end if
end if
%>
</body>
</html>
<%
end if
end if
'rs.close
'rs1.close
'rs2.close
CN.close
set rs=nothing
'set rs1=nothing
'set rs2=nothing
set CN=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -