?? updatetest_mn.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="" %>
<%@ page import="java.sql.*"%>
<%@ page import="jinghua.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<script language="javascript">
</script>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<jsp:useBean id="transString" class="jinghua.TransformString" scope="page">
</jsp:useBean>
<%!
String questTypeID=null;
boolean debug=true;
int subjectID=-1;
String gradeID=null;
int mntestID=-1;
String knowPointID1=null;
String knowPointID2=null;
String knowPointID3=null;
StringBuffer msgsb=new StringBuffer("OK");
String sql="";
String temp="";
int teaID=-1;
int ID=-1;//新提交試題或試卷的ID
Connection con=null;
//生成試題分類編號
public String QuestClassCode(Connection con,int SubjectID,String gradeID,
String KnowPointID,String testpoint,String QuestType, String PostHard){
int num=0;
StringBuffer bs=new StringBuffer();
String sql="";
try{
Statement stmt=con.createStatement();
sql="select count(*) as num from question where subjectid="+SubjectID+
" and knowpointid1="+KnowPointID+
" and questtype="+ QuestType+
" and prehard='" +PostHard+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
num=rs.getInt(1);
}
num++;
//格式化第幾道題
DecimalFormat df=new DecimalFormat("00000");
String numNF=df.format(num);
//NumberFormat nf = NumberFormat.getNumberInstance ();
// nf.
//nf.setMinimumIntegerDigits(5);//整數部分最小的長度不能少于2，如果少了則補另.
//String numNF=nf.format(num);
rs.close();
stmt.close();
sql="select subject.note as sn, knowpoint.note as kn,grade.note as gn "+
" from subject,knowpoint,grade "+
" where subject.id="+SubjectID+
" and knowpoint.id="+KnowPointID+" and grade.id="+"'"+gradeID+"'";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if (rs.next()){
String temp;
temp=rs.getString("sn");
bs.append(temp);
bs.append(rs.getString("gn") );
df=new DecimalFormat("00");
temp=df.format(Integer.valueOf(testpoint));
bs.append(temp);
bs.append(QuestType);
bs.append(PostHard);
bs.append(numNF);
temp=rs.getString("kn");
bs.append(temp);
rs.close();
stmt.close();
}
}catch(Exception se){
msgsb.append(se.toString());
msgsb.append("<br>"+"SQL="+sql);
}
return bs.toString();
}
synchronized public int submitOne(String strHtml,String answer,float mark,String difficulty,Connection con,boolean commit){
//commit=true則需要在一道題提交完后，使用commit來完成提交
Statement stmt=null;
strHtml=strHtml.trim();
int tipPos=-1;
String tip="";
//檢查格式：
if(strHtml.startsWith("@@")){
msgsb.append("<BR>單個試題的數據格式錯誤，請檢查!");
return -1;
}else{
//檢查是否包含了文件
}
//檢查答案：
if(answer.trim()==""){
msgsb.append("<BR>試題答案為空，請檢查!"+"原試題為:<br>"+strHtml);
return -1;
}else if (answer.trim().length()!=1){
msgsb.append("<BR>試題答案長度不為1，請檢查!"+"原試題為:<br>"+strHtml);
return -1;
}else{
String strAnswer="ABCDEFGH";
if(strAnswer.indexOf(answer)<0){
msgsb.append("<BR>單選試題的答案長度不為“ABCDEFGH”中的字符，請檢查!"+"原試題為:<br>"+strHtml);
return -1;
}
}
//檢查難易度
if(difficulty.trim()==""){
msgsb.append("<BR>試題難易度為空，請檢查!"+"原試題為:<br>"+strHtml);
return -1;
}else if (difficulty.trim().length()!=1){
msgsb.append("<BR>試題難易度長度不為1，請檢查!"+"原試題為:<br>"+strHtml);
return -1;
}else{
String strAnswer="ABCDE";
if(strAnswer.indexOf(difficulty)<0){
msgsb.append("<BR>單選難易度的答案長度不為“ABCDE”中的字符，請檢查!"+"原試題為:<br>"+strHtml);
return -1;
}
}
tipPos=strHtml.indexOf("#tip");
if(tipPos>0){
tip=strHtml.substring(tipPos+4);//取提示
strHtml=strHtml.substring(0,tipPos);
tip=Tools.toSql(tip);
strHtml=Tools.toSql(strHtml);
}
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String now=df.format(new java.util.Date());//當前日期
answer=answer.toUpperCase();
int newID=-1;
if(!strHtml.equals("")){
try{
answer.toUpperCase();
difficulty.toUpperCase();
//String QuestClassType=QuestClassCode(con,subjectID, gradeID, knowPointID1,testPointID1,
// questTypeID, difficulty);
String QuestClassType="";
if(QuestClassType==null){
msgsb.append(" Error：試題編號生成錯誤\n"+""+QuestClassType+strHtml);
}
else
{
sql="insert into question(QuestID,Mark,Answer,TeacherID,`question`.`Source`, "+
"PubDate,QuestType,SubjectID,gradenote, "+
"KnowPointID1,KnowPointID2,KnowPointID3,PreHard,Tip) "+ "values("+
"'"+QuestClassType+"',"+mark+",'"+answer+"',"+teaID+",3,'"+now+"',"+
questTypeID+","+subjectID+","+"'"+gradeID+"'"+","+knowPointID1+","+knowPointID2+","+knowPointID3+
",'"+difficulty+"','"+tip+"'"+")";
con.setAutoCommit(!commit);
stmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select LAST_INSERT_ID() as newid from question");
if(rs.next()){
newID=rs.getInt("newID");
rs.close();
stmt.close();
}
}
}//end try
catch(SQLException se){
System.out.print(se);
System.out.print(sql);
msgsb.append("試題入庫出錯：SQL="+sql+"\n"+se.toString());
}catch(Exception e){
msgsb.append("試題格式可能出錯 strHtml=："+strHtml);
}
if(newID!=-1 && msgsb.toString().equals("OK") ) {
try{//修改題干
temp=jinghua.TransformString.TransformSelction(strHtml,newID);
temp=Tools.toSql(temp);
if(temp==null)
throw new Exception("題目沒有數據");
stmt=con.createStatement();
sql="update question set QuestText='"+temp+"' where ID="+newID;
stmt.executeUpdate(sql);
stmt.close();
}
catch(SQLException se){
System.out.print(se);
msgsb.append("試題入庫出錯：SQL="+sql+"\n"+se.toString());
}
catch(Exception se){
System.out.print(se);
msgsb.append("試題入庫出錯："+se.toString());
}
}//end if
}else{
msgsb.append("提交試題出錯：試題為空");
}
return newID;
}//end submitOne
//@@2. My pain _____apparent the moment I walked into the room. for the first man I met asked
//sympathetically: "Are you feeling all right?"
// A. must be B. had C. must have been D. had to be
//##A ##B ##C ##D
//@A@5@E@ :@答案@分數@難度@
synchronized public int submitAll(String strHtml,String Title,Connection con,javax.servlet.jsp.JspWriter out){
if(debug){
try{
out.print("<br> submitAll input:<BR>"+ strHtml);
}catch(Exception e){}
}
String [] strArray=strHtml.split("@@");//"@@"為每道試題的分隔符
String [] ansMark;
String temp=null;
StringBuffer bs=new StringBuffer();//試題ID#答案A#分數;
int newID=-1,bin=-1,end=0;
int newtestID=-1;
int i=-1;
String ans="";
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String now=df.format(new java.util.Date());
//先將所有試題提交
//debug
//out.println(now);
// out.print("strArray.length="+String.valueOf(strArray.length));
try{
con.setAutoCommit(false);
int mark=0;
for( i=1;i<strArray.length;i++){//提交每一道試題
if(debug){
out.println("<br>test("+i+"):<br>"+strArray[i]);
}
bin=strArray[i].indexOf("@");
end=strArray[i].lastIndexOf("@");
temp=strArray[i].substring(bin+1,end+1);//答案
ansMark=temp.split("@");
int tippos=strArray[i].indexOf("#tip");
String t1=strArray[i].substring(0,bin)+strArray[i].substring(tippos).trim();
//將答案串從試題文本中刪除，因為單個試題文本中沒有這些信息
//提交單個試題
mark+=Float.parseFloat(ansMark[1]);
try{
newID=submitOne(t1,ansMark[0],Float.parseFloat(ansMark[1]),ansMark[2],con,true);
if(debug && newID!=-1){
out.println("<br>database submit success:newID="+newID);
}
if(newID!=-1){
//試題ID@答案@分數@難易度; 一道試題的格式，以#號結束
temp=String.valueOf(newID)+"@"+ansMark[0].trim() +"@"+ansMark[1].trim() +"@"+ansMark[2].trim() +"#";
bs.append(temp);
}else
{
throw new Exception("試題格式可能出錯");
}
}catch(IllegalArgumentException ie)
{
msgsb.append("試題格式可能出錯 test("+i+")=："+t1+temp+"<br>"+ie);
}
}
//提交試卷
if(msgsb.toString().equals("OK")){
try{
// 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)";
// con.setAutoCommit(false);
// stmt=con.createStatement();
// stmt.executeUpdate(sql);
// stmt.close();
//
sql="insert into test(date,testtypeid,paper,title,subid,gradenote,status,teaid,validtime,testnum,"+
"knowpointid1,knowpointid2,knowpointid3,mark) "+
"values('"+now+"',"+"1"+",'"+bs.toString() +"','"+Title+"',"+subjectID+","+"'"+gradeID+"'"+
","+"3"+","+teaID+","+"3"+","+(strArray.length-1) +","+
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -