?? bjcx1.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="bjcx.asp">返回</a>
</H3>
<center>
<TABLE BORDER=1>
<TR><td>序號</td><td>學號</td><td>姓名</td></tr>
<%
i=1
Do While Not RS.EOF %>
<tr>
<td><%=i%></td>
<td><%=tdm%>
<% Response.Write RS("xh")%>
</td>
<td><%response.write rs("xm")%></td>
</tr>
<%RS.MoveNext
i=i+1
Loop
rs.close
set rs=nothing
%>
</table></center>
<p align="center"><a href="bjcx.asp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -