user_ks.asp

吻宇考试管理系统源码 吻宇考试管理系统源码

<!--#include file="checkuser.asp"-->
<!--#include file="inc.asp"-->
<%call top()%>
<table width="781" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
  <tr background="IMG/topbg.gif">
    <td colspan="3"><%call head()%></td>
  </tr>
  <tr>
    <td width="204" height="207" rowspan="3"><table width="100%" border=0 cellpadding=1 cellspacing=1 bgcolor="#EFEFEF">
      <tbody>
        <tr bordercolor=#999999>
          <td valign=center bordercolor=#999999 align=middle bgcolor=#efefef 
            height=17><div align="center"><img src="img/user.gif" width="200" height="22"></div></td>
        </tr>
        <tr>
          <td valign=top bgcolor=#efefef>
            <table id=AutoNumber2 style="BORDER-COLLAPSE: collapse" 
            cellspacing=0 cellpadding=0 width="100%" border=0>
              <tbody>
                <tr>
                  <td align=middle><table width="0" border="0">
                    <%
			dim rs3,sql3
			set rs3=server.createobject("adodb.recordset")
			sql3="select * from user where name='"&request.cookies("name")&"'"
	                rs3.open sql3,conn,1,1
			%>
                    <tr>
                      <td colspan="2">欢迎<span class="style1"><%=rs3("name")%>同学来到吻宇考试系统</span></td>
                    </tr>
                    <tr>
                      <td colspan="2">我的准考证号：<%=rs3("zkz")%></td>
                    </tr>
                    <tr>
                      <td colspan="2">我的所在的班级：<%=rs3("class")%></td>
                    </tr>
                    <tr>
                      <td width="77" bgcolor="#efefef"><div align="center"><span class="style3"><a href="user_ks.asp?id=<%=RS3("id")%>" class="style3">我的考试信息</a></span></div></td>
                      <td width="105"><div align="right" class="style3">
                          <div align="center"><a href="user_xg.asp?id=<%=rs3("id")%>" class="style3">我的资料修改</a></div>
                      </div></td>
                    </tr>
                    <tr>
                      <td colspan="2"><div align="center"><a href="exit.asp">退出吻宇网络</a></div></td>
                    </tr>
                  </table></td>
                </tr>
              </tbody>
          </table></td>
        </tr>
        <tr bordercolor=#999999>
          <td bordercolor=#999999 align=left bgcolor=#efefef>     
        </tr>
        <tr bordercolor=#999999>
          <td align=middLe background=IMG/lljs.gif bgcolor=#efefef 
          height=18><div align="center"><img src="img/tj.gif" width="200" height="22"></div></td>
        </tr>
        <tr bordercolor=#999999>
          <td bgcolor=#efefef><font color=#000000>
            <script src=js.asp></script>
          </font></td>
        </tr>
        <tr bordercolor=#999999>
          <td valign=ceNter 
          bgcolor=#efefef height=18>
            <div align=center><img src="img/hezuo.gif" width="200" height="22"></div></td>
        </tr>
        <tr bordercolor=#999999>
          <td valign=cEnter bgcolor=#efefef height=10>
            <table width=0 align=center border=0>
              <tbody>
                <tr>
                  <td width=87>&nbsp;</td>
                </tr>
                <tr>
                  <td><a href="http://www.e0b.com/"><img height=31 
                  src="IMG/tclogo.gif" width=88 
              border=0></a></td>
                </tr>
              </tbody>
            </table>
            <p align=center><font color=#000000><br>
          </font></p></td>
        </tr>
        <tr bordercolor=#999999>
          <td valign=cenTer bgcolor=#efefef 
      height=16>&nbsp;</td>
        </tr>
      </tbody>
    </table></td>
    <td width="7" rowspan="3" background="IMG/sd.gif">&nbsp;</td>
    <td width="603">
	</td>
  </tr>
  <tr>
    <td width="575"><table width="521" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#67B0ED">
        <tr bgcolor="#FFFFFF"> 
          <td colspan="6"><div align="center">考试成绩管理系统</div></td>
        </tr>
        <tr bgcolor="#FFFFFF"> 
          <td width="93" height="16"><div align="center">考试的科目</div></td>
          <td width="67"><div align="center"> 参加的考生</div></td>
          <td width="83"><div align="center">考试的分数</div></td>
          <td width="136"><div align="center">参加考试的日期</div></td>
          <td width="120"><div align="center">成绩属性</div></td>
 </tr>
        <%
  dim wyrs,wysql,wyrs1,wysql1
  dim wyid,wykemu,wyusername,wyscore,wyksdate,wyid1,namer
  wyid1=request.querystring("id")
  set wyrs1=server.CreateObject("adodb.recordset")
  wysql1="select * from user where id="&wyid1&""
  wyrs1.open wysql1,conn,1,1
  namer=wyrs1("name")
  set wyrs=server.CreateObject("adodb.recordset")
  wysql="select * from score where username='"&namer&"' order by id DESC"
  wyrs.open wysql,conn,1,1
  if not wyrs.eof then
  wyrs.movefirst
  do while not wyrs.eof
  wyid=wyrs("id")
  wykemu=wyrs("kemu")
  wyusername=wyrs("username")
  wyscore=wyrs("score")
  wyksdate=wyrs("ksdate")
  wytype=wyrs("type")
  %>
        <tr bgcolor="#FFFFFF"> 
          <td><div align="center"><%=wykemu%></div></td>
          <td><div align="center"><%=wyusername%></div></td>
          <td><div align="center"><%=wyscore%></div></td>
          <td><div align="center"><%=wyksdate%></div></td>
          <td><div align="center"><%=wytype%></div></td>
     </tr>
        <%
wyrs.movenext
loop
else 
response.write"暂时没有任何数据"
end if
wyrs.close
wyrs1.close
set wyrs=nothing
set wyrs1=nothing

%>
      </table></td>
  </tr>
  <tr>
    <td></td>
  </tr>
  <tr background="IMG/topbg.gif">
    <td colspan="3"><%call footer()%></td>
  </tr>
</table>
</body>
</html>