admindatabaseedit.asp

该系统测试用户信息主要由数据库直接输入

      <b><font color="#FFFFFF">标&nbsp;&nbsp;&nbsp; 题</font></b></td>
      <td width="515" colspan="3" 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" colspan="3" 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" colspan="3" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber5" width="267">
        <tr>
          <td width="22"><span lang="en-us">&nbsp;</span>A</td>
          <td width="22">
          <input type="checkbox" name="answer1"  <%if instr(answer,"A")>0 then%>checked <%end if %>  value="A" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"><span lang="en-us">&nbsp;
          </span></td>
          <td width="22"><span lang="en-us">&nbsp; </span>B</td>
          <td width="22">
          <input type="checkbox" name="answer2" <%if instr(answer,"B")>0 then%>checked <%end if %>  value="B" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"></td>
          <td width="22"><span lang="en-us">&nbsp; </span>C</td>
          <td width="22">
          <input type="checkbox" name="answer3" <%if instr(answer,"C")>0 then%>checked <%end if %>  value="C" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"></td>
          <td width="22"><span lang="en-us">&nbsp; </span>D</td>
          <td width="22">
          <input type="checkbox" name="answer4" <%if instr(answer,"D")>0 then%>checked <%end if %>  value="D" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"></td>
          <td width="22"><span lang="en-us">&nbsp; </span>E</td>
          <td width="23">
          <input type="checkbox" name="answer5"  <%if instr(answer,"E")>0 then%>checked <%end if %> value="E" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"></td>
          <td width="23"><span lang="en-us">&nbsp; </span>F</td>
          <td width="23">
          <input type="checkbox" name="answer6" <%if instr(answer,"F")>0 then%>checked <%end if %>  value="F" onblur="this.className='inputnormal'" onfocus="this.className='inputedit';this.select()" class="inputnormal"></td>
        </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" height="19" bgcolor="#799AE1" width="121" bordercolor="#799AE1">
      <b><font color="#FFFFFF">章&nbsp;&nbsp;<span lang="en-us"> </span>&nbsp;节</font></b></td>
      <td height="19" width="320" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <span lang="en-us">&nbsp;</span><select size="1" name="chapter"><% 

	  	 sqlch="select * from tbchapter  where kcid="&kcid&" order by chapter"
      set rsch=server.createobject("adodb.recordset")
      rsch.open sqlch,conn,3,2	
       
       do while not rsch.eof %>
      <option value="<%=rsch("chapter")%>" <%if rsch("chapter")=chapter then %>selected <%end if %>>第<%=rsch("chapter")%>章</option>
      <% rsch.movenext
      loop
    
       %></select></td>
      <td height="19" width="65" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="122" bgcolor="#FFFDE8" bordercolor="#799AE1">
      &nbsp;<select size="1" name="level">
      <option <% if rs("level")="1" then %> selected <%end if %> value="1">容易</option>
      <option <% if rs("level")="2" then %> selected <%end if %> value="2">中等</option>
      <option <% if rs("level")="3" then %> selected <%end if %>  value="3">较难</option>
      <option <% if rs("level")="4" then %> selected <%end if %> value="4">最难</option>
      </select></td>
    </tr>
    <tr>
      <td align="center" height="21" colspan="4" width="640">
      <div align="right">
 
        <input type="submit" value="保存" name="B1" class="s02"><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>&nbsp;<input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02">
      </div>
      </td>
    </tr>
  </table>
 </center>
