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

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

教育系统应用

开发平台：

WORD

updatetest_free.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. String JH_Tools=null;
  21. String difficulty=null;
  22. String knowPointID1=null;
  23. String knowPointID2=null;
  24. String knowPointID3=null;
  25. String answer=null;
  26. StringBuffer msgsb=new StringBuffer("OK");
  27. Statement stmt=null;
  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
  99.     strHtml=strHtml.trim();
  100.     int tipPos=-1;
  101.     String tip="";
  102.     //检查格式：
  103.     if(strHtml.startsWith("@@")){
  104.         msgsb.append("<BR>单个试题的数据格式错误，请检查!");
  105.         return -1;
  106.     }else{
  107. //检查是否包含了文件
  109.     }
  110.     //检查答案：
  111.     if(answer.trim()==""){
  112.         msgsb.append("<BR>试题答案为空，请检查!"+"原试题为:<br>"+strHtml);
  113.         return -1;
  114.     }else if (answer.trim().length()!=1){
  115.         msgsb.append("<BR>试题答案长度不为1，请检查!"+"原试题为:<br>"+strHtml);
  116.         return -1;
  117.     }else{
  118.         String strAnswer="ABCDEFGH";
  119.         if(strAnswer.indexOf(answer)<0){
  120.             msgsb.append("<BR>单选试题的答案长度不为“ABCDEFGH”中的字符，请检查!"+"原试题为:<br>"+strHtml);
  121.             return -1;
  122.         }
  123.     }
  124.     //检查难易度
  125.     if(difficulty.trim()==""){
  126.         msgsb.append("<BR>试题难易度为空，请检查!"+"原试题为:<br>"+strHtml);
  127.         return -1;
  128.     }else if (difficulty.trim().length()!=1){
  129.         msgsb.append("<BR>试题难易度长度不为1，请检查!"+"原试题为:<br>"+strHtml);
  130.         return -1;
  131.     }else{
  132.         String strAnswer="ABCDE";
  133.         if(strAnswer.indexOf(difficulty)<0){
  134.             msgsb.append("<BR>单选难易度的答案长度不为“ABCDE”中的字符，请检查!"+"原试题为:<br>"+strHtml);
  135.             return -1;
  136.         }
  137.     }
  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,1,
  157.         //        questTypeID,   difficulty);
  158.         String QuestClassType="";
  160.     if(QuestClassType==null){
  161.     msgsb.append(" Error：试题编号生成错误n"+""+QuestClassType+strHtml);
  162.     }
  163. else
  164.     {
  165.             //source=1为自由测试
  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+",1,'"+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("题目没有数据");
  202. stmt=con.createStatement();
  203. sql="update question set QuestText='"+temp+"' where ID="+newID;
  204. stmt.executeUpdate(sql);
  205.             stmt.close();
  207. }
  208. catch(SQLException se){
  209.     System.out.print(se);
  210. msgsb.append("试题入库出错：SQL="+sql+"n"+se.toString());
  212.     }
  213.         catch(Exception se){
  214.     System.out.print(se);
  215. msgsb.append("试题入库出错："+se.toString());
  216.         }
  218. }//end if
  219.     }else{
  220.         msgsb.append("提交试题出错：试题为空");
  221.     }
  222.     return newID;
  223. }//end submitOne
  225. //@@2. My pain _____apparent the moment I walked into the room. for the first man I met asked
  226. //sympathetically: "Are you feeling all right?"
  227. // A. must be  B. had  C. must have been  D. had to be
  228. //##A ##B  ##C  ##D
  229. //@A@5@E@ :@答案@分数@难度@
  230. synchronized public int submitAll(String strHtml,String Title,Connection con,javax.servlet.jsp.JspWriter out){
  231.         if(debug){
  232.             try{
  233.             out.print("<br> submitAll input:<BR>"+ strHtml);
  234.             }catch(Exception e){}
  235.         }
  236. String [] strArray=strHtml.split("@@");
  237. String [] ansMark;
  238. String temp=null;
  239. StringBuffer bs=new StringBuffer();//试题ID#答案A#分数;
  240. int newID=-1,bin=-1,end=0;
  241. 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));
  250. //        if (debug){
  251. //            for(i=0;i<strArray.length;i++){
  252. //                Tools.debugmsg("<br>strArray["+i+"]="+strArray[i]+"<br>",out);
  253. //            }
  254. //        }
  256. try{
  257.             con.setAutoCommit(false);
  258.             int mark=0;
  259.             for( i=1;i<strArray.length;i++){//提交每一道试题
  260.                 if(debug){
  261.                  out.println("<br>test("+i+"):<br>"+strArray[i]);
  262.                 }
  264.              bin=strArray[i].indexOf("@");
  265.                 end=strArray[i].lastIndexOf("@");
  266.          temp=strArray[i].substring(bin+1,end+1);//答案
  267.                 ansMark=temp.split("@");
  268.                 int tippos=strArray[i].indexOf("#tip");
  269.                 String t1=strArray[i].substring(0,bin)+strArray[i].substring(tippos).trim();
  270.                 //将答案串从试题文本中删除，因为单个试题文本中没有这些信息
  271.                 //提交单个试题
  272.                 mark+=Float.parseFloat(ansMark[1]);
  273.                 try{
  274.                     newID=submitOne(t1,ansMark[0],Float.parseFloat(ansMark[1]),ansMark[2],con,true);
  275.                     if(debug && newID!=-1){
  276.                         out.println("<br>database submit success:newID="+newID);
  277.                     }
  279.                     if(newID!=-1){
  280.                         //试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  281.                         temp=String.valueOf(newID)+"@"+ansMark[0].trim() +"@"+ansMark[1].trim() +"@"+ansMark[2].trim() +"#";
  282.                      bs.append(temp);
  283.                     }else
  284.                         {
  285.                         throw new Exception("试题格式可能出错");
  286.                         }
  288.                 }catch(IllegalArgumentException ie)
  289.                     {
  290.                         msgsb.append("试题格式可能出错 test("+i+")=："+t1+temp+"<br>"+ie);
  291.                         out.print("<br>"+msgsb.toString());
  292.                     }
  297.         }
  299.          //提交试卷
  300.         if(msgsb.toString().equals("OK")){
  301.     try{
  302.          //   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)";
  303.          //   con.setAutoCommit(false);
  304.          //   stmt=con.createStatement();
  305.          //   stmt.executeUpdate(sql);
  306.          //   stmt.close();
  308. //status=4:自由组题
  309.          sql="insert into test(date,testtypeid,paper,title,subid,gradenote,status,teaid,validtime,testnum,"+
  310.                 "knowpointid1,knowpointid2,knowpointid3,mark) "+
  311.             "values('"+now+"',"+"1"+",'"+bs.toString() +"','"+Title+"',"+subjectID+","+"'"+gradeID+"'"+
  312.      ","+"4"+","+teaID+","+"3"+","+(strArray.length-1) +","+
  313.                 knowPointID1+","+knowPointID2+","+knowPointID3+","+mark+")";
  315.          //缺省testtypeid=1:单一的选择题；statue=2：已经发布；validtiem=3:有效期为3年
  316.             Statement stmt=con.createStatement();
  318.             stmt.executeUpdate(sql);
  320.             stmt.close();
  321.             if(debug){
  322.                 Tools.debugmsg("<br>insert into test:SQL="+sql,out);
  323.             }
  324.             stmt=con.createStatement();
  325.             ResultSet rs=stmt.executeQuery("select LAST_INSERT_ID() as newid from question");
  327.             if(rs.next()){
  328.                 newtestID=rs.getInt("newID");
  329.                 rs.close();
  330.                 stmt.close();
  331.             }
  333.             con.commit();
  334.             if(debug){
  335.                 out.print("<br> new test ID is:"+newtestID);
  339.                 stmt=con.createStatement();
  340.                 rs=stmt.executeQuery("select id,paper,title from test where id="+newtestID);
  342.                 if (rs.next()){
  343.                     Tools.debugmsg("<br> the newest paper is:"+rs.getString("paper"),out);
  344.                     Tools.debugmsg("<br> the title of the paper is:"+rs.getString("title"),out);
  345.                 }
  346.                 rs.close();
  347.                 stmt.close();
  348.             }
  350.         }
  351.     catch(SQLException e){
  352.             try{
  353.         con.rollback();
  354.             }catch(Exception e1){
  355.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  356.             }
  357.             msgsb.append("insert Error：SQL="+sql+"n"+e.toString());
  359.     }
  361. }else{
  362.             try{
  363.             con.rollback();
  364.             }catch(Exception e2){
  365.                 msgsb.append("rollback：SQL="+sql+"n"+e2.toString());
  366.             }
  367.             msgsb.append("Single test is error i="+i);
  368. }
  370. }catch(Exception e){
  371.             try{
  372.         con.rollback();
  373.             }catch(Exception e1){
  374.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  375.             }
  376.             msgsb.append("<br>Batch submit Errorn"+
  377.                 "<br>strArray["+i+"]="+strArray[i]+"<br>"+e.toString() );
  378.            Tools.debugmsg("<br>i="+i,out);
  380. }
  381. return newtestID;
  383. }
  384. %>
  390. <html>
  391. <head>
  392. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  393. <title>试题提交</title>
  394. </head>
  396. <body>`
  399. <%
  400. try{
  401. //UN_debug
  402. msgsb.delete(0,msgsb.length() );
  403. msgsb.append("OK");
  406. try{
  407.     String TeacherID=(String)session.getAttribute("teacherID");
  408.     //Tools.showalert("teaID="+TeacherID,out);
  409.     //Tools.showalert("msgdb="+msgsb.toString(),out);
  410.     //Tools.showalert(TeacherID,out);
  411.     teaID=Integer.parseInt(TeacherID);
  412. }catch(Exception e){
  413.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  414.     //response.sendRedirect("../login.jsp");
  415.     msgsb.append("teacherID Errorn");
  416.     Tools.showJS("window.open('../login.jsp','_self')",out);
  417.     //response.sendRedirect("../login.jsp");
  418. //    Tools.goback(out);
  419. }
  422. if (msgsb.toString().equals("OK"))
  423. {
  424. questTypeID=""+request.getParameter("QuestType");//试题类型ID
  425. subjectID=Integer.parseInt(request.getParameter("Subject"));//科目ID
  426. gradeID=""+request.getParameter("Grade");//年级ID
  427. //difficulty=""+request.getParameter("Difficulty");//难度
  428. knowPointID1=""+request.getParameter("KnowPoint1");//知识点ID
  429. knowPointID2=""+request.getParameter("KnowPoint2");//知识点ID
  430. knowPointID3=""+request.getParameter("KnowPoint3");//知识点ID
  431. //answer=""+request.getParameter("Answer");//答案
  432. //answer=Tools.codestring(answer);
  434. float mark=0;//Float.parseFloat(request.getParameter("Mark"));//分数
  436. String strHtml=""+request.getParameter("Content");//获取提交的试题的HTML
  437. //debug
  439. con=DBCon.getConnection();
  441. //
  442. strHtml=Tools.codestring(strHtml);//转换字符集
  444. String group=""+request.getParameter("group");
  447. if(group.equals("single")){//提交单个试题
  448. ID=submitOne(strHtml,answer,mark,difficulty,con,false);
  450. }else{
  451. if(group.equals("suit") ){
  452.     String Title=""+request.getParameter("suit_title");
  453.             Title=Tools.codestring(Title);
  454.             ID=submitAll(strHtml,Title,con,out);
  455. }
  456. }
  458. %>
  459. <%temp=msgsb.toString();
  460. if(debug){
  461.     out.print("<br><br><br>New Information");
  462.     out.print(temp);
  463. }
  466. if(temp.equals("OK")){
  467. //提交成功
  468.         if(group.equals("single")){//提交单个试题
  469.             Tools.showalert(" 试题提交成功,新的试题ID为："+ID,out);
  470.             Tools.goback(out);
  472.         }else if(group.equals("suit")){
  473.             Tools.showalert(" 试卷提交成功,新的试卷ID为："+ID,out);
  474.             Tools.goback(out);
  476.         }
  480. %>
  482. <%
  483. }
  484. else{
  485. System.out.print(msgsb.toString());
  486. %>
  487. <SCRIPT language="javascript">
  488. alert("试题未能提交成功，请检查提交信息或与系统管理员联系");
  489. //history.go(-1);
  490. </SCRIPT>
  491. <%
  492. }
  493. %>
  499. </body>
  500. </html>
  501. <%
  502. }
  503. %>
  505. <%}
  506. catch(Exception e){
  507.     System.out.print(e.toString());
  508. }
  509. finally{
  510.     DBCon.dropConnection();
  511. }
  512. %>