studentframe.java~66~

来自「学生管理系统:有辅导员登入,学生登入和老师登入界面」· JAVA~66~ 代码 · 共 570 行 · 第 1/2 页

jTextField4.setText(queryDataSet.getString("籍贯"));
jTextField6.setText(queryDataSet.getString("家庭电话"));
jTextField8.setText(queryDataSet.getString("家庭邮编"));
jTextField7.setText(queryDataSet.getString("家庭住址"));
}
}

  void jTextField3_actionPerformed(ActionEvent e) {

  }

  void jButton1_actionPerformed(ActionEvent e){
     String sql="delete from stumessage where 学号='"+jLabel13.getText().trim()+"'";

     database.executeStatement(sql);
     if(!(jTextField3.getText().trim().equals(""))){
     String sql1="insert into stumessage values('"+jLabel13.getText().trim()
         +"','"+jLabel12.getText().trim()+"','"+jComboBox1.getSelectedItem()
         +"','"+jTextField2.getText().trim()+"',"+jTextField3.getText().trim()
         +",'"+jComboBox2.getSelectedItem()+"','"+jTextField4.getText().trim()
         +"','"+jTextField5.getText().trim()+"','"+jTextField6.getText().trim()
         +"','"+jTextField7.getText().trim()+"','"+jTextField8.getText().trim()
          +"')";
        database.executeStatement(sql1);
         }else{
        String sql1="insert into stumessage (学号,姓名,性别,身份证号,政治面貌,籍贯,个人电话,家庭电话,家庭住址,家庭邮编) values('"+jLabel13.getText().trim()
         +"','"+jLabel12.getText().trim()+"','"+jComboBox1.getSelectedItem()
         +"','"+jTextField2.getText().trim()+"',"+"'"+jComboBox2.getSelectedItem()+"','"+jTextField4.getText().trim()
         +"','"+jTextField5.getText().trim()+"','"+jTextField6.getText().trim()
         +"','"+jTextField7.getText().trim()+"','"+jTextField8.getText().trim()
         +"')";
              database.executeStatement(sql1);

            }




  }

  void jComboBox3_actionPerformed(ActionEvent e) {
    String year="";
     String xieqi="";
     String select="";
     if(jComboBox3.getSelectedIndex()==0){
       year="";

     }else{
      year=String.valueOf(jComboBox3.getSelectedItem());
     }
   if(jComboBox4.getSelectedIndex()==0){
    xieqi="";
   }else if(jComboBox4.getSelectedIndex()==1){
     xieqi="1";
   }else if(jComboBox4.getSelectedIndex()==2){
     xieqi="2";
   }
   if(jComboBox5.getSelectedIndex()==0){
        select="";
   }else{
   select=String.valueOf(jComboBox5.getSelectedItem());
   }
    if(year.equals("")&&xieqi.equals("")&&select.equals("")){
     jdbTable1.setDataSet(queryDataSet2);
    } if((!year.equals(""))&&xieqi.equals("")&&select.equals("")){
          parameterRow1.setString("学年",year);
          queryDataSet5.executeQuery();
           jdbTable1.setDataSet(queryDataSet5);
    }else if((!year.equals(""))&&(!xieqi.equals(""))&&select.equals("")){
          parameterRow1.setString("学年",year);
            parameterRow1.setString("学期",xieqi);
          queryDataSet6.executeQuery();
            jdbTable1.setDataSet(queryDataSet6);

    }else if((!year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学年",year);
      parameterRow1.setString("学期",xieqi);
      parameterRow1.setString("修习类别",select);
      queryDataSet4.executeQuery();
      jdbTable1.setDataSet(queryDataSet4);
    }else if((year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学期",xieqi);
   parameterRow1.setString("修习类别",select);
   queryDataSet7.executeQuery();
   jdbTable1.setDataSet(queryDataSet7);
      }else if((year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
        parameterRow1.setString("修习类别",select);
       queryDataSet8.executeQuery();
       jdbTable1.setDataSet(queryDataSet8);
     }else if((year.equals(""))&&(!xieqi.equals(""))&&(select.equals(""))){
       parameterRow1.setString("学期",xieqi);
      queryDataSet9.executeQuery();
      jdbTable1.setDataSet(queryDataSet9);
     }
     else if((!year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
           parameterRow1.setString("学年",year);
           parameterRow1.setString("修习类别",select);
           queryDataSet10.executeQuery();
           jdbTable1.setDataSet(queryDataSet10);
          }
}

  void jComboBox4_actionPerformed(ActionEvent e) {
    String year="";
     String xieqi="";
     String select="";
     if(jComboBox3.getSelectedIndex()==0){
       year="";

     }else{
      year=String.valueOf(jComboBox3.getSelectedItem());
     }
   if(jComboBox4.getSelectedIndex()==0){
    xieqi="";
   }else if(jComboBox4.getSelectedIndex()==1){
     xieqi="1";
   }else if(jComboBox4.getSelectedIndex()==2){
     xieqi="2";
   }
   if(jComboBox5.getSelectedIndex()==0){
        select="";
   }else{
   select=String.valueOf(jComboBox5.getSelectedItem());
   }
    if(year.equals("")&&xieqi.equals("")&&select.equals("")){
     jdbTable1.setDataSet(queryDataSet2);
    } if((!year.equals(""))&&xieqi.equals("")&&select.equals("")){
          parameterRow1.setString("学年",year);
          queryDataSet5.executeQuery();
           jdbTable1.setDataSet(queryDataSet5);
    }else if((!year.equals(""))&&(!xieqi.equals(""))&&select.equals("")){
          parameterRow1.setString("学年",year);
            parameterRow1.setString("学期",xieqi);
          queryDataSet6.executeQuery();
            jdbTable1.setDataSet(queryDataSet6);

    }else if((!year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学年",year);
      parameterRow1.setString("学期",xieqi);
      parameterRow1.setString("修习类别",select);
      queryDataSet4.executeQuery();
      jdbTable1.setDataSet(queryDataSet4);
    }else if((year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学期",xieqi);
   parameterRow1.setString("修习类别",select);
   queryDataSet7.executeQuery();
   jdbTable1.setDataSet(queryDataSet7);
      }else if((year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
        parameterRow1.setString("修习类别",select);
       queryDataSet8.executeQuery();
       jdbTable1.setDataSet(queryDataSet8);
     }else if((year.equals(""))&&(!xieqi.equals(""))&&(select.equals(""))){
       parameterRow1.setString("学期",xieqi);
      queryDataSet9.executeQuery();
      jdbTable1.setDataSet(queryDataSet9);
     }
     else if((!year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
           parameterRow1.setString("学年",year);
           parameterRow1.setString("修习类别",select);
           queryDataSet10.executeQuery();
           jdbTable1.setDataSet(queryDataSet10);
          }
}

  void jComboBox5_actionPerformed(ActionEvent e) {
    String year="";
     String xieqi="";
     String select="";
     if(jComboBox3.getSelectedIndex()==0){
       year="";

     }else{
      year=String.valueOf(jComboBox3.getSelectedItem());
     }
   if(jComboBox4.getSelectedIndex()==0){
    xieqi="";
   }else if(jComboBox4.getSelectedIndex()==1){
     xieqi="1";
   }else if(jComboBox4.getSelectedIndex()==2){
     xieqi="2";
   }
   if(jComboBox5.getSelectedIndex()==0){
        select="";
   }else{
   select=String.valueOf(jComboBox5.getSelectedItem());
   }
    if(year.equals("")&&xieqi.equals("")&&select.equals("")){
     jdbTable1.setDataSet(queryDataSet2);
    } if((!year.equals(""))&&xieqi.equals("")&&select.equals("")){
          parameterRow1.setString("学年",year);
          queryDataSet5.executeQuery();
           jdbTable1.setDataSet(queryDataSet5);
    }else if((!year.equals(""))&&(!xieqi.equals(""))&&select.equals("")){
          parameterRow1.setString("学年",year);
            parameterRow1.setString("学期",xieqi);
          queryDataSet6.executeQuery();
            jdbTable1.setDataSet(queryDataSet6);

    }else if((!year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学年",year);
      parameterRow1.setString("学期",xieqi);
      parameterRow1.setString("修习类别",select);
      queryDataSet4.executeQuery();
      jdbTable1.setDataSet(queryDataSet4);
    }else if((year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学期",xieqi);
   parameterRow1.setString("修习类别",select);
   queryDataSet7.executeQuery();
   jdbTable1.setDataSet(queryDataSet7);
      }else if((year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
        parameterRow1.setString("修习类别",select);
       queryDataSet8.executeQuery();
       jdbTable1.setDataSet(queryDataSet8);
     }else if((year.equals(""))&&(!xieqi.equals(""))&&(select.equals(""))){
       parameterRow1.setString("学期",xieqi);
      queryDataSet9.executeQuery();
      jdbTable1.setDataSet(queryDataSet9);
     }
     else if((!year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
           parameterRow1.setString("学年",year);
           parameterRow1.setString("修习类别",select);
           queryDataSet10.executeQuery();
           jdbTable1.setDataSet(queryDataSet10);
          }
}

  }



class studentFrame_jTextField3_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jTextField3_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField3_actionPerformed(e);
  }
}

class studentFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jButton1_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class studentFrame_jComboBox3_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jComboBox3_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox3_actionPerformed(e);
  }
}

class studentFrame_jComboBox4_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jComboBox4_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox4_actionPerformed(e);
  }
}

class studentFrame_jComboBox5_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jComboBox5_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox5_actionPerformed(e);
  }
}