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

<%

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

<table width="100%" border="0" cellpadding="5" cellspacing="1" class="bx">
  <tr>
    <td colspan="5" class="bg">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="5" align="right" class="bg4">
<!--#include file="pg1.asp" -->
    </td>
  </tr>
<% for i=1 to rs.pagesize %>	 
<% if rs.eof then
   exit for
   end if
%>  
  <tr>
    <td colspan="5" class="bg"><%=rs("un")%> [<%=rs("uname")%>] 的個人資料</td>
  </tr>
  
  <tr>
    <td width="15%" align="right" class="bg2">用戶</td>
    <td width="34%" class="bg2"><%=rs("uname")%></td>
    <td width="11%" align="right" class="bg2">&nbsp;</td>
    <td width="28%" class="bg2">&nbsp;</td>
    <td width="12%" rowspan="5" class="bg2">	   <%if rs("img")<>"" then%>
	<img src="../up/<%=rs("img")%>" width="100" height="140" border="0">
	<%else%>
	<img src="../img/nopic.gif" width="120" height="150" border="0" />
	<%end if%></td>
  </tr>
  <tr>
    <td align="right" class="bg2">姓名</td>
    <td class="bg2"><%=rs("un")%></td>
    <td align="right" class="bg2">性別</td>
    <td class="bg2"><%=rs("xb")%></td>
  </tr>
  <tr>
    <td align="right" class="bg2">生日</td>
    <td class="bg2"><%=rs("sr")%></td>
    <td align="right" class="bg2">民族</td>
    <td class="bg2"><%=rs("mz")%></td>
  </tr>
  <tr>
    <td align="right" class="bg2">電話</td>
    <td class="bg2"><%=rs("tel")%></td>
    <td align="right" class="bg2">QQ</td>
    <td class="bg2"><%=rs("qq")%></td>
  </tr>
  <tr>
    <td align="right" class="bg2">地址</td>
    <td class="bg2"><%=rs("dz")%></td>
    <td align="right" class="bg2">郵箱</td>
    <td class="bg2"><%=rs("email")%></td>
  </tr>
  <tr>
    <td align="right" class="bg2">畢業學校</td>
    <td class="bg2"><%=rs("xx")%></td>
    <td align="right" class="bg2">學歷</td>
    <td class="bg2"><%=rs("xl")%></td>
    <td class="bg2">&nbsp;</td>
  </tr>
  <tr>
    <td align="right" class="bg2">所選課程</td>
    <td class="bg2"><%=rs("xk")%></td>
    <td align="right" class="bg2">分數</td>
    <td class="bg2"><%=rs("xf")%></td>
    <td class="bg2">&nbsp;</td>
  </tr>
  <tr>
    <td align="right" class="bg2">總分</td>
    <td class="bg2"><%=rs("zf")%></td>
    <td align="right" class="bg2">&nbsp;</td>
    <td class="bg2">&nbsp;</td>
    <td class="bg2">&nbsp;</td>
  </tr>
  <tr>
    <td align="right" class="bg2">個人簡介</td>
    <td class="bg2"><%=rs("jj")%></td>
    <td align="right" class="bg2">&nbsp;</td>
    <td class="bg2">&nbsp;</td>
    <td class="bg2">&nbsp;</td>
  </tr>
  <tr>
    <td align="right" class="bg2">所報專業</td>
    <td class="bg2"><%=rs("zy")%></td>
    <td align="right" class="bg2">入學時間</td>
    <td class="bg2"><%=rs("rd")%></td>
    <td class="bg2">&nbsp;</td>
  </tr>
  <tr>
    <td align="right" class="bg2">&nbsp;</td>
    <td class="bg2"><a href="u_del.asp?id=<%=rs("id")%>">刪除</a> <a href="u_check.asp?id=<%=rs("id")%>">修改</a></td>
    <td class="bg2">&nbsp;</td>
    <td class="bg2">&nbsp;</td>
    <td class="bg2">&nbsp;</td>
  </tr>
</table>
<%
rs.movenext
next
%>