📄 llxj1.asp
字号:
<!--#include file="pwd1.asp" -->
<!--#include file="xmgl_conn.inc" -->
<%
tmc=request("bj")
sql="select * from bjk where bjmc='"&tmc&"'"
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.Open sql, xmgl_conn
tdm=rs("bjdm") '班级代码
rs.close
sql="select * from "&tdm&" order by xh"
RS.Open sql, xmgl_Conn
%>
<HTML>
<HEAD><TITLE>浏览“<%=tmc%>”班学籍</TITLE></HEAD>
<BODY bgcolor="#C0C0C0">
<H3 align=center>
浏览“<%=tmc%>(<%=tdm%>)”班学籍  <a href="llxj.asp">返回</a>
</H3>
<center>
<TABLE BGCOLOR=#ffffff CELLSPACING=0 BORDER=1>
<TR>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>学号</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>姓名</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>性别</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>出生日期</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>通讯地址</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>邮编</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>联系电话</td>
<td BGCOLOR=#c0c0c0 BORDERCOLOR=#000000>入学成绩</td>
</tr>
<% Do While Not RS.EOF %>
<tr>
<td BORDERCOLOR=#c0c0c0><% Response.Write RS("xh")%></td>
<td BORDERCOLOR=#c0c0c0><%response.write rs("xm")%></td>
<td BORDERCOLOR=#c0c0c0>
<% if rs("xb")<>"" then
response.write rs("xb")
else
response.write ("  ")
end if
%>
</td>
<td BORDERCOLOR=#c0c0c0>
<% if rs("rq")<>"" then
response.write rs("rq")
else
response.write ("  ")
end if
%>
</td>
<td BORDERCOLOR=#c0c0c0>
<% if rs("dz")<>"" then
response.write rs("dz")
else
response.write ("  ")
end if
%>
</td>
<td BORDERCOLOR=#c0c0c0>
<% if rs("yb")<>"" then
response.write rs("yb")
else
response.write ("  ")
end if
%></td>
<td BORDERCOLOR=#c0c0c0>
<% if rs("dh")<>"" then
response.write rs("dh")
else
response.write ("  ")
end if
%></td>
<td BORDERCOLOR=#c0c0c0>
<% if rs("cj")<>"" then
response.write rs("cj")
else
response.write ("  ")
end if
%></td>
</tr>
<%RS.MoveNext
Loop
rs.close
set rs=nothing
%>
</table></center>
<p align="center"><a href="llxj.asp">返回</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -