admindatabaseedit.asp

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

      <b><font color="#FFFFFF">答&nbsp;&nbsp;&nbsp; 案</font></b></td>
      <td height="80" width="515" colspan="3" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <textarea rows="6" name="answer" cols="60"  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"> </span>&nbsp;节</font></b></td>
      <td height="19" width="317" 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="63" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="127" 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="7" then
%><center>
 
  <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber3" height="305">
    <tr>
      <td width="122" align="center" bgcolor="#799AE1" height="21" bordercolor="#799AE1">
      <b><font color="#FFFFFF">当前题库</font></b></td>
      <td width="316" 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="122" height="26" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="514" colspan="3" height="26" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="139">
        <tr>
          <td width="4">　</td>
          <td width="135">论述题</td>
          </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="122" height="17" bordercolor="#799AE1">
      <b><font color="#FFFFFF">图&nbsp;&nbsp;&nbsp; 
      片</font></b></td>
      <td width="514" colspan="3" height="17" 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="Submit1" 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="122" height="80" bordercolor="#799AE1">
      <b><font color="#FFFFFF">标&nbsp;&nbsp;&nbsp; 题</font></b></td>
      <td width="514" 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="122" bordercolor="#799AE1">
      <b><font color="#FFFFFF">答&nbsp;&nbsp;&nbsp; 案</font></b></td>
      <td height="80" width="514" colspan="3" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <textarea rows="6" name="answer" cols="60"  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="122" bordercolor="#799AE1">
      <b><font color="#FFFFFF">章&nbsp;<span lang="en-us"> </span>&nbsp; 
      节</font></b></td>
      <td height="19" width="316" 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="63" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="127" 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="8" then
%><center>
 
  <table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" width="100%" id="AutoNumber3" height="305">
    <tr>
      <td width="122" align="center" bgcolor="#799AE1" height="21" bordercolor="#799AE1">
      <b><font color="#FFFFFF">当前题库</font></b></td>
      <td width="316" 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> <span lang="en-us">&nbsp;&nbsp;&nbsp;  <font color="#FF0000"><%=request("success")%></font> </span>
      </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="122" height="26" bordercolor="#799AE1">
      <b><font color="#FFFFFF">类<span lang="en-us">&nbsp;&nbsp;&nbsp;
      </span>型</font></b></td>
      <td width="514" colspan="3" height="26" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber4" width="139">
        <tr>
          <td width="4">　</td>
          <td width="135">阅读理解——共<font color="#FF0000"><b><%=answer%></b></font>题</td>
          </tr>
      </table>
      </td>
    </tr>
    <tr>
      <td align="center" bgcolor="#799AE1" width="122" height="17" bordercolor="#799AE1">
      <b><font color="#FFFFFF">图&nbsp;&nbsp;&nbsp; 
      片</font></b></td>
      <td width="514" colspan="3" height="17" 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="Submit1" 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="122" height="80" bordercolor="#799AE1">
      <b><font color="#FFFFFF">文&nbsp;&nbsp;&nbsp; 章</font></b></td>
      <td width="514" colspan="3" height="80" bgcolor="#FFFDE8" bordercolor="#799AE1">
      <textarea rows="13" name="question" cols="60"  onblur="this.className='inputnormalleft'" onfocus="this.className='inputedit';this.select()" class="inputnormalleft"><%=question%></textarea>
      </td>
    </tr>
    <tr>
      <td align="center" height="19" bgcolor="#799AE1" width="122" bordercolor="#799AE1">
      <b><font color="#FFFFFF">章&nbsp;<span lang="en-us"> </span>&nbsp; 
      节</font></b></td>
      <td height="19" width="316" 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="63" bgcolor="#799AE1" bordercolor="#799AE1">
      <p align="center"><b><font color="#FFFFFF">难&nbsp; 度</font></b></td>
      <td height="19" width="127" 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">
        <% if answer<>0 then%><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </span>     
        <input type="submit"  value="查看题目"  onclick="editxiaoti(addform)"  name="B3"  class="s02" size="8">
        <%end if%>
        <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;
        </span>&nbsp;<input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02">
      </div>
      </td>
    </tr>
  </table>
</center><input type="hidden" value="1" name="readno"> 
<%
end if

%><input type="hidden" value="<%=typeedit%>" name="typeadd"><input type="hidden" value="<%=typeedit%>" name="typeadd1"></form>
</body>

</html>