📄 scorechastuok.asp
字号:
<!--#include file="conn.asp"-->
<%
studentname=request.form("studentname")
xueqi=request.form("xueqi")
classno=request.form("classno")
Session.Contents("classno")=classno
if classno="--选择班级--" then
response.write "<script language='javascript'>"
response.write "alert('选择班级');"
response.write "history.back(1);"
response.write "</script>"
response.end
end if
if studentname="" then
response.write "<script language='javascript'>"
response.write "alert('请输入学生名');"
response.write "history.back(1);"
response.write "</script>"
response.end
end if
%>
<html>
<head>
<title>个人成绩打印</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000" background="imags/033.gif">
<p align="center"><b>个 人 成 绩 情 况</b></p>
<p align="center"><font color="#333366"><%=classno%></font>
<%=xueqi%></p>
<div align="center">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="46%" id="AutoNumber1" height="339">
<tr>
<td width="24%" height="339" valign="top">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-width:0; border-right-width:0; " bordercolor="#111111" width="170" id="AutoNumber2" height="160">
<tr>
<td width="168" height="24" style="border-left:medium none #111111; border-right:medium none #111111; 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:medium none #111111; border-right:medium none #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="96" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; "></td>
</tr>
<tr>
<td width="168" valign="top" height="24" style="border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium; border-top-style:solid; border-top-width:1; border-bottom-style:solid; border-bottom-width:1">
<p align="center"><span lang="zh-cn">总分</span></td>
</tr>
</table>
</td>
<td width="76%" height="339" valign="top">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-left-width:0; border-right-width:0" bordercolor="#111111" width="99%" id="AutoNumber3" height="297">
<tr>
<%
set rs=server.createobject("adodb.recordset")
sql="Select * from 成绩 where studentname='"&studentname&"'"
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="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<p align="center">
<%=rs("studentname")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson1")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson2")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson3")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson4")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson5")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson6")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson7")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson8")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson9")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson10")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson11")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("lesson12")%></td>
</tr>
<tr>
<td width="100%" align="center" height="24" style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium">
<%=rs("zongfen")%></td>
</tr>
</table>
</div>
</div>
<p align="center"><b><font size="4" color="#CC6600"><a href="scorechaxun.asp">
<img src="imags/041.gif" border="0"></a></font></b></p>
</body>
<% rs.close
set rs=nothing
set conn=nothing
%></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -