mutaoyouangframe.java~60~

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

   }

  void jComboBox2_actionPerformed(ActionEvent e) {
    queryDataSet4.close();
     queryDataSet5.close();
    parameterRow1.setString("班级名", String.valueOf(jComboBox2.getSelectedItem()));

    queryDataSet4.executeQuery();
   if(queryDataSet4.rowCount()>0){
    int i = queryDataSet4.rowCount();
    String b = "";
    for (int a = 0; a < i; a++) {
      b= b + "\'"+queryDataSet4.getString("学号") + "\',";
      queryDataSet4.next();
    }
    b = b.substring(0, b.length() - 1);
    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stumessage where 学号 in ("+b+")", null, true, Load.ALL));
   jdbTable1.setDataSet(queryDataSet5);

  }


  }

  void jButton1_actionPerformed(ActionEvent e) {
  queryDataSet8.close();
    queryDataSet7.close();
    queryDataSet6.close();
    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);
         }
          }

    if(!jTextField1.getText().trim().equals("")){
    parameterRow1.setString("学号",jTextField1.getText().trim());
    queryDataSet6.executeQuery();
    if(queryDataSet6.rowCount()>0){
       jdbTable1.setDataSet(queryDataSet6);
    }else{
    JOptionPane.showMessageDialog(this,"学号不存在","信息提示",2);
    }
    }
   if(jTextField1.getText().trim().equals("")&&(!jTextField2.getText().trim().equals(""))){
     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){
       jdbTable1.setDataSet(queryDataSet6);
    }else{
    JOptionPane.showMessageDialog(this,"学生信息不存在","信息提示",2);
    }
  }else{
  JOptionPane.showMessageDialog(this,String.valueOf(jComboBox2.getSelectedItem())+"不存在学生"+jTextField2.getText().trim(),"信息提示",2);
  }
  }
 if(jTextField1.getText().trim().equals("")&&(jTextField2.getText().trim().equals(""))){
  JOptionPane.showMessageDialog(this,"学号或姓名","信息提示",2);
 }

}

  void jComboBox3_actionPerformed(ActionEvent e) {
    queryDataSet3.close();
   jComboBox4.removeAllItems();
   parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
       queryDataSet3.executeQuery();
    int i1=queryDataSet3.rowCount();
     for(int a=0;a<i1;a++){
      jComboBox4.addItem(queryDataSet3.getString("班级名"));
      queryDataSet3.next();

    }
    queryDataSet4.close();
       queryDataSet9.close();
       parameterRow1.setString("班级名", String.valueOf(jComboBox4.getSelectedItem()));

       queryDataSet4.executeQuery();
      if(queryDataSet4.rowCount()>0){
       int i = queryDataSet4.rowCount();
       String c = "";
       for (int a = 0; a < i; a++) {
         c= c + "\'"+queryDataSet4.getString("学号") + "\',";
         queryDataSet4.next();
       }
       c = c.substring(0, c.length() - 1);

       queryDataSet9.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stu_score where 学号 in ("+c+")", null, true, Load.ALL));
        queryDataSet9.executeQuery();
       jdbTable2.setDataSet(queryDataSet9);

     }


  }

  void jComboBox4_actionPerformed(ActionEvent e) {
       queryDataSet4.close();
        queryDataSet9.close();
        parameterRow1.setString("班级名", String.valueOf(jComboBox4.getSelectedItem()));

        queryDataSet4.executeQuery();
       if(queryDataSet4.rowCount()>0){
        int i = queryDataSet4.rowCount();
        String c = "";
        for (int a = 0; a < i; a++) {
          c= c + "\'"+queryDataSet4.getString("学号") + "\',";
          queryDataSet4.next();
        }
        c = c.substring(0, c.length() - 1);

        queryDataSet9.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from stu_score where 学号 in ("+c+")", null, true, Load.ALL));
         queryDataSet9.executeQuery();
        jdbTable2.setDataSet(queryDataSet9);

      }


  }

  void jTextField1_actionPerformed(ActionEvent e) {

  }

  void jButton3_actionPerformed(ActionEvent e) {
    queryDataSet8.close();
  queryDataSet7.close();
  queryDataSet10.close();
  if((!jTextField3.getText().trim().equals(""))&&(!jTextField4.getText().trim().equals(""))){
      parameterRow1.setString("学号",jTextField3.getText().trim());
       parameterRow1.setString("姓名",jTextField4.getText().trim());
       queryDataSet8.executeQuery();
       if(!(queryDataSet8.rowCount()>0)){
        JOptionPane.showMessageDialog(this,"学号或姓名输入有误","信息提示",2);
       }
        }

  if(!jTextField3.getText().trim().equals("")){
  parameterRow1.setString("学号",jTextField3.getText().trim());
  queryDataSet10.executeQuery();
  if(queryDataSet10.rowCount()>0){
     jdbTable2.setDataSet(queryDataSet10);
  }else{
  JOptionPane.showMessageDialog(this,"学号不存在","信息提示",2);
  }
  }
 if(jTextField3.getText().trim().equals("")&&(!jTextField4.getText().trim().equals(""))){
   parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
   parameterRow1.setString("姓名",jTextField4.getText().trim());
   queryDataSet7.executeQuery();
   if(queryDataSet7.rowCount()>0){
   parameterRow1.setString("学号",queryDataSet7.getString("学号"));
   queryDataSet10.executeQuery();
   if(queryDataSet10.rowCount()>0){
     jdbTable2.setDataSet(queryDataSet10);
  }else{
  JOptionPane.showMessageDialog(this,"学生信息不存在","信息提示",2);
  }
}else{
JOptionPane.showMessageDialog(this,String.valueOf(jComboBox4.getSelectedItem())+"不存在学生"+jTextField4.getText().trim(),"信息提示",2);
}
}
if(jTextField3.getText().trim().equals("")&&(jTextField4.getText().trim().equals(""))){
JOptionPane.showMessageDialog(this,"学号或姓名","信息提示",2);
}

  }

  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) {
   if(jTextField3.getText().trim().equals("")&&(jTextField4.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());
            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);
            }
             }


  }
  }


}

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