教材上的在线考试程 序中有这么多的有关：是否补考查询语句看的人云里雾里，到底是啥思路，请指教。
<%flagpd=0
flagxz=0
flagtk=0
randomize
set rss=conn.execute("select top 1 * from report where 学生id="&session("id")&" and (是否补考=no or 补考成绩<>0) order by id desc ")
if rss.eof then
qi=1
else
qi=rss("id")+1
end if
set rss=conn.execute("select top 1 * from report where 学生id="&session("id")&" and (是否补考=yes and 补考成绩=0) order by id desc ")
if not rss.eof then
qi=rss("id")
end if
set rss=conn.execute("select top 1 * from test order by id desc")
if rss.eof then
%>
<script language=javascript>
alert("请先出题！再进行考试！");
history.back();
</script>
<%
else
pd=rss("判断题数")
pds=rss("判断题每题分数")
xz=rss("选择题数")
xzs=rss("选择题每题分数")
tk=rss("填空题数")
tks=rss("填空题每题分数")
session("EndTime")=rss("考试时间")
zf=pd*pds+xz*xzs+tk*tks
testid=rss("id")
response.write "testid"&testid
set rs=conn.execute("select top 1 * from type1 order by id desc")
maxtype1=rs("id")
set rs=conn.execute("select top 1 * from type2 order by id desc")
maxtype2=rs("id")
set rs=conn.execute("select top 1 * from type3 order by id desc")
maxtype3=rs("id")
sqlfind="select * from report where 试卷id="&testid&" and 学生id="&session("id")&" and (是否补考=False or 补考成绩<>0)"
set rsfind=conn.execute (sqlfind)
if not rsfind.eof then
%>
<script language=javascript>
alert("你已经参加过这次考试了，请等待下一次考试！");
window.navigate("index.asp");
</script>
<%else
if Session("startTime") = "" then
NowTime = Now()
Session("startTime") = NowTime
end if
set rsfinds=conn.execute("select * from report where 试卷id="&testid&" and 学生id="&session("id")&" and (是否补考=True and 补考成绩=0)")
if not rsfinds.eof then
else
sqlin="insert into report (id,试卷id,学生id,分数) values("&qi&","&testid&","&session("id")&",0)"
'response.write sqlin
'response.end
set rsin=conn.execute(sqlin)
end if
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<!--#include file = "top.htm" -->
<table border="1" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" height ="100" align="center">
<tr>
<td align="center"><font class=test1>第 <%=qi%> 期考试</font>
<br>（本期考试 <%=pd%> 道判断题，<%=xz%> 道选择题，<%=tk%> 道填空题，总分 <%=zf%> 分）
</td>
</tr>
<tr>
<td align="center"><!--#include file="js2.asp" -->
</td>
</tr><form name="form1" action="test_over.asp" method="post">
<tr>
<td align="center" bgcolor="#CBEFDC"><font color="#000080"><input type="text" name=qi value=<%=qi%>>
<input type="text" name=testid value=<%=testid%>>
<input type="hidden" name=pd value=<%=pd%>>
<input type="hidden" name=xz value=<%=xz%>>
<input type="hidden" name=tk value=<%=tk%>>
<input type="hidden" name=zf value=<%=zf%>>
<input type="hidden" name=pds value=<%=pds%>>
<input type="hidden" name=xzs value=<%=xzs%>>
<input type="hidden" name=tks value=<%=tks%>>考生姓名：<%=session("student")%> 性别： <%=session("sex")%> 班级：<%=session("classes")%> 学号：<%=session("number")%></font></td>
</tr>
<tr>
<td align="center">
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750" align="center">
<tr>
<td bgcolor="#CBEFDC">一、判断题（共 <%=pd%> 道，每题 <%=pds%> 分）</td>
</tr>
<%
if pd=0 then
Response.write "<input type='hidden' name=messagepd value='本次考无判断题'>"
flagpd=1
%>
<tr>
<td align=center>本次不考判断题</td>
</tr>
<%
else
for i=1 to pd
if maxtype1=0 then
Response.write "<input type='hidden' name=messagepd value='题库里暂无判断题'>"
flagpd=1
%>
<tr>
<td align=center>题库里暂无判断题</td>
</tr>
<%
else
randomize
sid=int((maxtype1+1)*rnd+1)
set rst=conn.execute("select * from type1 where id="&sid)
while rst.eof
randomize
sid=int((maxtype1+1)*rnd+1)
set rst=conn.execute("select * from type1 where id="&sid)
wend
%>
<tr>
<td> <%=i%>、<%=rst("题干")%>
<input type="hidden" name="tgpd<%=i%>" value="<%=rst("题干")%>">
<select name="cate<%=i%>" size="1" style="background-color: rgb(224,252,255)">
<option selected value=True>对</option>
<option value=False>错</option></select>
<input type="hidden" name="pdda<%=i%>" value="<%=rst("正确答案")%>">
</td>
</tr>
<%
end if
next
end if %>
</table>
<br>
<table align="center" border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750">
<tr>
<td bgcolor="#CBEFDC">二、选择题（共 <%=xz%> 道，每题 <%=xzs%> 分）</td>
</tr>
<%if xz=0 then
response.write "<input type='hidden' name=messagexz value='本次考无选择题'>"
flagxz=1
%><tr>
<td align=center>本次考无选择题
</td>
</tr>
<%else
for i=1 to xz
if maxtype2=0 then
response.write "<input type='hidden' name=messagexz value='题库里暂无选择题'>"
flagxz=1
%><tr>
<td align=center>题库里暂无选择题
</td>
</tr>
<%else
randomize
sid=int((maxtype2+1)*rnd+1)
set rst=conn.execute("select * from type2 where id="&sid)
while rst.eof
randomize
sid=int((maxtype2+1)*rnd+1)
set rst=conn.execute("select * from type2 where id="&sid)
wend
%>
<tr>
<td> <%=i%>、<%=rst("题干")%>
<input type="hidden" name="tgxz<%=i%>" value="<%=rst("题干")%>"></td>
</tr>
<tr>
<td>
<input type="radio" value="A" name="sele<%=i%>"> A.<%=rst("选项1")%>
<input type="hidden" name="xzxx1<%=i%>" value="<%=rst("选项1")%>" >
<input type="radio" value="B" name="sele<%=i%>"> B.<%=rst("选项2")%>
<input type="hidden" name="xzxx2<%=i%>" value="<%=rst("选项2")%>" >
<input type="radio" value="C" name="sele<%=i%>"> C.<%=rst("选项3")%>
<input type="hidden" name="xzxx3<%=i%>" value="<%=rst("选项3")%>" >
<input type="radio" value="D" name="sele<%=i%>"> D.<%=rst("选项4")%>
<input type="hidden" name="xzxx4<%=i%>" value="<%=rst("选项4")%>" >
<input type="hidden" name="xzda<%=i%>" value="<%=rst("正确答案")%>" >
</td>
</tr>
<%
end if
next
end if %>
</table>
</center>
</div>
<br>
<div align="center">
<center>
<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750">
<tr>
<td bgcolor="#CBEFDC">三、填空题（共 <%=tk%> 道，每题 <%=tks%> 分）</td>
</tr>
<%if tk=0 then
response.write "<input type='hidden' name=messagetk value='本次考无填空题'>"
flagtk=1
%><tr>
<td align=center>本次考无填空题
</td>
</tr>
<%else
for i=1 to tk
if maxtype3=0 then
response.write "<input type='hidden' name=messagetk value='题库里暂无填空题'>"
flagtk=1
%><tr>
<td align=center>题库里暂无填空题
</td>
</tr>
<%else
randomize
sid=int((maxtype3+1)*rnd+1)
set rst=conn.execute("select * from type3 where id="&sid)
while rst.eof
randomize
sid=int((maxtype3+1)*rnd+1)
set rst=conn.execute("select * from type3 where id="&sid)
wend
%>
<tr>
<td> <%=i%>、<%=rst("题干")%>
<input type="hidden" name="tgtk<%=i%>" value="<%=rst("题干")%>">
您的答案：<input type="text" name="T<%=i%>" size="20" class="line"></td>
<input type="hidden" name="tkda<%=i%>" value="<%=rst("正确答案")%>">
</tr>
<%
end if
next
end if %>
</table>
</center>
</div>
<br>
<input type="hidden" name="flagpd" value=<%= flagpd %>>
<input type="hidden" name="flagxz" value=<%= flagxz %>>
<input type="hidden" name="flagtk" value=<%= flagtk %>>
<input type="submit" value="提交" name="B1">
<input type="reset" value="重置" name="B2">
<p>
<br>
</td>
</tr>
</table>
</form>
</center>
</div>
<!--#include file="adv.htm"-->
</body>
</html>
<%end if %>
