⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admindatabaseeditread.asp

📁 该系统测试用户信息主要由数据库直接输入
💻 ASP
字号:
<!--#include file="conn.asp"-->

<%
  if session("adminname")="" then
  response.redirect "relogin.asp"
  end if
 
%>
<% 
readno=request("readno")
tmid=request("tmid")
sql="select tbtk.*,tbkc.kcm from tbtk,tbkc  where tmid="&tmid&" and tbkc.kcid=tbtk.kcid"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2

kcid=rs("kcid")
subjectview=rs("kcm")
typeedit=rs("category")
totalno=rs("ans")

       sql3="select * from tbread where tmid="&tmid&" and readno="&readno
      set rs3=server.createobject("adodb.recordset")
      rs3.open sql3,conn,3,2
question=rs3("xiaoti")
text1=rs3("a")
text2=rs3("b")
text3=rs3("c")
text4=rs3("d")
text5=rs3("e")
text6=rs3("f")
answer=trim(rs3("readans"))
level=rs3("slevel")
filename=rs3("pic")
readno=rs3("readno")
        
        sql1="select * from tbkc "
      set rs1=server.createobject("adodb.recordset")
      rs1.open sql1,conn,3,2

readno1=readno+1
%>
<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.question.value=="")
  {
    alert("标题不能为空!");
    return false;
  }
  else 
  {
    return true;
  }
}
function delxiaoti(myform)
{
  result="是否从题库中删除此题?"
  if (confirm(result))
  {
    myform.action="admindatabasedelread.asp?tmid=<%=tmid%>&readno=<%=readno%>";
    myform.submit();
  }
}

function delphoto(myform)
{
    myform.action="deletephoto.asp?flag=1&tmid=<%=tmid%>&readno=<%=readno%>";
}
function savephoto1(myform)
{
    myform.action="editupfile.asp?flag=1&tmid=<%=tmid%>&readno=<%=readno%>";
}
function nextti(myform)
{
    myform.action="admindatabaseeditread.asp?tmid=<%=tmid%>&readno=<%=readno1%>";
}
</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>当前位置:系统管理 &gt; 题库管理 &gt; 查看/编辑题目</td> 
</tr>
</table>
<form name="addform" method="POST" action="admindatabasesaveeditread.asp"  enctype="multipart/form-data">
<%
 
 
%></p><center>
 
  <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber3" height="343">
    <tr>
      <td width="121" align="center" bgcolor="#799AE1" height="20" bordercolor="#799AE1">
      <b><font color="#FFFFFF">当前题库</font></b></td>
      <td width="511" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <select size="1" name="subjectview">
        <% 
do while not rs1.eof
%><option  value="<%=rs1("kcid")%>" <%if rs1("kcm")= subjectview  then %> selected <%end if%>><%=rs1("kcm")%></option>

<%
rs1.movenext
loop %>
        </select><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		</span>&nbsp;<input type="submit" name="Submit6" value="删除此题" class="s02" onclick="delxiaoti(addform)" ></td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="25" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="515" height="25" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="149">
        <tr>
          <td width="4"> </td>
          <td width="145">阅读理解——第<font color="#FF0000"><b><%=readno%></font>/<font color="#FF0000"><%=totalno%></font></b>题</td>
          </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="41" bordercolor="#799AE1">
      <b><font color="#FFFFFF">图&nbsp;&nbsp;&nbsp; 
      片</font></b></td>
      <td width="515" height="41" bgcolor="#FFFDE8" bordercolor="#799AE1">
  


<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="425" height="1">
  <tr>
      <td align="center" id="upid" height="4" width="418">
  <input type="file" name="file1" size="30"  class="inputnormalleft" ><span lang="en-us">&nbsp;&nbsp;&nbsp;
  </span><input type="submit" name="Submit" value="提 交" class="s02" onclick="savephoto1(addform)" ><span lang="en-us">&nbsp;&nbsp;
  </span>
  <input type="submit" name="Submit5" value="删 除" class="s02" onclick="delphoto(addform)" ></td>
    </tr>
    <%if filename<>"" then %>
  <tr>
      <td align="center" id="upid" height="1" width="418">
       
     <img border="0" src="examimage/<%=filename%>"><br><%=filename%></td>
    </tr><%end if %>
