bmlb.asp

来自「网上报名系统!用于 电脑学校(院)」· ASP 代码 · 共 43 行

<!--#include file="conn.asp" -->
<!--#include file="top.asp" -->



<%
exec="select * from user order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<link href="css/aindex.css" rel="stylesheet" type="text/css" />
<link href="css/index.css" rel="stylesheet" type="text/css" />




<table width="100%" align="center" cellpadding="5" cellspacing="1" class="bx"> 
     <tr>
       <td colspan="7" bgcolor="#FFFFFF">报名列表</td>
     </tr>
     <tr>
       <td colspan="7" bgcolor="#FFFFFF"></td>
     </tr>
     <tr>
	   <td width="15%" class="bg">用户</td>
	   <td width="9%" class="bg">姓名</td>
	   <td width="8%" class="bg">性别</td>
	   <td width="68%" class="bg">选报专业/课程</td>
     </tr>
<% do while not rs.eof %>
     <tr>
	   <td class="bg2"><%=rs("uname")%></td>
	   <td class="bg2"><%=rs("un")%></td>
	   <td align="center" class="bg2"><%=rs("xb")%></td>
	   <td class="bg2"><%=rs("zy")%></td>
     </tr>
<%
rs.movenext
loop
%>  
</table>

<!--#include file="end.asp" -->