teacherframe.java~29~

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

    jPanel1.add(jPanel4, null);
    jPanel4.add(tableScrollPane1, null);
    jPanel2.add(jLabel5, null);
    jPanel2.add(jLabel6, null);
    jPanel2.add(jComboBox4, null);
    jPanel2.add(jLabel7, null);
    jPanel2.add(jLabel8, null);
    jPanel2.add(jComboBox6, null);
    jPanel2.add(jComboBox3, null);
    jPanel2.add(jComboBox5, null);
    jPanel2.add(jLabel9, null);
    jPanel2.add(jComboBox7, null);
    jPanel2.add(jButton3, null);
    jComboBox6.addItem("第一学期");
    jComboBox6.addItem("第二学期");
    queryDataSet8.executeQuery();
        int i1=queryDataSet8.rowCount();
         for(int a=0;a<i1;a++){
         jComboBox5.addItem(queryDataSet8.getString("学年"));
          queryDataSet8.next();
        }





    queryDataSet1.executeQuery();
   int i=queryDataSet1.rowCount();
    for(int a=0;a<i;a++){
     jComboBox1.addItem(queryDataSet1.getString("系部名"));
      jComboBox3.addItem(queryDataSet1.getString("系部名"));
     queryDataSet1.next();
   }

  }

  void jComboBox1_actionPerformed(ActionEvent e) {
    queryDataSet2.close();
       jComboBox2.removeAllItems();
       parameterRow1.setString("系部名",String.valueOf(jComboBox1.getSelectedItem()));
           queryDataSet2.executeQuery();
        int i=queryDataSet2.rowCount();
         for(int a=0;a<i;a++){
          jComboBox2.addItem(queryDataSet2.getString("班级名"));
          queryDataSet2.next();

  }
}

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

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

     }


  }

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

       if(!jTextField1.getText().trim().equals("")){
       parameterRow1.setString("学号",jTextField1.getText().trim());
       queryDataSet5.executeQuery();
       if(queryDataSet5.rowCount()>0){
          jdbTable1.setDataSet(queryDataSet5);
       }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());
        queryDataSet6.executeQuery();
        if(queryDataSet6.rowCount()>0){
        parameterRow1.setString("学号",queryDataSet6.getString("学号"));
        queryDataSet5.executeQuery();
        if(queryDataSet5.rowCount()>0){
          jdbTable1.setDataSet(queryDataSet5);
       }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 jButton3_actionPerformed(ActionEvent e) {
          Frame1 aa=new Frame1();
          aa.setSize(600,380);
           aa.show();
  }

  void jComboBox4_actionPerformed(ActionEvent e) {

  }

  void jComboBox3_actionPerformed(ActionEvent e) {
    queryDataSet2.close();
    queryDataSet9.close();
    jComboBox4.removeAllItems();
            parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
             queryDataSet2.executeQuery();
             int i=queryDataSet2.rowCount();
              for(int a=0;a<i;a++){
               jComboBox4.addItem(queryDataSet2.getString("班级名"));
               queryDataSet2.next();
              }
             parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
             parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
             parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
             parameterRow1.setString("学期",String.valueOf(jComboBox6.getSelectedItem()));
             parameterRow1.setString("任课老师号",teacherNo);
            queryDataSet9.executeQuery();
             int i2=queryDataSet9.rowCount();
             if(i2>0){
             for(int a=0;a<i2;a++){
              jComboBox7.addItem(queryDataSet9.getString("课程名"));
              queryDataSet9.next();
             }}

  }

 }

class teacherFrame_jComboBox1_actionAdapter implements java.awt.event.ActionListener {
  teacherFrame adaptee;

  teacherFrame_jComboBox1_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox1_actionPerformed(e);
  }
}

class teacherFrame_jComboBox2_actionAdapter implements java.awt.event.ActionListener {
  teacherFrame adaptee;

  teacherFrame_jComboBox2_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox2_actionPerformed(e);
  }
}

class teacherFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  teacherFrame adaptee;

  teacherFrame_jButton1_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class teacherFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  teacherFrame adaptee;

  teacherFrame_jButton3_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class teacherFrame_jComboBox4_actionAdapter implements java.awt.event.ActionListener {
  teacherFrame adaptee;

  teacherFrame_jComboBox4_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox4_actionPerformed(e);
  }
}

class teacherFrame_jComboBox3_actionAdapter implements java.awt.event.ActionListener {
  teacherFrame adaptee;

  teacherFrame_jComboBox3_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox3_actionPerformed(e);
  }
}