📄 admindatabaseedit.asp
字号:
<!--#include file="conn.inc"-->
<%
id=request("id")
'sql="select * from question_database where QueID ="&id
sql="select * from question_database e,subject_info s where e.Sub_ID = s.SubID and e.QueID ="&id
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
sid = rs("Sub_ID")
subjectview = rs("SubName")
typeedit=rs("Que_Type")
question=rs("Question")
Option1=rs("Option1")
Option2=rs("Option2")
Option3=rs("Option3")
Option4=rs("Option4")
Option5=rs("Option5")
Option6=rs("Option6")
answer=rs("StandKey")
v_sdiff= rs("DiffRate")
v_kid = rs("Knowledge_ID")
v_setUserID= rs("set_User_ID")
'response.Write("v_sknow:"&v_kid&"<br>")
'response.Write("DiffRate:"&v_sdiff&"<br>")
'response.Write("sid:"&sid&"<br>")
rs.close
set rs = nothing
sql = "select * from knowledge_info where KnowID = "&v_kid
set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,2
v_kName = rs("KnowName")
rs.close
set rs = nothing
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>网上考试系统 | 系统管理 | 查看编辑题目</title>
<script language="javascript">
function submitit()
{
if(document.all.setUserID.value != document.all.currUserID.value)
{
alert("不能修改别人的试题！");
return false;
}
if (document.all.question.value=="")
{
alert("标题不能为空！");
return false;
}
else
{
if (document.all.text1.value=="" )
{
alert("答案不能为空！");
return false;
}
else
return true;
}
}
</script>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body <table border="0" cellpadding="2" cellspacing="0" style="border-collapse: collapse" id="AutoNumber2" width="100%">
<tr>
<td width="100%" bgcolor="#FFFFFF">
<p>当前位置：<a href="news.asp">系统管理</a> > <a href="admindatabaseselect.asp">题库管理</a> > <a href="admindatabase.asp">试题管理</a>> 查看/编辑题目</td>
</tr>
</table>
<%
if typeedit="0" then
%> </p>
<form name="adminsubjectsingle" method="post" action="admindatabasesaveedit.asp" onSubmit="return submitit();">
<input type="hidden" name="sub_id" value=<%=sid%>>
<input name="qtype" type="hidden" value="<%=typeedit%>">
<input type="hidden" name="setUserID" value="<%=v_setUserID%>">
<input type="hidden" name="currUserID" value="<%=request.Cookies("userid")%>">
<table border="1" cellpadding="2" cellspacing="1" style="border-collapse: collapse" bordercolor="#C0C0C0" width="100%" id="AutoNumber3">
<tr>
<td width="80" align="center" bgcolor="#E1E1E1">当前题库</td>
<td>
<input type="text" name="subjectview" size="40" value="<%=subjectview%>" readonly class="inputnormal">
</td>
</tr>
<tr>
<td align="center" bgcolor="#E1E1E1">选择类型</td>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4">
<tr>
<td><input type="radio" value="<%=typeedit%>" name="typeadd" checked>
</td>
<td width="80">单选题</td>
<td><input type="radio" name="typeadd" disabled> </td>
<td width="80">多选题</td>
<td><input type="radio" name="typeadd" disabled> </td>
<td width="80">判断题</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" bgcolor="#E1E1E1">知 识 点</td>
<td><select name="sknow">
<option value="<%=v_kid%>" selected><%=v_kName%></option>
<%
sql = "select * from knowledge_info where KnowID<>"&v_kid&" and Sub_ID = "&sid
set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,2
do while not rs.eof
if not rs.eof then
%>
<option value="<%=rs("KnowID")%>" ><%=rs("KnowName")%></option>
<%
rs.movenext
end if
loop
%>
</select> </td>
</tr>
<tr>
<td align="center" bgcolor="#E1E1E1">难度系数</td>
<td>
<table width="100%" border="0">
<tr>
<td><div align="center">
<input type="radio" name="fdif_button" value="1" <% IF v_sdiff = "1" then
%>
checked
<%end if%>>
<span class="style1">简单</span></div></td>
<td><div align="center">
<input type="radio" name="fdif_button" value="2" <% IF v_sdiff = "2" then
%> checked <%end if%>>
<span class="style1">较易</span></div></td>
<td><div align="center">
<input name="fdif_button" type="radio" value="3" <% IF v_sdiff = "3" then
%> checked <%end if%>>
<span class="style1">中等</span></div></td>
<td><div align="center">
<input type="radio" name="fdif_button" value="4" <% IF v_sdiff = "4" then
%>
checked <%end if%>>
<span class="style1">
较难</span></div></td>
<td><div align="center">
<input type="radio" name="fdif_button" value="5" <% IF v_sdiff = "5" then
%> checked <%end if%> >
<span class="style1">困难</span></div></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" bgcolor="#E1E1E1">标 题</td>
<td align="left">
<textarea rows="3" name="question" cols="60" onBlur="this.className='inputnormal'" onFocus="this.className='inputedit';this.select()" class="inputnormal"><%=question%></textarea>
</td>
</tr>
<tr>
<td align="center" bgcolor="#E1E1E1">内 容</td>
<td>A.<input name="Option1" type="text" class="inputnormal" id="Option1" onFocus="this.className='inputedit';this.select()" onBlur="this.className='inputnormal'" value="<%=Option1%>" size="60">
<br>
B.<input name="Option2" type="text" class="inputnormal" id="Option2" onFocus="this.className='inputedit';this.select()" onBlur="this.className='inputnormal'" value="<%=Option2%>" size="60">
<br>
C.<input name="Option3" type="text" class="inputnormal" id="Option3" onFocus="this.className='inputedit';this.select()" onBlur="this.className='inputnormal'" value="<%=Option3%>" size="60">
<br>
D.<input name="Option4" type="text" class="inputnormal" id="Option4" onFocus="this.className='inputedit';this.select()" onBlur="this.className='inputnormal'" value="<%=Option4%>" size="60">
<br>
E.<input name="Option5" type="text" class="inputnormal" id="Option5" onFocus="this.className='inputedit';this.select()" onBlur="this.className='inputnormal'" value="<%=Option5%>" size="60">
<br>
F.<input name="Option6" type="text" class="inputnormal" id="Option6" onFocus="this.className='inputedit';this.select()" onBlur="this.className='inputnormal'" value="<%=Option6%>" size="60">
</td>
</tr>
<tr>
<td align="center" height="20" bgcolor="#E1E1E1">答 案</td>
<td height="20">
<input type="text" name="answer" size="20" value="<%=answer%>" onKeyUp="this.value.toUpperCase()" onBlur="this.className='inputnormal'" onFocus="this.className='inputedit';this.select()" class="inputnormal"></td>
</tr>
<tr>
<td align="center" height="20" colspan="2">
<div align="right">
<input type="hidden" value="<%=id%>" name="id">
<input type="submit" value="保存" name="B1" class="s02">
<input type="button" value="关闭窗口" name="B2" onClick="self.close()" class="s02">
</div>
</td>
</tr>
</table>
</form>
<%
end if
if typeedit="1" then
%>
<form name="adminsubjectmulti" method="post" action="admindatabasesaveedit.asp" onSubmit="return submitit();">
<input type="hidden" name="sub_id" value=<%=sid%>>
<input name="qtype" type="hidden" value="<%=typeedit%>">
<input type="hidden" name="setUserID" value="<%=v_setUserID%>">
<input type="hidden" name="currUserID" value="<%=request.Cookies("userid")%>">
<table border="1" cellpadding="2" cellspacing="1" style="border-collapse: collapse" bordercolor="#C0C0C0" width="100%" id="AutoNumber3">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -