mutaoyouangframe.java~66~

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

}

  }

  void jButton5_actionPerformed(ActionEvent e) {
    parameterRow1.setString("enterNum",queryDataSet.getString("enterNum"));
       parameterRow1.setString("liebie",leibie);

       queryDataSet11.executeQuery();
      if(jPasswordField1.getText().trim().equals("")||jPasswordField2.getText().trim().equals("")||jPasswordField3.getText().trim().equals("")){
       JOptionPane.showMessageDialog(this,"请输入完整","信息提示",2);
      }else{
       if(queryDataSet11.getString("password").equals(jPasswordField1.getText().trim())){
         if(jPasswordField2.getText().trim().equals(jPasswordField3.getText().trim())){
         String sql="update entermessage set password='"+jPasswordField2.getText().trim()+"' where enterNum='"+queryDataSet.getString("enterNum")+"' and liebie='"+leibie+"'";
         database1.executeStatement(sql);
         JOptionPane.showMessageDialog(this,"修改成功");
       }else{
          JOptionPane.showMessageDialog(this,"两次输入密码不相同","信息提示",2);
        }
        }else{
         JOptionPane.showMessageDialog(this,"密码错误","信息提示",2);
        }

     }

  }

  void jButton7_actionPerformed(ActionEvent e) {
    queryDataSet12.close();
    queryDataSet8.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)){
              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);
            }
             }


  }

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