frame4.java~381~

提供了一种注册机算法的实现. 里面共有两份分别是题库的代码和注册机的代码

  }

  void jButton2044_actionPerformed(ActionEvent e) {
    /*/////////////////////////////////////////////////////////////////数据添加*/


                Dcyh dc2 = new Dcyh();
                dc2.connection();
                ResultSet returnRs2 = dc2.rs2;
                Statement s2 = dc2.stmt;
           String Input11 = "'"+jComboBox1744.getSelectedItem()+"'";
             String Input22= "'"+jComboBox14.getSelectedItem()+"'";
             String Input33 = "'"+jComboBox1844.getSelectedItem()+"'";
       String Input44 = "'"+jComboBox1944.getSelectedItem()+"'";
             String Input55= "'"+jComboBox11044.getSelectedItem()+"'";
             String Input66 = "'"+jTextField443.getText().trim()+"'";
       String Input77 = "'"+jTextArea445.getText().trim()+"'";
                  String Input88= "'"+jTextArea446.getText().trim()+"'";
                  String Input99 = "'"+jTextField444.getText().trim()+"'";

     try {
        s2.executeUpdate("insert into sttk(课程类别,试题类型,难度系数,所属章,所属节,分数建议,题目内容,正确答案,出题老师) values("+Input11+","+Input22+","+Input33+","+Input44+","+Input55+","+Input66+","+Input77+","+Input88+","+Input99+")");

         System.out.println("成功"); }
         catch (SQLException e4) {System.out.println(e4);}
     /* /////////////////////////////////////////////////////////////*/// 数据添加


  }

  void jButton2144_actionPerformed(ActionEvent e) {
    /*/////////////////////////////////////////////////////////////////数据添加*/


                   Dcyh dc3 = new Dcyh();
                   dc3.connection();
                  // ResultSet returnRs3 = dc3.rs2;
                   Statement s3 = dc3.stmt;
              String Input111 = "'"+jComboBox1744.getSelectedItem()+"'";
                String Input222= "'"+jComboBox14.getSelectedItem()+"'";
                String Input333 = "'"+jComboBox1844.getSelectedItem()+"'";
          String Input444 = "'"+jComboBox1944.getSelectedItem()+"'";
                String Input555= "'"+jComboBox11044.getSelectedItem()+"'";
                String Input666 = "'"+jTextField443.getText().trim()+"'";
          String Input777 = "'"+jTextArea448.getText().trim()+"'";
                     String Input888= "'"+jTextField442.getText().trim()+"'";
                     String Input999 = "'"+jTextField444.getText().trim()+"'";

        try {
           s3.executeUpdate("insert into sttk(课程类别,试题类型,难度系数,所属章,所属节,分数建议,题目内容,正确答案,出题老师) values("+Input111+","+Input222+","+Input333+","+Input444+","+Input555+","+Input666+","+Input777+","+Input888+","+Input999+")");

            System.out.println("成功"); }
            catch (SQLException e5) {System.out.println(e5);}
       /*///////////////////////////////////////////////////////////// // 数据添加*/

  }

  void jButton2_actionPerformed(ActionEvent e) {
 OperationFile.oAnswer1(jTextArea2.getText().toCharArray());
  }

 void jButton310_actionPerformed(ActionEvent e) {
  try{ ////////////////////////////////////////////////////////////////数据库题目查询
String c1=jComboBox3.getSelectedItem().toString();
String c2=jComboBox5.getSelectedItem().toString();
String c3=jComboBox4.getSelectedItem().toString();
String c4=jComboBox6.getSelectedItem().toString();
String c5=jComboBox7.getSelectedItem().toString();
String c6=jComboBox811.getSelectedItem().toString();
 vv.clear();
   Dcyh dc5 = new Dcyh();
   dc5.connection();
 ResultSet returnRs5 = dc5.rs;
   Statement s5= dc5.stmt;
   ///////////////////////////////////////
   try {

     returnRs5 =s5.executeQuery("SELECT * FROM sttk where 课程类别='"+c1+"' and 试题类型='"+c2+"' and 难度系数='"+c3+"' and 所属章 ='"+c4+"' and 所属节='"+c5+"' and 出题老师='"+c6+"'");



while(returnRs5.next()) {

  vv.add(returnRs5.getString(8));
   }
tj100=vv.size();
jList3.setListData(vv);
//System.out.println(vv);

}

catch (SQLException eee1) {

       // System.out.println(eee1);
}
   }
  catch(Exception jkl){}
 ////////////////////////////////////////////////////////////////数据库题目查询
}

  ////////////////////////////////////////////////
//////////////////////////////////////获取word路径
 void jButton1_actionPerformed(ActionEvent e) {
   int returnVal=fc.showOpenDialog(this);
        if(returnVal==JFileChooser.APPROVE_OPTION){
          File file=fc.getSelectedFile();
          System.out.println(file.getPath());
            Dcyh dca = new Dcyh();
                   dca.connection();
                   //ResultSet returnRs3 = dca.rs2;
                   Statement sa = dca.stmt;
    try {
               sa.executeUpdate("update  pathp set path='"+file.getPath()+"' where 编号='2'");

                System.out.println("成功"); }
                catch (SQLException e5a) {System.err.println(e5a);}




 }

  }
//////////////////////////////////////获取word路径
  ////////////////////////////////////////////////
  void jButton3_actionPerformed(ActionEvent e) {
 /*
  char[] c={'j','g'};
  this.oAnswer1(ph,c);
  */
//jList3.sc
int tj100=vv.size();
 //System.out.println(t);

  }

  void jButton21_actionPerformed(ActionEvent e) {
OperationFile.oAnswer(jTextArea2.getText().toCharArray());
  }

  void jButton110_actionPerformed(ActionEvent e) {
    if(jComboBox11.getSelectedIndex()==0){
        OperationFile.oAnswer3(jTextArea3.getText().toCharArray());
       }
        else if(jComboBox11.getSelectedIndex() ==1){
          OperationFile.oAnswer2(jTextArea3.getText().toCharArray());
        }

  }

  void jButton19_actionPerformed(ActionEvent e) {
    if(jComboBox9.getSelectedIndex()==0){
         OperationFile.oAnswer5(jTextArea4.getText().toCharArray());
        }
         else if(jComboBox9.getSelectedIndex() ==1){
           OperationFile.oAnswer4(jTextArea4.getText().toCharArray());
         }

  }

  void jButton34_actionPerformed(ActionEvent e) {
OperationFile.oAnswer6(jTextArea9.getText().toCharArray());
  }

  void jButton35_actionPerformed(ActionEvent e) {
OperationFile.oAnswer7(jTextArea10.getText().toCharArray());
  }

  void jButton2344_actionPerformed(ActionEvent e) {
OperationFile.oAnswer8(jTextArea445.getText().toCharArray());
  }

  void jButton2544_actionPerformed(ActionEvent e) {
OperationFile.oAnswer9(jTextArea448.getText().toCharArray());
  }

  void jComboBox415_actionPerformed(ActionEvent e) {
//int i=jComboBox415.getSelectedIndex();
    if(jComboBox415.getSelectedIndex()==0){
      jComboBox440.removeAllItems();
      jComboBox440.addItem("A");
      jComboBox440.addItem("B");
      jComboBox440.addItem("C");
      jComboBox440.addItem("D");
    }
  else if(jComboBox415.getSelectedIndex()==1){
    jComboBox440.removeAllItems();
    jComboBox440.addItem("A");
    jComboBox440.addItem("B");

  }
  else if(jComboBox415.getSelectedIndex()==2){
    jComboBox440.removeAllItems();
    jComboBox440.addItem("A");
    jComboBox440.addItem("B");
    jComboBox440.addItem("C");
  }
  else if(jComboBox415.getSelectedIndex()==3){
      jComboBox440.removeAllItems();
      jComboBox440.addItem("A");
      jComboBox440.addItem("B");
      jComboBox440.addItem("C");
      jComboBox440.addItem("D");
      jComboBox440.addItem("E");
    }
else{
      jComboBox440.removeAllItems();
          jComboBox440.addItem("A");
          jComboBox440.addItem("B");
          jComboBox440.addItem("C");
          jComboBox440.addItem("D");
          jComboBox440.addItem("E");
          jComboBox440.addItem("F");
}



  }

  void jButton2744_actionPerformed(ActionEvent e) {
    jButton2644.setEnabled(true);
    jComboBox14.setEnabled(false);
    if(jComboBox14.getSelectedIndex()==0){
      jTextArea448.setEditable(true);

jButton23.setEnabled(true);
      jButton22.setEnabled(true);
      jButton2144.setEnabled(true);
     jButton2444.setEnabled(true);

     jButton2044.setEnabled(false);
     jButton2244.setEnabled(false);
     jTextArea445.setEditable(false);
     jTextArea446.setEditable(false);
     /////////设置焦点
        jTextArea448.grabFocus();
         /////////设置焦点
         jButton2344.setEnabled(false);
      jButton2544.setEnabled(true);
           }
            else {
             jButton2044.setEnabled(true);
     jButton2244.setEnabled(true);
     jTextArea445.setEditable(true);
     jTextArea446.setEditable(true);
     jButton23.setEnabled(false);
     jButton22.setEnabled(false);
     /////////设置焦点
        jTextArea445.grabFocus();
         /////////设置焦点

     jButton2144.setEnabled(false);
   jButton2444.setEnabled(false);
   jButton3944.setEnabled(false);
   jTextArea448.setEditable(false);
   jTextArea441.setEditable(false);
   jTextField442.setEditable(false);
   jButton2344.setEnabled(true);
      jButton2544.setEnabled(false);

            }


  }

  void jButton2644_actionPerformed(ActionEvent e) {
    jTextArea445.setText("");
    jTextArea446.setText("");
i=0;
    jTextArea448.setText("");
    jTextArea441.setText("");
    jTextField442.setText("");
     if(jComboBox14.getSelectedIndex()==0){
       /////////设置焦点
        jTextArea448.grabFocus();
         /////////设置焦点
         jButton3944.setEnabled(true);
         jComboBox440.setSelectedIndex(0);

     }
     else{
       /////////设置焦点
        jTextArea445.grabFocus();
         /////////设置焦点

     }

  }

  void jButton2844_actionPerformed(ActionEvent e) {
jComboBox14.setEnabled(true);
    jButton2044.setEnabled(false);
       jButton2244.setEnabled(false);
       jTextArea445.setEditable(false);
       jTextArea446.setEditable(false);
       jButton2144.setEnabled(false);
  jButton2444.setEnabled(false);
  jButton3944.setEnabled(false);
  jTextArea448.setEditable(false);
  jTextArea441.setEditable(false);
  jTextField442.setEditable(false);
jButton2344.setEnabled(false);
      jButton2544.setEnabled