teacherframe.java~38~

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

      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) {
    queryDataSet10.close();
    String xieqi;
       if(jComboBox6.getSelectedIndex()==0){
        xieqi="1";
     }else{
       xieqi="2";
     }
        parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
        parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
        parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
        parameterRow1.setString("学期",xieqi);
        parameterRow1.setString("任课老师号",teacherNo);
        parameterRow1.setString("课程名",String.valueOf(jComboBox7.getSelectedItem()));
        queryDataSet10.executeQuery();
        if( queryDataSet10.rowCount()>0){
         Frame1 aa=new Frame1( queryDataSet10.getString("学年"),queryDataSet10.getString("学期"),queryDataSet10.getString("课程名"),queryDataSet10.getString("课程学分"),queryDataSet10.getString("学时"),queryDataSet10.getString("修习类别"),queryDataSet10.getString("成绩类型"),queryDataSet10.getString("班级"));
          aa.setSize(600,380);
          aa.show();
  }}

  void jComboBox4_actionPerformed(ActionEvent e) {
    jComboBox7.removeAllItems();
    String xieqi;
        if(jComboBox6.getSelectedIndex()==0){
         xieqi="1";
      }else{
        xieqi="2";
      }
       parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
       parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
       parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
       parameterRow1.setString("学期",xieqi);
       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();
       }}

  }

  void jComboBox3_actionPerformed(ActionEvent e) {
 jComboBox7.removeAllItems();
    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();
              }
           String xieqi;
              if(jComboBox6.getSelectedIndex()==0){
               xieqi="1";
            }else{
              xieqi="2";
            }
          if(leibie=="老师") {
            parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
             parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
             parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
             parameterRow1.setString("学期",xieqi);
             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();
             }}}
         if(leibie=="学生管理处"){
           parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
               parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
               parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
               parameterRow1.setString("学期",xieqi);

               queryDataSet11.executeQuery();
               int i2=queryDataSet11.rowCount();
               if(i2>0){
               for(int a=0;a<i2;a++){
                jComboBox7.addItem(queryDataSet9.getString("课程名"));
                queryDataSet11.next();
               }}


         }

  }

  void jComboBox5_actionPerformed(ActionEvent e) {
 jComboBox7.removeAllItems();
    String xieqi;
               if(jComboBox6.getSelectedIndex()==0){
                xieqi="1";
             }else{
               xieqi="2";
             }
              parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
              parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
              parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
              parameterRow1.setString("学期",xieqi);
              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();
              }}

  }

  void jComboBox6_actionPerformed(ActionEvent e) {
     jComboBox7.removeAllItems();
    String xieqi;
               if(jComboBox6.getSelectedIndex()==0){
                xieqi="1";
             }else{
               xieqi="2";
             }
              parameterRow1.setString("系部名",String.valueOf(jComboBox3.getSelectedItem()));
              parameterRow1.setString("班级名",String.valueOf(jComboBox4.getSelectedItem()));
              parameterRow1.setString("学年",String.valueOf(jComboBox5.getSelectedItem()));
              parameterRow1.setString("学期",xieqi);
              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);
  }
}

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

  teacherFrame_jComboBox5_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox5_actionPerformed(e);
  }
}

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

  teacherFrame_jComboBox6_actionAdapter(teacherFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox6_actionPerformed(e);
  }
}