📄 tjlist.asp
字号:
<!--#include file="conn.asp"-->
<%
class1=request.form("class1")
xueqi=request.form("xueqi")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from c1 where classname='"&class1&"' and xueqi='"&xueqi&"' ORDER by cj"
rs.Open sql,conn,3,3
%>
<!--#include file="top.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css">
<title>理学院成绩查询系统-学生列成绩表</title>
<style type="text/css">
<!--
.style1 {color: #0000FF}
.style2 {color: green}
-->
</style>
</head>
<body leftmargin="0" Topmargin="0" marginwidth="0" marginheight="0" background="images/greystrip.gIf">
<table width="760" border="0" cellspacing="0" cellpadding="0">
<tr><td><div align="right"><a href="manage.asp"><font color="red">返回管理首页</font></a> </div></td></tr>
</table>
<%if not rs.eof then%>
<table width="760" border="0" cellspacing="0" cellpadding="0" bgcolor="#316395" vspace="0" hspace="0" bordercolor="#316395" bordercolordark="#FFFFFF" bordercolorlight="#316395" background="images/titbg.gIf" height="26" align="center">
<tr>
<td height="25"><div align="center"><a align="center">--<%=rs("classname")%>班 <%=rs("xueqi")%> 学生成绩列表--</a></div></td>
</tr>
</table>
<% do while not rs.eof %>
<table width="760" border="0" cellspacing="0" cellpadding="0" vspace="0" hspace="0" bordercolordark="#FFFFFF" bordercolorlight="#316395" height="26" align="center">
<tr>
<td height="25"><font color=red>姓名:<%=rs("studentname")%></font></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td width="70"><div align="center" class="style1">学 号</div></td>
<td width="69"><div align="center" class="style1"><%=rs("c1")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c2")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c3")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c4")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c5")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c6")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c7")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c8")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c9")%></div></td>
<td width="69"><div align="center" class="style1"><%=rs("c10")%></div></td>
</tr>
</table>
<table width="760" border="0" align="center">
<tr>
<td width="760"></td></tr>
</table>
<table width="760" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td width="70"><div align="center"><font color=green><%=rs("cj")%></font></div></td>
<td width="69"><div align="center"><%=rs("j1")%></div></td>
<td width="69"><div align="center"><%=rs("j2")%></div></td>
<td width="69"><div align="center"><%=rs("j3")%></div></td>
<td width="69"><div align="center"><%=rs("j4")%></div></td>
<td width="69"><div align="center"><%=rs("j5")%></div></td>
<td width="69"><div align="center"><%=rs("j6")%></div></td>
<td width="69"><div align="center"><%=rs("j7")%></div></td>
<td width="69"><div align="center"><%=rs("j8")%></div></td>
<td width="69"><div align="center"><%=rs("j9")%></div></td>
<td width="69"><div align="center"><%=rs("j10")%></div></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" vspace="0" hspace="0" bordercolordark="#FFFFFF" bordercolorlight="#316395" height="26" align="center">
<tr>
<td height="25" height="100%"><div align="center">----------------------------------------------------------------------------------------------------------------------------</div></td>
</tr>
</table>
<% i=i+0
rs.movenext
if i>=rs.PageSize then exit do
loop
rs.close
set rs=nothing
conn.close
set conn=nothing %>
<%else
response.write "对不起,没有相关信息"
end if
%>
</body>
</html><!--#include file="bottom.asp"-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -