<HTML>
<HEAD>
<title>學生信息列表</title>
</HEAD>
<BODY background=background.gif>
<P align=center><FONT size=5>學生總人數統計</FONT></P>
<table width="400" border="1" align="center" >
<%
set rs=server.createobject("adodb.recordset")
rs.open "select count(*),SSEX from student group by SSEX",conn,1,1
do until rs.eof
%>
<tr>
<th>全校學生<%=rs(1)%>生人數:</th><th><%=rs(0)%></th>
</tr>
<%
s=s+rs(0)
rs.movenext
loop
rs.close
set rs=nothing
set conn=nothing
%>
<tr>
<th>全校學生總人數:</th><th><%=s%></th>
</tr>
</table>
</BODY>
</HTML>