allscore.asp

晴和教务管理系统

<% if request.Cookies("jiaowu")("Lx") <> "学生" then response.redirect "/jw/index.asp"%>
<!--#include file="../inc/top.asp"-->
<div align="center">
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr> 
<td width="180" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="table-you">
<!--#include file="../loginout.asp"-->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="35" bgcolor="f1f1f1" background="/jw/images/menu_02.gif" valign="bottom">
<p align="right">快 速 查 询 通 道&nbsp;&nbsp;&nbsp;</td>
</tr>
<tr> 
<td> 
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" height="70">
<tr> 
<td height="20"> 
　您的购物车有<font color=red>0</font>件商品<br>
　总金额：<font color=red>0</font>元
</td>
</tr>
<tr> 
<td height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="580" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR><td class="table-shangxia" bgcolor="#ffffff" height="35"><img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href="/jw/index.asp">教学系统</a> 
	&gt;&gt; &gt;&gt; <a href="index.asp">学生事务</a> &gt;&gt; &gt;&gt; 总成绩查询</td></tr>
</table>
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td align="center" width="6" height="27">　</td>
<td class="table-xia" align="center" height="27"><font color="#008000">总成绩</font></td>
<td align="center" width="5" height="27">　</td>
</tr>
</table>
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-you" align="center" width="5" height="20"><p>　</p></td>
<td class="table-you" align="center" width="94" height="20"><p class="table-xia">课程代码</p></td>
<td class="table-you" align="center" width="132" height="20"><p class="table-xia">
课程名称</p></td>
<td class="table-you" align="center" width="82" height="20"><p class="table-xia">
学年</p></td>
<td class="table-you" align="center" width="83" height="20">
<p class="table-xia">学期</td>
<td class="table-you" align="center" width="83" height="20">
<p class="table-xia">成绩</td>
<td class="table-you" align="center" width="95" height="20"><p class="table-xia">
　</p></td>
<td align="center" width="6" height="20">　</td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from Jw_score where studentnum = '" & request.Cookies("jiaowu")("Num") & "' order by xn,xq"
rs.open sql,conn,1,3
do while not rs.eof
%>
<TR>
<td class="table-you" align="center" width="5" height="20"><p>　</p></td>
<td class="table-you" align="center" width="94" height="20"><p class="table-xia"><% =rs("kcdm")%></p></td>
<td class="table-you" align="center" width="132" height="20"><p class="table-xia"><% =rs("kcmc")%></p></td>
<td class="table-you" align="center" width="82" height="20"><p class="table-xia"><% if rs("xn") <> "" then response.write rs("xn") else response.write "　"%></p></td>
<td class="table-you" align="center" width="83" height="20"><p class="table-xia"><% if rs("xq") <> "" then response.write rs("xq") else response.write "　"%></p></td>
<td class="table-you" align="center" width="83" height="20"><p class="table-xia"><% =rs("score")%></p></td>
<td class="table-you" align="center" width="95" height="20"><p class="table-xia">　</p></td>
<td align="center" width="6" height="20">　</td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
</div>
<!--#include file="../inc/end.asp"-->