📄 exam.asp
字号:
<%@ Language=VBScript %>
<HTML>
<HEAD>
<meta content="Microsoft Visual Studio.NET 7.0" name="GENERATOR">
<script id="clientEventHandlersJS" language="javascript">
<!--
function Checkbox1_onclick()
{
if (document.form1.Checkbox1.checked==true)
{
document.form1.hidden1.value=document.form1.Checkbox1.value
window.alert(document.form1.hidden1.value)
document.form1.submit()
}
}
-->
</script>
</HEAD>
<body>
<%
session("questionanswer")=request.Form("hidden1")
if session("questionanswer")<>"" then
set cn=server.CreateObject("adodb.connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("data/s223bsh03.mdb") & ";Persist Security Info=False"
set rs3=server.CreateObject("adodb.recordset")
rs3.Open "insert into store_answer values('"& session("id") &"','"& i &"','"& session("questionanswer") &"')",cn,3,1
end if
On Error Resume Next
session("describe")=request.Form("Select1")
set cn=server.CreateObject("adodb.connection")
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("data/s223bsh03.mdb") & ";Persist Security Info=False"
set rs=server.CreateObject("adodb.recordset")
set rs1=server.CreateObject("adodb.recordset")
rs.Open "select * from result where 成绩<60 and 学号='" & session("id") & "'and 学期='" & session("term") & "'",cn,3,1
if session("describe")= session("term") & "综合考试"then
if not rs.EOF then
%>
<script language="javascript">
window.alert("你有未通过的考试科目！ 各科均以通过才允许考试！")
window.open("exam_interface.asp","_parent")
</script>
<%
rs.Close
response.End()
else
rs.Close
dim Dstr_date
Dstr_date=cstr(date())
rs1.Open "select * from test_paper where 试卷描述='" & session("describe") & "'",cn,3,1
if not rs1.EOF then
t=Replace(rs1.Fields("题目编号"),"/",",")
rs.Open "select * from test_questions_store where id in(" & t &")"
end if
end if
else
rs.Close
rs1.Open "select * from test_paper where 试卷描述='" & session("describe") & "'",cn,3,1
if not rs1.EOF then
t=Replace(rs1.Fields("题目编号"),"/",",")
rs.Open "select * from test_questions_store where id in(" & t &")"
end if
end if
%>
<form method="post" name="form1" action="exam.asp">
<P align="center">
<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="300" border="0">
<TR>
<TD>
<P align="center"><font size="6">考试试卷</font></P>
</TD>
</TR>
</TABLE>
</P>
<P align="center">
<TABLE cellSpacing="1" cellPadding="1" align="left" border="0">
<%
dim i
i=1
while not rs.EOF
%>
<TR>
<TD>
<%response.Write(i & ".")%>
<FONT face=宋体></FONT>
<%=rs.Fields("题目")%>
</TD>
<TD></TD>
</TR>
<tr>
<td><INPUT id="Checkbox1" type="checkbox" name=i & onclick="return Checkbox1_onclick()"? Checkbox1?>
<%=server.HTMLEncode(rs.Fields("答案A"))%>
</td>
<TD></TD>
</tr>
<tr>
<td><INPUT id="Checkbox2" type="checkbox" name="Checkbox2">
<%=server.HTMLEncode(rs.Fields("答案B"))%>
</td>
<TD></TD>
</tr>
<tr>
<td><INPUT id="Checkbox3" type="checkbox" name="Checkbox3">
<%=server.HTMLEncode(rs.Fields("答案C"))%>
</td>
<TD></TD>
</tr>
<tr>
<td><INPUT id="Checkbox4" type="checkbox" name="Checkbox4">
<%=server.HTMLEncode(rs.Fields("答案D"))%>
</td>
<TD></TD>
</tr>
<FONT face="宋体"></FONT><FONT face="宋体"></FONT>
<tr>
<td> </td>
<TD></TD>
</tr>
<%rs.MoveNext
i=i+1%>
<%wend%>
</TABLE>
</P>
<input type="hidden" name="hidden1"> <input type="hidden" name="hidden2">
</form>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -