📄 xscj_list.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!--#include file = conn.asp-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>学生课程成绩</title>
<style>
@import URL("xscj.css");
</style>
</head>
<body>
<%
dim rs,sql
set rs = server.CreateObject("ADODB.recordset")
sql = "select XS.XH,XM,ZY,ZXF,KC.KCH,CJ,KCM from XS,KC,XS_KC where XS.XH=XS_KC.XH and KC.KCH=XS_KC.KCH and XS.XH='"&request("XH1")&"'"
rs.open sql,conn,1,1
%>
<div align="center" class="pagenote1">学生课程显示</div>
<hr />
<%
if not rs.eof then
%>
<table width="60%" align="center">
<tr bordercolor="#000000" bgcolor="#99CCCC">
<td>学号:<%=rs("XH")%></td>
<td>姓名:<%=rs("XM")%></td>
</tr>
<tr bordercolor="#000000" bgcolor="#99CCCC">
<td>专业:<%=rs("ZY")%></td>
<td>总学分:<%=rs("ZXF")%></td>
</tr>
</table>
<table width="60%" align="center" bordercolor="#000000" border="1" cellpadding="0" cellspacing="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr height="22" class="tableth1">
<td width="20%">课程号</td>
<td width="60%">课程名</td>
<td width="20%">成绩</td>
</tr>
<%while not rs.eof%>
<tr height="22">
<td width="200"><%=rs("KCH")%></td>
<td width="200"><%=rs("KCM")%></td>
<td width="100"><%=rs("CJ")%></td>
</tr>
<%rs.movenext
wend%>
</table>
<%end if%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -