admindatabaseedit.asp

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

  </span><input type="submit" name="Submit" value="提 交" class="s02" onclick="savephoto1(addform)" ><span lang="en-us">&nbsp;&nbsp;
  </span>
  <input type="submit" name="Submit6" value="删 除" class="s02" onclick="delphoto(addform)" ></td>
    </tr>
    <%if filename<>"" then %>
  <tr>
      <td align="center" id="upid" height="14" 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="57"  onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft"><%=question%></textarea>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" height="54" width="121" bordercolor="#799AE1">
      <b><font color="#FFFFFF">答&nbsp;&nbsp;&nbsp; 案</font></b></td>
      <td height="54" width="515" colspan="3" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <textarea rows="4" name="answer" cols="57"  onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft"><%=answer%></textarea></td>
    </tr>
    <tr>
      <td align="center" height="19" bgcolor="#799AE1" width="121" bordercolor="#799AE1">
      <b><font color="#FFFFFF">章&nbsp;&nbsp; 
      <span lang="en-us">&nbsp;</span>节</font></b></td>
      <td height="19" width="323" 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="64" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="120" 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="4" then
%></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="321" 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="190" colspan="2" height="20" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="16">
        <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="25" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="515" colspan="3" height="25" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="89">
        <tr>
          <td width="4">　</td>
          <td width="85">单选题</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" colspan="3" 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" 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="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">
      <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="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="74" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="112" 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>
        <input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02">
      </div>
      </td>
    </tr>
  </table>
 </center>
<%
end if
if typeedit="5" then
%><center>
 
  <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber3" height="334">
    <tr>
      <td width="121" align="center" bgcolor="#799AE1" height="20" bordercolor="#799AE1">
      <b><font color="#FFFFFF">当前题库</font></b></td>
      <td width="320" 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="191" 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="24" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="515" colspan="3" height="24" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="110">
        <tr>
          <td width="5">　</td>
          <td width="105">多选题</td>
          </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="121" height="33" bordercolor="#799AE1">
      <b><font color="#FFFFFF">图&nbsp;&nbsp;&nbsp; 
      片</font></b></td>
      <td width="515" colspan="3" height="33" 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="9" 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="Submit4" 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">