studentframe.java~68~

学生管理系统:有辅导员登入,学生登入和老师登入界面

         +",'"+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);
          }
}

  void jTextField1_actionPerformed(ActionEvent e) {

  }

  void jButton3_actionPerformed(ActionEvent e) {
     String s=jTextField1.getText().trim();
     if(s.equals("")){
     JOptionPane.showMessageDialog(this,"请输入课程名","信息提示",2);
     }else{
       parameterRow1.setString("课程名",s);
       queryDataSet11.executeQuery();
       if(queryDataSet11.rowCount()!=0){
        jdbTable1.setDataSet(queryDataSet11);
       }else{
        JOptionPane.showMessageDialog(this,"没有该课程信息","信息提示",2);
       }
     }
  }

  }



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);
  }
}

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

  studentFrame_jTextField1_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField1_actionPerformed(e);
  }
}

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

  studentFrame_jButton3_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}