updatetest_mn.jsp

本系统是一个在线考试系统

                knowPointID1+","+knowPointID2+","+knowPointID3+","+mark+")";

	    	    //缺省testtypeid=1:单一的选择题；statue=2：已经发布；status=3为模拟考试
            Statement stmt=con.createStatement();

            stmt.executeUpdate(sql);

            stmt.close();
            if(debug){
                Tools.debugmsg("<br>insert into test:SQL="+sql,out);
            }
            stmt=con.createStatement();
            ResultSet rs=stmt.executeQuery("select LAST_INSERT_ID() as newid from question");

            if(rs.next()){
                newtestID=rs.getInt("newID");
                rs.close();
                stmt.close();


                if(newtestID>0){//将这一试卷增加到mn_test表中的相应记录中去
                if(debug){
                    out.print("<br>mn_testID="+mntestID);
                }
                int test_num=-1;
                String test_paper="";
                int sub_num=-1;
                String subs="";
				int mntotalmark=0;
                sql="select * from mn_test where id="+mntestID;

                try{
                stmt=con.createStatement();
                rs=stmt.executeQuery(sql);

                if(rs.next()){
                    test_num=rs.getInt("test_num");
                    test_paper=rs.getString("test_paper");
                    sub_num=rs.getInt("sub_num");
                    subs=rs.getString("subs");
					mntotalmark=rs.getInt("mntotalmark");
                    if(test_paper==null){
                        test_paper="";
                    }
                    if(subs==null){
                        subs="";
                    }
                }
                rs.close();
                stmt.close();

                if(debug){
                    out.print("<br>mn_test:test_num="+test_num);
                    out.print("<br>mn_test:test_paper="+test_paper);
                    out.print("<br>mn_test:sub_num="+sub_num);
                    out.print("<br>mn_test:subs="+subs);
                }
                //add test
				if(test_paper.equals("")){
                	test_paper+=String.valueOf(newtestID);//一份试卷以","分隔
				}else{
				    test_paper+=","+String.valueOf(newtestID);//一份试卷以","分隔
				}
                test_num++;
                //add sub
                if(subs.indexOf(String.valueOf(subjectID))<0){//new sub
					mntotalmark+=mark;
					if(subs.equals("")){
						subs+=String.valueOf(subjectID);
					}else{
	                    subs+=","+String.valueOf(subjectID);
					}
                    sub_num++;
                }

                 if(debug){
                    out.print("<br>mn_test:test_num="+test_num);
                    out.print("<br>mn_test:test_paper="+test_paper);
                    out.print("<br>mn_test:sub_num="+sub_num);
                    out.print("<br>mn_test:subs="+subs);
                }
                sql=" update mn_test set testpeople= 0, test_num="+test_num+",test_paper='"+test_paper+"' ,"+
                    " sub_num="+sub_num+",subs='"+subs+"',"+
					" mntotalmark="+mntotalmark+
                    " where id="+mntestID;
                stmt=con.createStatement();
                stmt.executeUpdate(sql);
                sql="delete from mn_history where mn_test_id="+mntestID;
                stmt=con.createStatement();
                stmt.executeUpdate(sql);

                }catch(SQLException se){
                    out.print("<BR>update mn_test error: sql="+sql);
                    out.print("<BR>"+se.toString());
                    msgsb.append("update mn_test error: sql="+sql);
                    try{
		                con.rollback();
                    }catch(Exception e1){
                        msgsb.append("<BR>rollbackcbd：SQL="+sql+"\n"+e1.toString());
                    }
                }
                catch(Exception e){
                    out.print("<BR>update mn_test error: sql="+sql);
                    out.print("<BR>"+e.toString());
                    msgsb.append("update mn_test error: sql="+sql);
                    try{
		                con.rollback();
                    }catch(Exception e1){
                    msgsb.append("<BR>rollbackcbd：SQL="+sql+"\n"+e1.toString());
                    }
                }

            }

            }

            con.commit();
            if(debug){
                out.print("<br> new test ID is:"+newtestID);



                stmt=con.createStatement();
                rs=stmt.executeQuery("select id,paper,title from test where id="+newtestID);

                if (rs.next()){
                    Tools.debugmsg("<br> the newest paper is:"+rs.getString("paper"),out);
                    Tools.debugmsg("<br> the title of the paper is:"+rs.getString("title"),out);
                }
                rs.close();
                stmt.close();
            }

        }
	    catch(SQLException e){
            try{
		        con.rollback();
            }catch(Exception e1){
                msgsb.append("<BR>rollbackcbd：SQL="+sql+"\n"+e1.toString());
            }
            msgsb.append("insert Error：SQL="+sql+"\n"+e.toString());

	    }
        catch(Exception e){
            try{
		        con.rollback();
            }catch(Exception e1){
                msgsb.append("<BR>rollbackcbd：SQL="+sql+"\n"+e1.toString());
            }
            msgsb.append("insert Error：SQL="+sql+"\n"+e.toString());

	    }

	}else{
            try{
            con.rollback();
            }catch(Exception e2){
                msgsb.append("rollback：SQL="+sql+"\n"+e2.toString());
            }
            msgsb.append("Single test is error i="+i);
	}

	}catch(Exception e){
            try{
		        con.rollback();
            }catch(Exception e1){
                msgsb.append("<BR>rollbackcbd：SQL="+sql+"\n"+e1.toString());
            }
            msgsb.append("<br>Batch submit Error\n"+
                "<br>strArray["+i+"]="+strArray[i]+"<br>"+e.toString() );
           Tools.debugmsg("<br>i="+i,out);

	}
	return newtestID;

}
%>





<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>试题提交</title>
</head>

<body>`


<%
try{
//UN_debug
msgsb.delete(0,msgsb.length() );
msgsb.append("OK");


try{
    String TeacherID=(String)session.getAttribute("teacherID");
    //Tools.showalert("teaID="+TeacherID,out);
    //Tools.showalert("msgdb="+msgsb.toString(),out);
    //Tools.showalert(TeacherID,out);
    teaID=Integer.parseInt(TeacherID);
}catch(Exception e){
    Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
    response.sendRedirect("../login.jsp");
    msgsb.append("teacherID Error\n");
    Tools.showJS("window.open('../login.jsp','_self')",out);
    //response.sendRedirect("../login.jsp");
	    Tools.goback(out);
}


if (msgsb.toString().equals("OK"))
{
questTypeID=""+request.getParameter("QuestType");//试题类型ID
subjectID=Integer.parseInt(request.getParameter("Subject"));//科目ID
gradeID=""+request.getParameter("Grade");//年级ID
mntestID=Integer.parseInt(request.getParameter("mntest"));//模拟考试ID
knowPointID1=""+request.getParameter("KnowPoint1");//知识点ID
knowPointID2=""+request.getParameter("KnowPoint2");//知识点ID
knowPointID3=""+request.getParameter("KnowPoint3");//知识点ID

String strHtml=""+request.getParameter("Content");//获取提交的试题的HTML
//debug

con=DBCon.getConnection();

//
strHtml=Tools.codestring(strHtml);//转换字符集

String group=""+request.getParameter("group");


if(group.equals("single")){//提交单个试题
	//ID=submitOne(strHtml,answer,mark,difficulty,con,false);

}else{
	if(group.equals("suit")	){
	    String Title=""+request.getParameter("suit_title");
            Title=Tools.codestring(Title);
            ID=submitAll(strHtml,Title,con,out);

	}
}

%>
<%temp=msgsb.toString();
if(debug){
    out.print("<br><br><br>New Information");
    out.print(temp);
}


	if(temp.equals("OK")){
		//提交成功
        if(group.equals("single")){//提交单个试题
            Tools.showalert(" 试题提交成功,新的试题ID为："+ID,out);
            Tools.goback(out);

        }else if(group.equals("suit")){
            Tools.showalert(" 试卷提交成功,新的试卷ID为："+ID,out);
            Tools.goback(out);

        }



%>

<%
	}
	else{
		System.out.print(msgsb.toString());
%>
		<SCRIPT language="javascript">
			alert("试题未能提交成功，请检查提交信息或与系统管理员联系");
			//history.go(-1);
		</SCRIPT>
<%
	}
%>





</body>
</html>
<%
}
%>

<%}
catch(Exception e){
    System.out.print(e.toString());
}
finally{
    DBCon.dropConnection();
}
%>