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

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

教育系统应用

开发平台：

WORD

updatetest.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.     {
  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+",2,'"+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;
  241.         int i=-1;
  242. String ans="";
  243. SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  244. String now=df.format(new java.util.Date());
  245. //先将所有试题提交
  246. //debug
  247. //out.println(now);
  248. //        out.print("strArray.length="+String.valueOf(strArray.length));
  249. //        if (debug){
  250. //            for(i=0;i<strArray.length;i++){
  251. //                Tools.debugmsg("<br>strArray["+i+"]="+strArray[i]+"<br>",out);
  252. //            }
  253. //        }
  255. try{
  256.             con.setAutoCommit(false);
  257.             int mark=0;
  258.             for( i=1;i<strArray.length;i++){//提交每一道试题
  259.                 if(debug){
  260.                  out.println("<br>test("+i+"):<br>"+strArray[i]);
  261.                 }
  263.              bin=strArray[i].indexOf("@");
  264.                 end=strArray[i].lastIndexOf("@");
  265.          temp=strArray[i].substring(bin+1,end+1);//答案
  266.                 ansMark=temp.split("@");
  267.                 int tippos=strArray[i].indexOf("#tip");
  268.                 String t1=strArray[i].substring(0,bin)+strArray[i].substring(tippos).trim();
  269.                 //将答案串从试题文本中删除，因为单个试题文本中没有这些信息
  270.                 //提交单个试题
  271.                 mark+=Float.parseFloat(ansMark[1]);
  272.                 try{
  273.                     newID=submitOne(t1,ansMark[0],Float.parseFloat(ansMark[1]),ansMark[2],con,true);
  274.                     if(debug && newID!=-1){
  275.                         out.println("<br>database submit success:newID="+newID);
  276.                     }
  278.                     if(newID!=-1){
  279.                         //试题ID@答案@分数@难易度;     一道试题的格式，以#号结束
  280.                         temp=String.valueOf(newID)+"@"+ansMark[0].trim() +"@"+ansMark[1].trim() +"@"+ansMark[2].trim() +"#";
  281.                      bs.append(temp);
  282.                     }else
  283.                         {
  284.                         throw new Exception("试题格式可能出错");
  285.                         }
  287.                 }catch(IllegalArgumentException ie)
  288.                     {
  289.                         msgsb.append("试题格式可能出错 test("+i+")=："+t1+temp+"<br>"+ie);
  290.                         out.print("<br>"+msgsb.toString());
  291.                     }
  296.         }
  298.          //提交试卷
  299.         if(msgsb.toString().equals("OK")){
  300.     try{
  301.          //   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)";
  302.          //   con.setAutoCommit(false);
  303.          //   stmt=con.createStatement();
  304.          //   stmt.executeUpdate(sql);
  305.          //   stmt.close();
  308.          sql="insert into test(date,testtypeid,paper,title,subid,gradenote,status,teaid,validtime,testnum,"+
  309.                 "knowpointid1,knowpointid2,knowpointid3,mark) "+
  310.             "values('"+now+"',"+"1"+",'"+bs.toString() +"','"+Title+"',"+subjectID+","+"'"+gradeID+"'"+
  311.      ","+"2"+","+teaID+","+"3"+","+(strArray.length-1) +","+
  312.                 knowPointID1+","+knowPointID2+","+knowPointID3+","+mark+")";
  314.          //缺省testtypeid=1:单一的选择题；statue=2：已经发布；validtiem=3:有效期为3年
  315.             Statement stmt=con.createStatement();
  317.             stmt.executeUpdate(sql);
  319.             stmt.close();
  320.             if(debug){
  321.                 Tools.debugmsg("<br>insert into test:SQL="+sql,out);
  322.             }
  323.             stmt=con.createStatement();
  324.             ResultSet rs=stmt.executeQuery("select LAST_INSERT_ID() as newid from question");
  326.             if(rs.next()){
  327.                 newtestID=rs.getInt("newID");
  328.                 rs.close();
  329.                 stmt.close();
  330.             }
  332.             con.commit();
  333.             if(debug){
  334.                 out.print("<br> new test ID is:"+newtestID);
  338.                 stmt=con.createStatement();
  339.                 rs=stmt.executeQuery("select id,paper,title from test where id="+newtestID);
  341.                 if (rs.next()){
  342.                     Tools.debugmsg("<br> the newest paper is:"+rs.getString("paper"),out);
  343.                     Tools.debugmsg("<br> the title of the paper is:"+rs.getString("title"),out);
  344.                 }
  345.                 rs.close();
  346.                 stmt.close();
  347.             }
  349.         }
  350.     catch(SQLException e){
  351.             try{
  352.         con.rollback();
  353.             }catch(Exception e1){
  354.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  355.             }
  356.             msgsb.append("insert Error：SQL="+sql+"n"+e.toString());
  358.     }
  360. }else{
  361.             try{
  362.             con.rollback();
  363.             }catch(Exception e2){
  364.                 msgsb.append("rollback：SQL="+sql+"n"+e2.toString());
  365.             }
  366.             msgsb.append("Single test is error i="+i);
  367. }
  369. }catch(Exception e){
  370.             try{
  371.         con.rollback();
  372.             }catch(Exception e1){
  373.                 msgsb.append("<BR>rollbackcbd：SQL="+sql+"n"+e1.toString());
  374.             }
  375.             msgsb.append("<br>Batch submit Errorn"+
  376.                 "<br>strArray["+i+"]="+strArray[i]+"<br>"+e.toString() );
  377.            Tools.debugmsg("<br>i="+i,out);
  379. }
  380. return newtestID;
  382. }
  383. %>
  389. <html>
  390. <head>
  391. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  392. <title>试题提交</title>
  393. </head>
  395. <body>`
  398. <%
  399. try{
  400. //UN_debug
  401. msgsb.delete(0,msgsb.length() );
  402. msgsb.append("OK");
  405. try{
  406.     String TeacherID=(String)session.getAttribute("teacherID");
  407.     //Tools.showalert("teaID="+TeacherID,out);
  408.     //Tools.showalert("msgdb="+msgsb.toString(),out);
  409.     //Tools.showalert(TeacherID,out);
  410.     teaID=Integer.parseInt(TeacherID);
  411. }catch(Exception e){
  412.     Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
  413.     //response.sendRedirect("../login.jsp");
  414.     msgsb.append("teacherID Errorn");
  415.     Tools.showJS("window.open('../login.jsp','_self')",out);
  416.     //response.sendRedirect("../login.jsp");
  417. //    Tools.goback(out);
  418. }
  421. if (msgsb.toString().equals("OK"))
  422. {
  423. questTypeID=""+request.getParameter("QuestType");//试题类型ID
  424. subjectID=Integer.parseInt(request.getParameter("Subject"));//科目ID
  425. gradeID=""+request.getParameter("Grade");//年级ID
  426. //difficulty=""+request.getParameter("Difficulty");//难度
  427. knowPointID1=""+request.getParameter("KnowPoint1");//知识点ID
  428. knowPointID2=""+request.getParameter("KnowPoint2");//知识点ID
  429. knowPointID3=""+request.getParameter("KnowPoint3");//知识点ID
  430. //answer=""+request.getParameter("Answer");//答案
  431. //answer=Tools.codestring(answer);
  433. float mark=0;//Float.parseFloat(request.getParameter("Mark"));//分数
  435. String strHtml=""+request.getParameter("Content");//获取提交的试题的HTML
  436. //debug
  438. con=DBCon.getConnection();
  440. //
  441. strHtml=Tools.codestring(strHtml);//转换字符集
  443. String group=""+request.getParameter("group");
  446. if(group.equals("single")){//提交单个试题
  447. ID=submitOne(strHtml,answer,mark,difficulty,con,false);
  449. }else{
  450. if(group.equals("suit") ){
  451.     String Title=""+request.getParameter("suit_title");
  452.             Title=Tools.codestring(Title);
  453.             ID=submitAll(strHtml,Title,con,out);
  454. }
  455. }
  457. %>
  458. <%temp=msgsb.toString();
  459. if(debug){
  460.     out.print("<br><br><br>New Information");
  461.     out.print(temp);
  462. }
  465. if(temp.equals("OK")){
  466. //提交成功
  467.         if(group.equals("single")){//提交单个试题
  468.             Tools.showalert(" 试题提交成功,新的试题ID为："+ID,out);
  469.             Tools.goback(out);
  471.         }else if(group.equals("suit")){
  472.             Tools.showalert(" 试卷提交成功,新的试卷ID为："+ID,out);
  473.             Tools.goback(out);
  475.         }
  479. %>
  481. <%
  482. }
  483. else{
  484. System.out.print(msgsb.toString());
  485. %>
  486. <SCRIPT language="javascript">
  487. alert("试题未能提交成功，请检查提交信息或与系统管理员联系");
  488. //history.go(-1);
  489. </SCRIPT>
  490. <%
  491. }
  492. %>
  498. </body>
  499. </html>
  500. <%
  501. }
  502. %>
  504. <%}
  505. catch(Exception e){
  506.     System.out.print(e.toString());
  507. }
  508. finally{
  509.     DBCon.dropConnection();
  510. }
  511. %>