mutaoyouangframe.java

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

    jPanel1.add(jTextField1, null);
    jPanel1.add(jButton7, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton2, null);
    jPanel1.add(jButton8, null);
    jTabbedPane1.add(jPanel2,   "成绩查询");
    jPanel2.add(jLabel5, null);
    jPanel2.add(jLabel6, null);
    jPanel2.add(jLabel8, null);
    jPanel2.add(jLabel7, null);
    jPanel2.add(jComboBox3, null);
    jPanel2.add(jComboBox4, null);
    jPanel2.add(jTextField3, null);
    jPanel2.add(jTextField4, null);
    jPanel2.add(jButton3, null);
    jPanel2.add(jButton4, null);
    jPanel2.add(jPanel5, null);
    jPanel5.add(tableScrollPane2, null);
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jTabbedPane1.add(jPanel3,   "密码修改");
    jPanel3.add(jPasswordField2, null);
    jPanel3.add(jLabel9, null);
    jPanel3.add(jPasswordField1, null);
    jPanel3.add(jLabel10, null);
    jPanel3.add(jLabel11, null);
    jPanel3.add(jPasswordField3, null);
    jPanel3.add(jButton6, null);
    jPanel3.add(jButton5, null);
    queryDataSet2.executeQuery();
    int i=queryDataSet2.rowCount();
     for(int a=0;a<i;a++){
      jComboBox1.addItem(queryDataSet2.getString("系部名"));
      jComboBox3.addItem(queryDataSet2.getString("系部名"));
      queryDataSet2.next();
    }

  }

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

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