package webtest;import java.sql.*;//import java.math.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: 天津財經學院  信息管理與信息系統——高職升本0101班 * @author 王剛 * @version 1.0 */public class WebTestBean {  private String userName=null;//@用戶姓名 userName  private int[] questionID;//@問題索引數組 questionID  private int index=1;//游標  private String question="";//問題內容  private String[] answer;//選擇答案  private int classis=0;//問題分類  private String[] questionAns;//答案  private String studentID=null;//學號  private String errorMessage=null;//錯誤信息  private int questionCount=0;  private long nowtime=5400;  private boolean start=false;  String questionclassname[];  int questionclass[];  int questionclasses=0;  public String getQuestionclassname(int newValue){    return questionclassname[newValue-1];  }  public int getClassis(){    return classis;}  public int getQestionCount(){    return questionCount;}  public boolean getStart(){    return start;}  public void start(){    try {      Thread a =new Thread (new clock ());      start=true;      a.start();     }    catch(Exception e) {      e.printStackTrace();    }  }  public void setNowtime(long newValue)  {    nowtime=newValue;  }  public long getNowtime()  {    return nowtime;  }  public void setStudentID(String newValue)  {    studentID=newValue;  }  public WebTestBean() {    answer=new String[4];  }  public void setUserName(String newValue){    userName=newValue;  }  public String getAnswer(int ansIndex){    return answer[ansIndex-1];  }  public void setQuestionAns(String newValue){    questionAns[index-1]=newValue;  }  public int whatNull(){    int quatity=0;    for (int i=0;i<questionCount;i++)    {      if(questionAns[i]==null)        {quatity++;}    }    return quatity;  }  public String getQuestionAns(){    return questionAns[index-1];  }  public String getQuestionAns(int qindex){    return questionAns[qindex-1];  }  public String[] getAnswer(){    return answer;  }  public String getUserName(){    return userName;  }  public void setIndex(int newValue){    index=newValue;    if(index<=20)      classis=questionclass[0];    else if(index<=40)      classis=questionclass[1];    else      classis=questionclass[2];  }  public int getIndex(){    return index;  }  public String getErrorMessage(){    return errorMessage;  }  public String getQuestion(){    Sql_data query=new Sql_data();    String sqlstr="select * from testpaper where questionID="+questionID[index-1];    try {      ResultSet rs=query.executeQuery(sqlstr);      while(rs.next()){        question=rs.getString("content").trim();        if(classis!=3){          answer[0]=rs.getString("choice1").trim();          answer[1]=rs.getString("choice2").trim();          answer[2]=rs.getString("choice3").trim();          answer[3]=rs.getString("choice4").trim();        }      }      rs.close();      query.close();    }    catch(SQLException e){      System.out.println(e.getMessage());    }    return question;  }  public void selectquestion(){    int rowcount=0;    int index=0;    int rtn=0;    questionclasses=0;    questionclass=new int[4];    questionclassname=new String[4];    int[] questionrow=new int[3];    Sql_data query=new Sql_data();    String sqlstr="select * from questionclass";    try{      query.getConn();      ResultSet rs=query.query(sqlstr);      while(rs.next()){        questionclass[questionclasses]=rs.getInt("classID");        questionclassname[questionclasses]=rs.getString("classname");        questionclasses++;      }    }    catch(SQLException e)    {      System.out.println(e.getMessage());    }    questionCount=questionclasses*20;    questionID=new int[questionCount];    questionAns=new String[questionCount];    int[][] questionindex=new int[3][4000];    sqlstr="select questionID from testpaper where classID=1";    try    {      ResultSet rs=query.query(sqlstr);      rtn=0;      while(rs.next())      {        questionindex[0][rtn]=rs.getInt("questionID");        rtn++;      }    }    catch(SQLException e)    {    }    questionrow[0]=rtn;    sqlstr="select questionID from testpaper where classID=2";    try    {      ResultSet rs=query.query(sqlstr);      rtn=0;      while(rs.next())      {        questionindex[1][rtn]=rs.getInt("questionID");        rtn++;      }    }    catch(SQLException e)    {    }    questionrow[1]=rtn;    sqlstr="select questionID from testpaper where classID=3";    try    {      ResultSet rs=query.query(sqlstr);      rtn=0;      while(rs.next())      {        questionindex[2][rtn]=rs.getInt("questionID");        rtn++;      }    }    catch(SQLException e)    {    }    questionrow[2]=rtn;    for(int l=0;l<questionclasses;l++){      rowcount=questionrow[l];      if(rowcount<20){        questionclass[l]=questionclass[l+1];        questionclassname[l]=questionclassname[l+1];        continue;      }      do      {        index=(int)(Math.random()*rowcount)+1;      } while(index==0);      questionID[0+20*l]=questionindex[l][index-1];      for (int i=1;i<20;i++){        index=(int)(Math.random()*rowcount)+1;        questionID[i+20*l]=questionindex[l][index-1];        for (int j=0;j<i;j++){          if (questionID[i+20*l]==questionID[j+20*l]||index==0){            i--;break;}        }      }    }    System.out.println("congratulation");  }  public int updateAns()  {    String sqlstr="";    String flag=null;      Sql_data query=new Sql_data();      for(int i=0;i<questionCount;i++)      {        if(questionAns[i]==null)          questionAns[i]="";        sqlstr="insert into test(StudentID,questionID,answer) values('"+studentID.trim()+"','"+questionID[i]+"','"+questionAns[i]+"')";        query.executeInsert(sqlstr);        query.closeconn();      }      return 1;  };  class  clock  implements  Runnable  {    long time=nowtime;    clock (){}    public void run ()    {      while (time>0)      {        try        {          Thread.sleep(1000);        }        catch (Exception e)        {}        time=time-1;        setNowtime(time);      }      int i=updateAns();      if(i==1)        errorMessage="您的考試時間已到,答案已自動保存。謝謝您的使用，再見！";    }  }}