📄 questionchange.jsp

📁 jsp在线考试系统
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.Math.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%@ include file="/public/checkvalidadmin.jsp"%>
<%@ include file="/public/checkvalidadmin8.jsp"%>

<%!
String id = "";
String sql = "";
ResultSet rs = null;
ResultSet rs1 = null;


int tmpquestionid ;
String currpage = "1";            // 在连续的几个页面中，一直保存当前页面，便于用户操作

int tmp_questionid;
String tmp_qname;
String tmp_choice1;
String tmp_choice2;
String tmp_choice3;
String tmp_choice4;
int tmp_selectid;
String tmp_classid;
String tmp_answer;

String tmp1_classname;
String tmp1_classid;
%>
<html>

<head>
<title>题目信息修改</title>
    <link rel="stylesheet" href="../public/style.css">
	<script language="javascript">
	// 函数mycheck()的作用是验证用户修改题库信息的正确性
	function mycheck() {
		var tmp_selectid = document.myform.selectid.selectedIndex;
		var tmp_answer   = document.myform.answer.value;
        var tmp_choice1  = document.myform.choice1.value;
        var tmp_choice2  = document.myform.choice2.value;
        var tmp_choice3  = document.myform.choice3.value;
        var tmp_choice4  = document.myform.choice4.value;

        if(document.myform.qname.value == "") {
		    alert("请输入题目！");
			return;
		}
        if(tmp_choice1.length==0 || tmp_choice2.length==0 || tmp_choice3.length==0 || tmp_choice4.length==0 ) {
		    alert("请输入各个选项！");
			return;
		}
        if(tmp_answer.length == 0) {
		    alert("请选择题目答案！");
			return;
		}
		if(tmp_selectid==0 && tmp_answer.length>1) {
		    alert("单选题的答案应该唯一！");
			return;
		}
        if(tmp_answer.length > 4) {
		    alert("多选题最多4个答案！");
			return;
		}
		document.myform.submit();
	}
	</script>
</head>
<%
currpage   = request.getParameter("Page");

sql = "select * from test_classinfo";
try {
   rs1 = conn.executeQuery( sql );
}catch(Exception e) {
   out.println("访问课程信息数据出错！");
   return;
}
if(!rs1.next()) {
   out.println("系统数据库中无课程信息数据！");
   return;
}


id = request.getParameter("id");
sql = "SELECT * from test_question_lib where questionid=" + id;

try {
   rs = conn.executeQuery( sql );
}catch(Exception ee) {
   out.println("访问数据库错误！");
   return;
}

if(!rs.next()) {
	out.println("错误的ID号");
	return;
}else {

tmp_questionid = rs.getInt("questionid");
tmp_selectid = rs.getInt("selectid");
tmp_classid = rs.getString("classid");
tmp_qname = rs.getString("qname");
tmp_choice1 = rs.getString("choice1");
tmp_choice2 = rs.getString("choice2");
tmp_choice3 = rs.getString("choice3");
tmp_choice4 = rs.getString("choice4");
tmp_answer = rs.getString("answer");

tmp1_classid = rs1.getString("classid");
tmp1_classname = rs1.getString("classname");

%>

<center>
<form name="myform" action="questionsavemodify.jsp" method="post">
	<input type="hidden" name="Page" value="<%=currpage%>">
	<table width="90%" HEIGHT=100% border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
	  <tr bgcolor="#FAD185"> 
		<%
		tmpquestionid = tmp_questionid;
	    %>
		<td colspan=6 height=20 align=center><b>题目信息修改==>题目编号：<%=tmpquestionid%></b></td>
		<input type="hidden" name="questionid" value="<%=tmpquestionid%>">
	  </tr>
      
	  <tr> 
		<td colspan=6 valign=top>
		<textarea name="qname" rows=20 cols=150><%=tmp_qname%></textarea></td>
	  </tr>
      <tr>
		  <td width=10%>选项A</td>
		  <td colspan=5><textarea name="choice1" rows=2 cols=135><%=tmp_choice1%></textarea></td>
	  </tr>
      <tr>
		  <td>选项B</td>
		  <td colspan=5><textarea name="choice2" rows=2 cols=135><%=tmp_choice2%></textarea></td>
	  </tr>
      <tr>
		  <td>选项C</td>
		  <td colspan=5><textarea name="choice3" rows=2 cols=135><%=tmp_choice3%></textarea></td>
	  </tr>
      <tr>
		  <td>选项D</td>
		  <td colspan=5><textarea name="choice4" rows=2 cols=135><%=tmp_choice4%></textarea></td>
	  </tr>

	
      <tr>
		  <td>题目类别</td>
		  <td>
		 <!--以下这一段出现问题：java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引-->


	
		

		  <select name="selectid">
		  <%
			  
		    int tmpselectid = tmp_selectid;
			if(tmpselectid==1) {
		        out.println("<option value=1 selected>单选题</option>");
		        out.println("<option value=2>多选题</option>");
			 }else {
		        out.println("<option value=1>单选题</option>");
		        out.println("<option value=2 selected>多选题</option>");
			 }
			 
	      %>
          </select>
		  </td>
		  <td>对应班级</td>
		  <td>
		  
	  <select name="classid">
				
				    <%
						
				        String currClassId = tmp_classid;
				        do{
				            
				        	String classname = tmp1_classname;
				        	String classid = tmp1_classid;
							
				    %>
				        	<option value=<%=classid%>   <%if(classid.equals(currClassId)) out.println("selected");%> ><%=classname%> </option>
				    <%
				        }while(rs1.next());
				    %> 

          </select>
		 
		  <!--以上这一段出现问题 -->
		 
		  </td>
		  <td>答案</td>
		  <td><input type=text title="输入答案时请按照字母次序进行输入,例如：AB / ABD" name=answer value=<%=tmp_answer%>></td>
	  </tr>
	 


      <tr>
		  <td align=center colspan=6>
		      <input type="button" value="保存所做修改" onclick="mycheck()">&nbsp;&nbsp;&nbsp;
	          <input type="button" value="返回上一页面" onclick=javascript:history.back()>
		  </td>
	  </tr>
	</table>
<%
}
%>
</form>
</center>
</html>
💿 文件大小 96 K
👤 上传用户 wjm197811
📂 所属分类 MySQL数据库
🏷️ 相关标签

#jsp
⌨️ 快捷键说明

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