mutaoyouangframe.java

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

    a.show();}
    if(!(jTextField1.getText().trim().equals(""))&&!(jTextField2.getText().trim().equals(""))){

        parameterRow1.setString("学号",jTextField1.getText().trim());
        parameterRow1.setString("姓名",jTextField2.getText().trim());
        queryDataSet8.executeQuery();
        if(!(queryDataSet8.rowCount()>0)){
         JOptionPane.showMessageDialog(this,"学号或姓名输入有误","信息提示",2);
           return;
       }

            parameterRow1.setString("学号",jTextField1.getText().trim());
            parameterRow1.setString("姓名",jTextField2.getText().trim());
            queryDataSet12.executeQuery();
            if((queryDataSet12.rowCount()>0)){
              Frame2 a1=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"修改",jTextField1.getText().trim(),jTextField2.getText().trim())  ;
                  a1.setSize(600,400);
                    a1.show();

            }else{
             JOptionPane.showMessageDialog(this,"此学生信息不存在","信息提示",2);
            }
             }
             if(!(jTextField1.getText().trim().equals(""))&&(jTextField2.getText().trim().equals(""))){
         queryDataSet13.close();
          queryDataSet12.close();
        parameterRow1.setString("学号",jTextField1.getText().trim());
        queryDataSet13.executeQuery();
        if(queryDataSet13.rowCount()>0){
         parameterRow1.setString("姓名",String.valueOf(queryDataSet13.getString("姓名")));
         queryDataSet12.executeQuery();
              if((queryDataSet12.rowCount()>0)){
                Frame2 a1=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"修改",jTextField1.getText().trim(),String.valueOf(queryDataSet13.getString("姓名")))  ;
                       a1.setSize(600,400);
                       a1.show();


              }else{
                JOptionPane.showMessageDialog(this,"此学生信不存在","信息提示",2);

             }
         }else{
        JOptionPane.showMessageDialog(this,"此学号不存在","信息提示",2);
        }

                 }
                 if((jTextField1.getText().trim().equals(""))&&!(jTextField2.getText().trim().equals(""))){
                     queryDataSet7.close();
                     queryDataSet6.close();
                     parameterRow1.setString("班级名",String.valueOf(jComboBox2.getSelectedItem()));
                     parameterRow1.setString("姓名",jTextField2.getText().trim());
                      queryDataSet7.executeQuery();
                      if(queryDataSet7.rowCount()>0){
                       parameterRow1.setString("学号",queryDataSet7.getString("学号"));
                       queryDataSet6.executeQuery();
                       if(queryDataSet6.rowCount()>0){
                         Frame2 a1=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"修改",queryDataSet7.getString("学号"),jTextField2.getText().trim())  ;
                                     a1.setSize(600,400);
                                     a1.show();

                         }else{

                           JOptionPane.showMessageDialog(this,"学生信息不存在","信息提示",2);
                          }
                            }else{
                               JOptionPane.showMessageDialog(this,String.valueOf(jComboBox2.getSelectedItem())+"不存在学生"+jTextField2.getText().trim(),"信息提示",2);
                            }

                   }






  }

  void jButton8_actionPerformed(ActionEvent e) {
     queryDataSet8.close();
      queryDataSet12.close();
    if((jTextField1.getText().trim().equals(""))&&(jTextField2.getText().trim().equals(""))){
       Frame2 a=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"录入","","")  ;
        a.setSize(600,400);
        a.show();}
       if(!(jTextField1.getText().trim().equals(""))&&!(jTextField2.getText().trim().equals(""))){
       parameterRow1.setString("学号",jTextField1.getText().trim());
       parameterRow1.setString("姓名",jTextField2.getText().trim());
       queryDataSet8.executeQuery();
       if(!(queryDataSet8.rowCount()>0)){
       JOptionPane.showMessageDialog(this,"学号或姓名输入有误","信息提示",2);
          return;
      }


          parameterRow1.setString("学号",jTextField1.getText().trim());
                parameterRow1.setString("姓名",jTextField2.getText().trim());
                queryDataSet12.executeQuery();
                if((queryDataSet12.rowCount()>0)){
                   JOptionPane.showMessageDialog(this,"此学生信息已存在","信息提示",2);

                }else{

                 Frame2 a1=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"录入",jTextField1.getText().trim(),jTextField2.getText().trim())  ;
                         a1.setSize(600,400);
                         a1.show();

               }
                 }
      if(!(jTextField1.getText().trim().equals(""))&&(jTextField2.getText().trim().equals(""))){
         queryDataSet13.close();
          queryDataSet12.close();
        parameterRow1.setString("学号",jTextField1.getText().trim());
        queryDataSet13.executeQuery();
        if(queryDataSet13.rowCount()>0){
         parameterRow1.setString("姓名",String.valueOf(queryDataSet13.getString("姓名")));
         queryDataSet12.executeQuery();
              if((queryDataSet12.rowCount()>0)){
                 JOptionPane.showMessageDialog(this,"此学生信息已存在","信息提示",2);

              }else{
               Frame2 a1=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"录入",jTextField1.getText().trim(),String.valueOf(queryDataSet13.getString("姓名")))  ;
                       a1.setSize(600,400);
                       a1.show();
             }
         }else{
        JOptionPane.showMessageDialog(this,"此学号不存在","信息提示",2);
        }

                 }

      if((jTextField1.getText().trim().equals(""))&&!(jTextField2.getText().trim().equals(""))){
        queryDataSet7.close();
        queryDataSet6.close();
        parameterRow1.setString("班级名",String.valueOf(jComboBox2.getSelectedItem()));
        parameterRow1.setString("姓名",jTextField2.getText().trim());
         queryDataSet7.executeQuery();
         if(queryDataSet7.rowCount()>0){
          parameterRow1.setString("学号",queryDataSet7.getString("学号"));
          queryDataSet6.executeQuery();
          if(queryDataSet6.rowCount()>0){
           JOptionPane.showMessageDialog(this,"学生信息已存在","信息提示",2);
            }else{
              Frame2 a1=new Frame2 (String.valueOf(jComboBox2.getSelectedItem()),"录入",queryDataSet7.getString("学号"),jTextField2.getText().trim())  ;
                       a1.setSize(600,400);
                       a1.show();

             }
               }else{
                  JOptionPane.showMessageDialog(this,String.valueOf(jComboBox2.getSelectedItem())+"不存在学生"+jTextField2.getText().trim(),"信息提示",2);
               }

      }

  }



}

class mutaoyouangFrame_jComboBox1_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jComboBox1_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox1_actionPerformed(e);
  }
}

class mutaoyouangFrame_jComboBox2_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jComboBox2_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox2_actionPerformed(e);
  }
}

class mutaoyouangFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jButton1_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class mutaoyouangFrame_jComboBox3_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jComboBox3_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox3_actionPerformed(e);
  }
}

class mutaoyouangFrame_jComboBox4_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jComboBox4_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox4_actionPerformed(e);
  }
}

class mutaoyouangFrame_jTextField1_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jTextField1_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField1_actionPerformed(e);
  }
}

class mutaoyouangFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jButton3_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class mutaoyouangFrame_jButton5_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jButton5_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class mutaoyouangFrame_jButton7_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jButton7_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton7_actionPerformed(e);
  }
}

class mutaoyouangFrame_jButton8_actionAdapter implements java.awt.event.ActionListener {
  mutaoyouangFrame adaptee;

  mutaoyouangFrame_jButton8_actionAdapter(mutaoyouangFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton8_actionPerformed(e);
  }
}