</table>
  


</td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="54" bordercolor="#799AE1">
      <b><font color="#FFFFFF">标&nbsp;&nbsp;&nbsp; 题</font></b></td>
      <td width="515" height="54" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <textarea rows="4" name="question" cols="60"  onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft"><%=question%></textarea>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="96" bordercolor="#799AE1">
      <b><font color="#FFFFFF">内&nbsp;&nbsp;&nbsp; 容</font></b></td>
      <td width="515" height="96" bgcolor="#FFFDE8" bordercolor="#799AE1">A.<input type="text" name="text1" size="60" value="<%=text1%>" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"><br>
      B.<input type="text" name="text2" size="60" value="<%=text2%>" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"><br>
      C.<input type="text" name="text3" size="60" value="<%=text3%>" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"><br>
      D.<input type="text" name="text4" size="60" value="<%=text4%>" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"><br>
      E.<input type="text" name="text5" size="60" value="<%=text5%>" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"><br>
      F.<input type="text" name="text6" size="60" value="<%=text6%>" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal">  
      </td>
    </tr>
    <tr>
      <td align="center" height="20" bgcolor="#799AE1" width="121" bordercolor="#799AE1">
      <b><font color="#FFFFFF">答&nbsp;&nbsp;&nbsp; 案</font></b></td>
      <td height="20" width="515" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber5" width="247">
        <tr>
          <td width="20"><span lang="en-us">&nbsp; </span>A</td>
          <td width="20"><input type="radio" <%if answer="A" then %>checked<%end if %> name="answer" value="A"></td>
          <td width="20"><span lang="en-us">&nbsp; </span>B</td>
          <td width="20"><input type="radio" <%if answer="B" then %>checked<%end if %>  name="answer" value="B"></td>
          <td width="20"><span lang="en-us">&nbsp; </span>C</td>
          <td width="21"><input type="radio" <%if answer="C" then %>checked<%end if %> name="answer" value="C"></td>
          <td width="21"><span lang="en-us">&nbsp; </span>D</td>
          <td width="21"><input type="radio" <%if answer="D" then %>checked<%end if %> name="answer" value="D"></td>
          <td width="21"><span lang="en-us">&nbsp; </span>E</td>
          <td width="21"><input type="radio" <%if answer="E" then %>checked<%end if %> name="answer" value="E"></td>
          <td width="21"><span lang="en-us">&nbsp; </span>F</td>
          <td width="21"><input type="radio"<%if answer="F" then %>checked<%end if %>  name="answer" value="F"></td>
        </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" height="19" bgcolor="#799AE1" width="121" bordercolor="#799AE1">
      <font color="#FFFFFF"><b>难</b></font><b><font color="#FFFFFF">&nbsp;&nbsp; 
      <span lang="en-us">&nbsp;</span>度</font></b></td>
      <td height="19" width="321" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <span lang="en-us">&nbsp;</span><select size="1" name="slevel">
      <option <% if level="1" then %> selected <%end if %> value="1">容易</option>
      <option <% if level="2" then %> selected <%end if %> value="2">中等</option>
      <option <% if level="3" then %> selected <%end if %>  value="3">较难</option>
      <option <% if level="4" then %> selected <%end if %> value="4">最难</option>
      </select></td>
    </tr>
    <tr>
      <td align="center" height="21" colspan="2" width="640">
      <div align="right">
 
        <input type="submit" value="保存" name="B1" class="s02"><%if readno< cint(totalno) then%>
        <span lang="en-us">&nbsp; &nbsp;&nbsp;</span><input type="submit"  value="下一题"  onclick="nextti(addform)"  name="B3"  class="s02" size="8">
        <%end if%>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp; </span>
        <input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02">
      </div>
      </td>
    </tr>
  </table><input type="hidden" value="<%=readno%>" name="readno">
 </center>
<input type="hidden" value="1" name="flag"><input type="hidden" value="<%=tmid%>" name="tmid"><input type="hidden" value="<%=typeedit%>" name="typeadd"><input type="hidden" value="<%=typeedit%>" name="typeadd1"></form>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -