📄 test_paper.asp
字号:
<%@ Language=VBScript %>
<HTML>
<HEAD>
<meta name="GENERATOR" Content="Microsoft Visual Studio.NET 7.0">
</HEAD>
<body>
<%
'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())
response.Write(session("describe"))
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
%>
<DIV align="center">
<TABLE id="Table1" cellSpacing="1" cellPadding="1" align="center" border="0">
<%dim i
i=1
while not rs.EOF %>
<TR>
<TD><%=i &"."%><%=server.HTMLEncode (rs.Fields("题目"))%></TD>
</TR>
<TR>
<TD>A.<%=server.HTMLEncode(rs.Fields("答案A"))%></TD>
</TR>
<TR>
<TD>B.<%=server.HTMLEncode(rs.Fields("答案B"))%></TD>
</TR>
<TR>
<TD>C.<%=server.HTMLEncode(rs.Fields("答案C"))%></TD>
</TR>
<TR>
<TD>D.<%=server.HTMLEncode(rs.Fields("答案D"))%></TD>
</TR>
<tr><td> </td></tr>
<%rs.MoveNext
i=i+1
wend%>
</TABLE>
</DIV>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -