📄 list_cj.asp
字号:
<!--#include file="../inc/open.asp" -->
<!--#include file="../inc/md5.inc" --><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><!--#include file="../inc/css.css" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>显示成绩</title>
</head>
<body>
<!--#include file="../inc/top.asp" -->
<!--#include file="../inc/menu.asp" -->
<%if session("zzteacher")=false then
te_user_login=trim(request.form("te_user_login"))
te_pass_login=trim(request.form("te_pass_login"))
if te_user_login<>"" and te_pass_login<>"" then
te_pass_login=ucase(md5(te_pass_login))
str="select * from user_te where teacher_user='"&te_user_login&"' and teacher_pass='"&te_pass_login&"'"
set rs=conn.execute(str)
if not rs.eof then
session("zzteacher")=true
if rs("teacher_class")="超级管理员" then
session("adminadmin")=true
end if
end if
end if
end if%>
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="ff99cc" bgcolor="edebeb">
<tr>
<td width="200" valign="top"><table width="163" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="unnamed6"> </td>
</tr>
<tr>
<td background="../images/nxmt_lj_46.gif" class="unnamed10"> </td>
</tr>
<tr>
<td background="../images/nxmt_lj_44.gif"><div align="center" class="unnamed14">用户登录</div></td>
</tr>
<tr>
<td background="../images/nxmt_lj_44.gif" class="unnamed12"> <%if session("zzteacher")=flase then%> <form action="test_pigai.asp" method="post" name="form1" class="unnamed12">
<div align="center">用户名:
<input name="te_user_login" type="text" id="te_user_login" size="12" maxlength="15">
<br>
<br>
密 码:
<input name="te_pass_login" type="password" id="te_pass_login" size="12" maxlength="15">
<br>
<br>
<input type="submit" name="Submit" value=" 登 录 ">
</div>
</form>
<div align="center">
<% else
response.write "<br><center>已登录 <a href=../quit.asp>退出</a>"
response.write "<br><br><a href=stlx_setup.asp?lx=no>设置为没有练习状态</a>"
response.write "<br><br><a href=stlx_setup.asp?lx=yes>设置为练习状态</a>"
end if
%>
</div></td>
</tr>
<tr>
<td background="../images/nxmt_lj_45.gif" class="unnamed10"> </td>
</tr>
</table>
<table width="163" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td><div align="center"><INPUT class=unnamed5 onclick=javascript:history.go(-1) type=button value= 返 回 ></div></td>
</tr>
</table>
<br>
</td>
<td width="570" valign="top"><div align="center"> <font color="#0000FF"><strong><span class="unnamed14">
<%table_name=request.querystring("table_name")
if table_name<>"" then
str="select * from test_gl where 数据表名='"&table_name&"'"
set rs=conn.execute(str)
response.write rs("考试名称")%>
</span></strong></font> <span class="unnamed12">
<% response.write "<br><br><class=unnamed14>班级："&rs("考试班级")&" 考试日期："&rs("考试日期")&"<br>开始时间："&rs("开考时间")&" 结束时间："&rs("结束时间")&" 试题数："&rs("试题数量")&"个"
str="select * from "&table_name&""
set rs=conn.execute(str)
%>
</span>
<table width="500" border="1" cellpadding="0" cellspacing="0" class="unnamed12">
<tr bgcolor="#CCCCCC">
<td height="20">
<div align="center">学籍卡号</div></td>
<td height="20">
<div align="center">姓 名</div></td>
<td height="20">
<div align="center">答对数</div></td>
<td height="20">
<div align="center">答错数</div></td>
<td height="20">
<div align="center">总得分</div></td>
</tr>
<%do while not rs.eof%>
<tr>
<td height="20">
<div align="center"><%=rs("xj_id")%></div></td>
<td height="20">
<div align="center"><%=rs("name")%></div></td>
<td height="20">
<div align="center"><%=rs("答对数")%></div></td>
<td height="20">
<div align="center"><%=rs("答错数")%></div></td>
<td height="20">
<div align="center"><%if rs("总得分")<60 then response.write "<font color=#FF0000>"&rs("总得分")else response.write rs("总得分")%></font></div></td>
</tr>
<%rs.movenext
loop%>
</table>
<%end if%>
</div></td>
</tr>
</table>
<!--#include file="../inc/bottom.inc" -->
<%conn.close%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -