📄 editor.asp
字号:
<%@ Language=VBScript%>
<%option explicit
on error resume next
sub session_onstart
Session.contents("qno")=0
Session.contents("totalrec")=0
end sub
'''''''''''''''''''''''''''''''''''''''''''''''''''
%> <!-- #INCLUDE FILE = "connect_ama.asp" -->
<%
dim myrs,sq
' sq="select * from q_bank where q_id between 10 and 30"
set myrs = server.createobject("ADODB.recordset")
myrs.open "q_bank",myconn,3
'3=adOpenStatic,then only myrs.recordcount will work
''''''''''''''''''''''''''''''''''''''''''''''''''
dim qno,totalrec
qno=Session.contents("qno")
totalrec=myrs.RecordCount
Session.contents("totalrec")= totalrec
if qno=0 then
myrs.movefirst
qno=qno+1
Session.contents("qno")=qno
else
dim butt,temp
''''''''''''''''''''''''''''''''''''''''
''request from editor page Next button''
if request.form("next")="next" then
butt="next"
qno=qno+1
if qno > totalrec then qno = 1
Session.contents("qno")=qno
myrs.move qno-1
'''''''''''''''''''''''''''''''''''''''''
''request from editor page Back button'''''
elseif request.form("back")="back" then
butt="back"
qno=qno-1
if qno<1 then qno = totalrec
Session.contents("qno")=qno
myrs.move qno-1
'''''''''''''''''''''''''''''''''''''''''
''request from search page GO button'''''
elseif request.form("go")="GO" then
temp=request.form("q_id")
myrs.movefirst
qno=0
while not myrs.EOF and cint (myrs("q_id")) <> cint(temp)
qno=qno+1
myrs.movenext
wend
Session.contents("qno")=qno
' myrs.move qno
elseif request.form("search")="Search" then
'添加搜索语句
'''''''''''''''''''''''''''''''''''''''''
else
myrs.move qno
end if
butt="normalllllllllll"
end if
'''''''''''''''''''''''''''''''''''''''''''''''''
%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<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><%=butt%>Question Bank Editor</title>
</head>
<body>
<div align="left">
<table width="80%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr><td style="WIDTH: 500px" width=500 bgColor=gold
><P align=right><strong style="font-weight: 400"><span lang="zh-cn">
<font size="4">试题编辑</font></span></strong> </P>
</td>
</tr>
</table>
</div>
<form method="POST" name="form_data" action="update.asp">
<div align="left">
<p><span lang="zh-cn">记录序号</span>:<%=qno%>/<%=totalrec%> </p>
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#111111" width="80%">
<tr>
<td width="50%"><span lang="zh-cn">序号</span></td>
<td width="50%">
<input type="text" name="q_id" size="20" value="<%=myrs("q_id")%>"></td>
</tr>
<tr>
<td width="50%">试题编号 </td>
<td width="50%">
<input type="text" name="code" size="20" value="<%=myrs("code")%>"></td>
</tr>
<tr>
<td width="50%"><span lang="zh-cn">问题</span></td>
<td width="50%"><textarea rows="6" name="question" cols="30"><%=myrs("question")%></textarea></td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%"> </td>
</tr>
<tr>
<td width="50%"><span lang="zh-cn">选项</span> A</td>
<td width="50%"><textarea rows="4" name="optA" cols="30"><%=myrs("optA")%></textarea></td>
</tr>
<tr>
<td width="50%"><span lang="zh-cn">选项</span> B</td>
<td width="50%"><textarea rows="4" name="optB" cols="30"><%=myrs("optB")%></textarea></td>
</tr>
<tr>
<td width="50%"><span lang="zh-cn">选项</span> C</td>
<td width="50%"><textarea rows="4" name="optC" cols="30"><%=myrs("optC")%></textarea></td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%"> </td>
</tr>
<tr>
<td width="50%"><span lang="zh-cn">答案</span></td>
<td width="50%"><select size="1" name="answer">
<option selected value="<%=myrs("Answer")%>"><%=myrs("Answer")%></option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select></td>
</tr>
<tr>
<td width="50%"><span lang="zh-cn">图像</span></td>
<td width="50%">
<input type="text" name="image" size="20" value ="<%=myrs("image")%>"></td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%"> </td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%" bgcolor="#FFD700">
<p align="center"><input type="reset" value="取消保存" name="B2"><input type="submit" value="保存记录" name="B1"> </td>
</tr>
</table>
</div>
</form>
<div align="left">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="80%">
<tr>
<td width="50%">
</td>
<td width="50%" bgcolor="#FFD700">
<form method="POST" name="form_next" action="editor.asp">
<p align="center">
<input type="submit" value="back" name="back">
<input type="submit" value="next" name="next">
</p>
</form>
</td>
</tr>
<tr>
<td width="50%"> </td>
<td width="50%" bgcolor="#FFD700">
<form method="POST" name="form_del" action="delete.asp">
<p align="center">
<input type="submit" value="删除当前记录" name="delete">
<input type="hidden" name="q_id" size="20" value="<%=myrs("q_id")%>"></p>
</form>
<form method="POST" name="form_addnew" action="addnew.asp">
<p align="center">
<input type="submit" value="添加新记录" name="add">
<input type="hidden" name="q_id" size="20" value="<%=myrs("q_id")%>"></p>
</form>
<form method="POST" name="form_search" action="search.asp">
<p align="center">
<input type="submit" value="查询记录" name="search">
</form>
</td>
</tr>
</table>
</div>
<p> </p>
<p> </p>
<div align="left">
<table width="80%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0">
<tr><td style="WIDTH: 500px" width=500 bgColor=gold
>
<p align="right"><span lang="zh-cn"><a href="control_panel.asp">在线考试系统</a></span></td>
</tr>
</table>
</div>
</body>
</html>
<%=session.sessionID%><br>
<%=session.timeout%><br>
<%
' Session.abandon
'''''''''''''''''''''''''''''''''
'关闭数据库连接''''''''
myrs.close
myconn.close
set myconn=nothing
set myrs=nothing
'''''''''''''''''''''''''''''''''
%>
<br>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -