开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 教育系统应用 > 查看源码
updatetest_mn.jsp
资源名称：0102010.rar　[点击查看]
上传用户：nbluoke
上传日期：2013-08-09
资源大小：4851k
文件大小：19k
源码类别：

教育系统应用

开发平台：

WORD

updatetest_mn.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java"  errorPage="" %>
  2. <%@ page import="java.sql.*"%>
  3. <%@ page import="jinghua.*"%>
  4. <%@ page import="java.text.*"%>
  5. <%@ page import="java.util.*"%>
  6. <script language="javascript">
  8. </script>
  9. <jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
  10. </jsp:useBean>
  11. <jsp:useBean id="transString" class="jinghua.TransformString" scope="page">
  12. </jsp:useBean>
  13. <%!
  14. String questTypeID=null;
  16. boolean debug=true;
  18. int subjectID=-1;
  19. String gradeID=null;
  20. int mntestID=-1;
  22. String knowPointID1=null;
  23. String knowPointID2=null;
  24. String knowPointID3=null;
  26. StringBuffer msgsb=new StringBuffer("OK");
  28. String sql="";
  29. String temp="";
  30. int teaID=-1;
  31. int ID=-1;//新提交试题或试卷的ID
  32. Connection con=null;
  34. //生成试题分类编号
  35. public String QuestClassCode(Connection con,int SubjectID,String gradeID,
  36.         String KnowPointID,String testpoint,String QuestType,  String PostHard){
  37.   int num=0;
  38.   StringBuffer bs=new StringBuffer();
  39.   String sql="";
  40.   try{
  41.   Statement stmt=con.createStatement();
  42.   sql="select count(*) as num from question where subjectid="+SubjectID+
  43.             " and knowpointid1="+KnowPointID+
  44.             " and questtype="+ QuestType+
  45.             " and prehard='" +PostHard+"'";
  46.   ResultSet rs=stmt.executeQuery(sql);
  47.   if(rs.next()){
  48.     num=rs.getInt(1);
  49.   }
  50.   num++;
  51.   //格式化第几道题
  53.   DecimalFormat df=new DecimalFormat("00000");
  54.   String numNF=df.format(num);
  55.   //NumberFormat nf = NumberFormat.getNumberInstance ();
  56.  // nf.
  57.   //nf.setMinimumIntegerDigits(5);//整数部分最小的长度不能少于2，如果少了则补另.
  58.   //String numNF=nf.format(num);
  60.   rs.close();
  61.   stmt.close();
  62.   sql="select subject.note as sn, knowpoint.note as kn,grade.note as gn "+
  63.     " from subject,knowpoint,grade "+
  64.       "  where subject.id="+SubjectID+
  65.       " and knowpoint.id="+KnowPointID+" and grade.id="+"'"+gradeID+"'";
  66.   stmt=con.createStatement();
  68.   rs=stmt.executeQuery(sql);
  69.   if (rs.next()){
  70.     String temp;
  71.     temp=rs.getString("sn");
  72.     bs.append(temp);
  73.     bs.append(rs.getString("gn") );
  74. df=new DecimalFormat("00");
  75. temp=df.format(Integer.valueOf(testpoint));
  76.     bs.append(temp);
  77.     bs.append(QuestType);
  78.     bs.append(PostHard);
  79.     bs.append(numNF);
  80.     temp=rs.getString("kn");
  81.     bs.append(temp);
  82.     rs.close();
  83.     stmt.close();
  84.   }
  85.   }catch(Exception se){
  87.     msgsb.append(se.toString());
  88. msgsb.append("<br>"+"SQL="+sql);
  89.   }
  90.   return bs.toString();
  92. }
  95. synchronized public int submitOne(String strHtml,String answer,float mark,String difficulty,Connection con,boolean commit){
  96. //commit=true则需要在一道题提交完后，使用commit来完成提交
  97.     Statement stmt=null;
  98.     strHtml=strHtml.trim();
  99.     int tipPos=-1;
  100.     String tip="";
  101.     //检查格式：
  102.     if(strHtml.startsWith("@@")){
  103.         msgsb.append("<BR>单个试题的数据格式错误，请检查!");
  104.         return -1;
  105.     }else{
  106. //检查是否包含了文件
  108.     }
  109.     //检查答案：
  110.     if(answer.trim()==""){
  111.         msgsb.append("<BR>试题答案为空，请检查!"+"原试题为:<br>"+strHtml);
  112.         return -1;
  113.     }else if (answer.trim().length()!=1){
  114.         msgsb.append("<BR>试题答案长度不为1，请检查!"+"原试题为:<br>"+strHtml);
  115.         return -1;
  116.     }else{
  117.         String strAnswer="ABCDEFGH";
  118.         if(strAnswer.indexOf(answer)<0){
  119.             msgsb.append("<BR>单选试题的答案长度不为“ABCDEFGH”中的字符，请检查!"+"原试题为:<br>"+strHtml);
  120.             return -1;
  121.         }
  122.     }
  123.     //检查难易度
  124.     if(difficulty.trim()==""){
  125.         msgsb.append("<BR>试题难易度为空，请检查!"+"原试题为:<br>"+strHtml);
  126.         return -1;
  127.     }else if (difficulty.trim().length()!=1){
  128.         msgsb.append("<BR>试题难易度长度不为1，请检查!"+"原试题为:<br>"+strHtml);
  129.         return -1;
  130.     }else{
  131.         String strAnswer="ABCDE";
  132.         if(strAnswer.indexOf(difficulty)<0){
  133.             msgsb.append("<BR>单选难易度的答案长度不为“ABCDE”中的字符，请检查!"+"原试题为:<br>"+strHtml);
  134.             return -1;
  135.         }
  136.     }
  139.     tipPos=strHtml.indexOf("#tip");
  140.     if(tipPos>0){
  141.         tip=strHtml.substring(tipPos+4);//取提示
  142.         strHtml=strHtml.substring(0,tipPos);
  143.         tip=Tools.toSql(tip);
  144.         strHtml=Tools.toSql(strHtml);
  145.     }
  148. SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  149. String now=df.format(new java.util.Date());//当前日期
  150. answer=answer.toUpperCase();
  151.     int newID=-1;
  152.     if(!strHtml.equals("")){
  153. try{
  154.         answer.toUpperCase();
  155.         difficulty.toUpperCase();
  156. //String QuestClassType=QuestClassCode(con,subjectID, gradeID, knowPointID1,testPointID1,
  157.         //        questTypeID,   difficulty);
  158. String QuestClassType="";
  160.     if(QuestClassType==null){
  161.     msgsb.append(" Error：试题编号生成错误n"+""+QuestClassType+strHtml);
  162.     }
  163. else
  164.     {
  166.     sql="insert into question(QuestID,Mark,Answer,TeacherID,`question`.`Source`, "+
  167.         "PubDate,QuestType,SubjectID,gradenote, "+
  168. "KnowPointID1,KnowPointID2,KnowPointID3,PreHard,Tip) "+ "values("+
  169.     "'"+QuestClassType+"',"+mark+",'"+answer+"',"+teaID+",3,'"+now+"',"+
  170. questTypeID+","+subjectID+","+"'"+gradeID+"'"+","+knowPointID1+","+knowPointID2+","+knowPointID3+
  171. ",'"+difficulty+"','"+tip+"'"+")";
  174.     con.setAutoCommit(!commit);
  175. stmt=con.createStatement();
  176. stmt.executeUpdate(sql);
  177.     stmt.close();
  179.     stmt=con.createStatement();
  180.     ResultSet rs=stmt.executeQuery("select LAST_INSERT_ID() as newid from question");
  181.     if(rs.next()){
  182.     newID=rs.getInt("newID");
  183.                 rs.close();
  184.     stmt.close();
  185.     }
  186. }
  187. }//end try
  188. catch(SQLException se){
  189.     System.out.print(se);
  190.             System.out.print(sql);
  191.             msgsb.append("试题入库出错：SQL="+sql+"n"+se.toString());
  192. }catch(Exception e){
  193.             msgsb.append("试题格式可能出错 strHtml=："+strHtml);
  194. }
  195. if(newID!=-1 && msgsb.toString().equals("OK")  ) {
  196. try{//修改题干
  197. temp=jinghua.TransformString.TransformSelction(strHtml,newID);
  198. temp=Tools.toSql(temp);
  199.              if(temp==null)
  200.                 throw new Exception("题目没有数据");
  201. stmt=con.createStatement();
  202. sql="update question set QuestText='"+temp+"' where ID="+newID;
  203. stmt.executeUpdate(sql);
  204.             stmt.close();
  206. }
  207. catch(SQLException se){
  208.     System.out.print(se);
  209. msgsb.append("试题入库出错：SQL="+sql+"n"+se.toString());
  211.     }
  212.         catch(Exception se){
  213.     System.out.print(se);
  214. msgsb.append("试题入库出错："+se.toString());
  215.         }
  217. }//end if
  218.     }else{
  219.         msgsb.append("提交试题出错：试题为空");
  220.     }
  221.     return newID;
  222. }//end submitOne
  224. //@@2. My pain _____apparent the moment I walked into the room. for the first man I met asked
  225. //sympathetically: "Are you feeling all right?"
  226. // A. must be  B. had  C. must have been  D. had to be
  227. //##A ##B  ##C  ##D
  228. //@A@5@E@ :@答案@分数@难度@
  229. synchronized public int submitAll(String strHtml,String Title,Connection con,javax.servlet.jsp.JspWriter out){
  230.         if(debug){
  231.             try{
  232.             out.print("<br> submitAll input:<BR>"+ strHtml);
  233.             }catch(Exception e){}
  234.         }
  235. String [] strArray=strHtml.split("@@");//"@@"为每道试题的分隔符
  236. String [] ansMark;
  237. String temp=null;
  238. StringBuffer bs=new StringBuffer();//试题ID#答案A#分数;
  239. int newID=-1,bin=-1,end=0;
  240. int newtestID=-1;
  242.         int i=-1;
  243. String ans="";
  244. SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  245. String now=df.format(new java.util.Date());
  246. //先将所有试题提交
  247. //debug
  248. //out.println(now);
  249. //        out.print("strArray.length="+String.valueOf(strArray.length));
  251. try{
  252.             con.setAutoCommit(false);
  253.             int mark=0;
  254.             for( i=1;i<strArray.length;i++){//提交每一道试题
  255.                 if(debug){
  256.                  out.println("<br>test("+i+"):<br>"+strArray[i]);
  257.                 }
  259.              bin=strArray[i].indexOf("@");
  260.                 end=strArray[i].lastIndexOf("@");
  261.          temp=strArray[i].substring(bin+1,end+1);//答案
  262.                 ansMark=temp.split("@");
  263.                 int tippos=strArray[i].indexOf("#tip");
  264.                 String t1=strArray[i].substring(0,bin)+strArray[i].substring(tippos).trim();
  265.                 //将答案串从试题文本中删除，因为单个试题文本中没有这些信息
  266.                 //提交单个试题
  267.                     mark+=Float.parseFloat(ansMark[1]);
  268.                     try{
  269.                         newID=submitOne(t1,ansMark[0],Float.parseFloat(ansMark[1]),ansMark[2],con,true);
  271.                         if(debug && newID!=-1){
  272.                         out.println("<br>database submit success:newID="+newID);
  273.                     }
  275.                     if(newID!=-1){
  276.                         //试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  277.                         temp=String.valueOf(newID)+"@"+ansMark[0].trim() +"@"+ansMark[1].trim() +"@"+ansMark[2].trim() +"#";
  278.                      bs.append(temp);
  279.                     }else
  280.                         {
  281.                         throw new Exception("试题格式可能出错");
  282.                         }
  284.                     }catch(IllegalArgumentException ie)
  285.                     {
  286.                         msgsb.append("试题格式可能出错 test("+i+")=："+t1+temp+"<br>"+ie);
  287.                     }
  289.         }
  291.          //提交试卷
  292.         if(msgsb.toString().equals("OK")){
  293.     try{
  294.          //   sql="insert into test(id,date,testtypeid,paper,title,subid,gradeid,status,teaid,validtime,testnum) values(38,'2003-09-18 14:10:44',1,'117@A@5@A#118@B@6@B#119@C@7@C#120@D@8@E#','',1,1,2,1,3,4)";
  295.          //   con.setAutoCommit(false);
  296.          //   stmt=con.createStatement();
  297.          //   stmt.executeUpdate(sql);
  298.          //   stmt.close();
  300. //
  301.          sql="insert into test(date,testtypeid,paper,title,subid,gradenote,status,teaid,validtime,testnum,"+
  302.                 "knowpointid1,knowpointid2,knowpointid3,mark) "+
  303.             "values('"+now+"',"+"1"+",'"+bs.toString() +"','"+Title+"',"+subjectID+","+"'"+gradeID+"'"+
  304.      ","+"3"+","+teaID+","+"3"+","+(strArray.length-1) +","+
  305.                 knowPointID1+","+knowPointID2+","+knowPointID3+","+mark+")";
  307.          //缺省testtypeid=1:单一的选择题；statue=2：已经发布；status=3为模拟考试
  308.             Statement stmt=con.createStatement();
  310.             stmt.executeUpdate(sql);
  312.             stmt.close();
  313.             if(debug){
  314.                 Tools.debugmsg("<br>insert into test:SQL="+sql,out);
  315.             }
  316.             stmt=con.createStatement();
  317.             ResultSet rs=stmt.executeQuery("select LAST_INSERT_ID() as newid from question");
  319.             if(rs.next()){
  320.                 newtestID=rs.getInt("newID");
  321.                 rs.close();
  322.                 stmt.close();
  325.                 if(newtestID>0){//将这一试卷增加到mn_test表中的相应记录中去
  326.                 if(debug){
  327.                     out.print("<br>mn_testID="+mntestID);
  328.                 }
  329.                 int test_num=-1;
  330.                 String test_paper="";
  331.                 int sub_num=-1;
  332.                 String subs="";
  333. int mntotalmark=0;
  334.                 sql="select * from mn_test where id="+mntestID;
  336.                 try{
  337.                 stmt=con.createStatement();
  338.                 rs=stmt.executeQuery(sql);
  340.                 if(rs.next()){
  341.                     test_num=rs.getInt("test_num");
  342.                     test_paper=rs.getString("test_paper");
  343.                     sub_num=rs.getInt("sub_num");
  344.                     subs=rs.getString("subs");
  345. mntotalmark=rs.getInt("mntotalmark");
  346.                     if(test_paper==null){
  347.                         test_paper="";
  348.                     }
  349.                     if(subs==null){
  350.                         subs="";
  351.                     }
  352.                 }
  353.                 rs.close();
  354.                 stmt.close();
  356.                 if(debug){
  357.                     out.print("<br>mn_test:test_num="+test_num);
  358.                     out.print("<br>mn_test:test_paper="+test_paper);
  359.                     out.print("<br>mn_test:sub_num="+sub_num);
  360.                     out.print("<br>mn_test:subs="+subs);
  361.                 }
  362.                 //add test
  363. if(test_paper.equals("")){
  364.                  test_paper+=String.valueOf(newtestID);//一份试卷以","分隔
  365. }else{
  366.     test_paper+=","+String.valueOf(newtestID);//一份试卷以","分隔
  367. }
  368.                 test_num++;
  369.                 //add sub
  370.                 if(subs.indexOf(String.valueOf(subjectID))<0){//new sub
  371. mntotalmark+=mark;
  372. if(subs.equals("")){
  373. subs+=String.valueOf(subjectID);
  374. }else{
  375.                     subs+=","+String.valueOf(subjectID);
  376. }
  377.                     sub_num++;
  378.                 }
  380.                  if(debug){
  381.                     out.print("<br>mn_test:test_num="+test_num);
  382.                     out.print("<br>mn_test:test_paper="+test_paper);
  383.                     out.print("<br>mn_test:sub_num="+sub_num);
  384.                     out.print("<br>mn_test:subs="+subs);
  385.                 }
  386.                 sql=" update mn_test set testpeople= 0, test_num="+test_num+",test_paper='"+test_paper+"' ,"+
  387.                     " sub_num="+sub_num+",subs='"+subs+"',"+
  388. " mntotalmark="+mntotalmark+
  389.                     " where id="+mntestID;
  390.                 stmt=con.createStatement();
  391.                 stmt.executeUpdate(sql);
  392.                 sql="delete from mn_history where mn_test_id="+mntestID;
  393.                 stmt=con.createStatement();
  394.                 stmt.executeUpdate(sql);
  396.                 }catch(SQLException se){
  397.                     out.print("<BR>update mn_test error: sql="+sql);
  398.                     out.print("<BR>"+se.toString());
  399.                     msgsb.append("update mn_test error: sql="+sql);
  400.                     try{
  401.                 con.rollback();
  402.                     }catch(Exception e1){
  403.                         msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  404.                     }
  405.                 }
  406.                 catch(Exception e){
  407.                     out.print("<BR>update mn_test error: sql="+sql);
  408.                     out.print("<BR>"+e.toString());
  409.                     msgsb.append("update mn_test error: sql="+sql);
  410.                     try{
  411.                 con.rollback();
  412.                     }catch(Exception e1){
  413.                     msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  414.                     }
  415.                 }
  417.             }
  419.             }
  421.             con.commit();
  422.             if(debug){
  423.                 out.print("<br> new test ID is:"+newtestID);
  427.                 stmt=con.createStatement();
  428.                 rs=stmt.executeQuery("select id,paper,title from test where id="+newtestID);
  430.                 if (rs.next()){
  431.                     Tools.debugmsg("<br> the newest paper is:"+rs.getString("paper"),out);
  432.                     Tools.debugmsg("<br> the title of the paper is:"+rs.getString("title"),out);
  433.                 }
  434.                 rs.close();
  435.                 stmt.close();
  436.             }
  438.         }
  439.     catch(SQLException e){
  440.             try{
  441.         con.rollback();
  442.             }catch(Exception e1){
  443.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  444.             }
  445.             msgsb.append("insert Error：SQL="+sql+"n"+e.toString());
  447.     }
  448.         catch(Exception e){
  449.             try{
  450.         con.rollback();
  451.             }catch(Exception e1){
  452.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  453.             }
  454.             msgsb.append("insert Error：SQL="+sql+"n"+e.toString());
  456.     }
  458. }else{
  459.             try{
  460.             con.rollback();
  461.             }catch(Exception e2){
  462.                 msgsb.append("rollback：SQL="+sql+"n"+e2.toString());
  463.             }
  464.             msgsb.append("Single test is error i="+i);
  465. }
  467. }catch(Exception e){
  468.             try{
  469.         con.rollback();
  470.             }catch(Exception e1){
  471.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  472.             }
  473.             msgsb.append("<br>Batch submit Errorn"+
  474.                 "<br>strArray["+i+"]="+strArray[i]+"<br>"+e.toString() );
  475.            Tools.debugmsg("<br>i="+i,out);
  477. }
  478. return newtestID;
  480. }
  481. %>
  487. <html>
  488. <head>
  489. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  490. <title>试题提交</title>
  491. </head>
  493. <body>`
  496. <%
  497. try{
  498. //UN_debug
  499. msgsb.delete(0,msgsb.length() );
  500. msgsb.append("OK");
  503. try{
  504.     String TeacherID=(String)session.getAttribute("teacherID");
  505.     //Tools.showalert("teaID="+TeacherID,out);
  506.     //Tools.showalert("msgdb="+msgsb.toString(),out);
  507.     //Tools.showalert(TeacherID,out);
  508.     teaID=Integer.parseInt(TeacherID);
  509. }catch(Exception e){
  510.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  511.     response.sendRedirect("../login.jsp");
  512.     msgsb.append("teacherID Errorn");
  513.     Tools.showJS("window.open('../login.jsp','_self')",out);
  514.     //response.sendRedirect("../login.jsp");
  515.     Tools.goback(out);
  516. }
  519. if (msgsb.toString().equals("OK"))
  520. {
  521. questTypeID=""+request.getParameter("QuestType");//试题类型ID
  522. subjectID=Integer.parseInt(request.getParameter("Subject"));//科目ID
  523. gradeID=""+request.getParameter("Grade");//年级ID
  524. mntestID=Integer.parseInt(request.getParameter("mntest"));//模拟考试ID
  525. knowPointID1=""+request.getParameter("KnowPoint1");//知识点ID
  526. knowPointID2=""+request.getParameter("KnowPoint2");//知识点ID
  527. knowPointID3=""+request.getParameter("KnowPoint3");//知识点ID
  529. String strHtml=""+request.getParameter("Content");//获取提交的试题的HTML
  530. //debug
  532. con=DBCon.getConnection();
  534. //
  535. strHtml=Tools.codestring(strHtml);//转换字符集
  537. String group=""+request.getParameter("group");
  540. if(group.equals("single")){//提交单个试题
  541. //ID=submitOne(strHtml,answer,mark,difficulty,con,false);
  543. }else{
  544. if(group.equals("suit") ){
  545.     String Title=""+request.getParameter("suit_title");
  546.             Title=Tools.codestring(Title);
  547.             ID=submitAll(strHtml,Title,con,out);
  549. }
  550. }
  552. %>
  553. <%temp=msgsb.toString();
  554. if(debug){
  555.     out.print("<br><br><br>New Information");
  556.     out.print(temp);
  557. }
  560. if(temp.equals("OK")){
  561. //提交成功
  562.         if(group.equals("single")){//提交单个试题
  563.             Tools.showalert(" 试题提交成功,新的试题ID为："+ID,out);
  564.             Tools.goback(out);
  566.         }else if(group.equals("suit")){
  567.             Tools.showalert(" 试卷提交成功,新的试卷ID为："+ID,out);
  568.             Tools.goback(out);
  570.         }
  574. %>
  576. <%
  577. }
  578. else{
  579. System.out.print(msgsb.toString());
  580. %>
  581. <SCRIPT language="javascript">
  582. alert("试题未能提交成功，请检查提交信息或与系统管理员联系");
  583. //history.go(-1);
  584. </SCRIPT>
  585. <%
  586. }
  587. %>
  593. </body>
  594. </html>
  595. <%
  596. }
  597. %>
  599. <%}
  600. catch(Exception e){
  601.     System.out.print(e.toString());
  602. }
  603. finally{
  604.     DBCon.dropConnection();
  605. }
  606. %>