<%
end if
if typeedit="3" then
%><center>
 
  <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber3" height="210">
    <tr>
      <td width="121" align="center" bgcolor="#799AE1" height="20" bordercolor="#799AE1">
      <b><font color="#FFFFFF">当前题库</font></b></td>
      <td width="324" height="20" 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>
      </td>
      <td width="187" colspan="2" height="20" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
        <tr>
          <td width="20%" height="2">&nbsp;
          <input type="radio" name="kao" <%if kao="1"  then %> checked <%end if %> value="1"></td>
          <td width="34%" height="2">考 试</td>
          <td width="13%" height="2">
          <input type="radio" name="kao" <%if kao="0"  then %> checked <%end if %>   value="0" ></td>
          <td width="33%" height="2">练 习</td>
        </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="30" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="515" colspan="3" height="30" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="107">
        <tr>
          <td width="7">　</td>
          <td width="100">判断题</td>
          </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="5" bordercolor="#799AE1">
      <b><font color="#FFFFFF">图&nbsp;&nbsp;&nbsp; 
      片</font></b></td>
      <td width="515" colspan="3" height="5" 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="1" 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="Submit3" 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" colspan="3" 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" height="20" width="121" bordercolor="#799AE1">
      <b><font color="#FFFFFF">答&nbsp;&nbsp;&nbsp; 案</font></b></td>
      <td height="20" width="515" colspan="3" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber5" width="189">
        <tr>
          <td width="97">
          <p align="right"><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp; </span>正确</td>
          <td width="36"><input type="radio" <%if answer="Y" then %> checked <%end if %>   name="answer" value="Y"></td>
          <td width="97">
          <p align="right"><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp; </span>错误</td>
          <td width="18"><input type="radio" <%if answer="N" then %> checked <%end if %>  name="answer" value="N"></td>
        </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" height="19" bgcolor="#799AE1" width="121" bordercolor="#799AE1">
      <b><font color="#FFFFFF">章<span lang="en-us"> </span>&nbsp;&nbsp; 
      节</font></b></td>
      <td height="19" width="324" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <span lang="en-us">&nbsp;</span><select size="1" name="chapter"><% 

	  	 sqlch="select * from tbchapter  where kcid="&kcid&" order by chapter"
      set rsch=server.createobject("adodb.recordset")
      rsch.open sqlch,conn,3,2	
       
       do while not rsch.eof %>
      <option value="<%=rsch("chapter")%>" <%if rsch("chapter")=chapter then %>selected <%end if %>>第<%=rsch("chapter")%>章</option>
      <% rsch.movenext
      loop
    
       %></select></td>
      <td height="19" width="54" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="129" bgcolor="#FFFDE8" bordercolor="#799AE1">
      &nbsp;<select size="1" name="level">
      <option <% if rs("level")="1" then %> selected <%end if %> value="1">容易</option>
      <option <% if rs("level")="2" then %> selected <%end if %> value="2">中等</option>
      <option <% if rs("level")="3" then %> selected <%end if %>  value="3">较难</option>
      <option <% if rs("level")="4" then %> selected <%end if %> value="4">最难</option>
      </select></td>
    </tr>
    <tr>
      <td align="center" height="21" colspan="4" width="640">
      <div align="right">
 
        <input type="submit" value="保存" name="B1" class="s02"><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>&nbsp;<input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02">
      </div>
      </td>
    </tr>
  </table>
 </center>
<%
end if
if typeedit="6" then
%><center>
 
  <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber3" height="281">
    <tr>
      <td width="121" align="center" bgcolor="#799AE1" height="21" bordercolor="#799AE1">
      <b><font color="#FFFFFF">当前题库</font></b></td>
      <td width="317" height="21" 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>
      </td>
      <td width="194" colspan="2" height="21" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="21">
        <tr>
          <td width="20%" height="2">&nbsp;
          <input type="radio" name="kao" <%if kao="1"  then %> checked <%end if %> value="1"></td>
          <td width="34%" height="2">考 试</td>
          <td width="13%" height="2">
          <input type="radio" name="kao" <%if kao="0"  then %> checked <%end if %>   value="0" ></td>
          <td width="33%" height="2">练 习</td>
        </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="28" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="515" colspan="3" height="28" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="139">
        <tr>
          <td width="5">　</td>
          <td width="134">简答题</td>
          </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="1" bordercolor="#799AE1">
      <b><font color="#FFFFFF">图&nbsp;&nbsp;&nbsp; 
      片</font></b></td>
      <td width="515" colspan="3" height="1" 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="1" 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="Submit2" 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="80" bordercolor="#799AE1">
      <b><font color="#FFFFFF">标&nbsp;&nbsp;&nbsp; 题</font></b></td>
      <td width="515" colspan="3" height="80" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <textarea rows="6" 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" height="80" width="121" bordercolor="#799AE1">