studentframe.java~64~

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

    queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 学年=:学年 and 学期=:学期 and 修习类别=:修习类别 and " +
      "学号=:学号", parameterRow1, true, Load.ALL));
    queryDataSet5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 学年=:学年 and 学号=:学号", parameterRow1, true, Load.ALL));
    queryDataSet6.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 学年=:学年 and 学期=:学期 and 学号=:学号", parameterRow1, true, Load.ALL));
    queryDataSet7.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score wheree  学期=:学期 and 修习类别=:修习类别 and 学号=:学号", parameterRow1, true, Load.ALL));
    queryDataSet9.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where  学期=:学期 and 学号=:学号", parameterRow1, true, Load.ALL));
    queryDataSet10.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 学年=:学年 and 修习类别=:修习类别 and 学号=:学号", parameterRow1, true, Load.ALL));
    queryDataSet8.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database, "select * from stu_score where 修习类别=:修习类别 and 学号=:学号", parameterRow1, true, Load.ALL));
    jTabbedPane1.add(jPanel1,   "学生基本信息");
    jPanel1.add(jLabel1, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jTextField3, null);
    jPanel1.add(jLabel5, null);
    jPanel1.add(jComboBox2, null);
    jPanel1.add(jTextField6, null);
    jPanel1.add(jLabel8, null);
    jPanel1.add(jTextField5, null);
    jPanel1.add(jLabel7, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jTextField2, null);
    jPanel1.add(jTextField8, null);
    jPanel1.add(jLabel10, null);
    jPanel1.add(jTextField7, null);
    jPanel1.add(jLabel9, null);
    jPanel1.add(jLabel6, null);
    jPanel1.add(jTextField4, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton2, null);
    jPanel1.add(jLabel11, null);
    jPanel1.add(jComboBox1, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jLabel12, null);
    jPanel1.add(jLabel13, null);
    jTabbedPane1.add(jPanel2, "成绩查询");
    jPanel2.add(jPanel4, null);
    jPanel4.add(tableScrollPane1, null);
    jPanel2.add(jLabel14, null);
    jPanel2.add(jLabel17, null);
    jPanel2.add(jComboBox3, null);
    jPanel2.add(jComboBox5, null);
    jPanel2.add(jLabel15, null);
    jPanel2.add(jLabel16, null);
    jPanel2.add(jTextField1, null);
    jPanel2.add(jComboBox4, null);
    jPanel2.add(jButton3, null);
    jComboBox3.addItem("所有学年");
    jComboBox3.addItem("2003-2004学年度");
    jComboBox3.addItem("2004-2005学年度");
    jComboBox3.addItem("2005-2006学年度");
    jComboBox3.addItem("2006-2007学年度");
    jComboBox3.addItem("2007-2008学年度");
    jComboBox4.addItem("所有学期");
    jComboBox4.addItem("第一学期");
    jComboBox4.addItem("第二学期");
    jComboBox5.addItem("所有");
    jComboBox5.addItem("必修");
    jComboBox5.addItem("选修");
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jTabbedPane1.add(jPanel3, "密码修改");
    this.getContentPane().add(jTabbedPane1, null);
    jTabbedPane1.setSelectedIndex(0);
   parameterRow1.setString("学号",queryDataSet1.getString("学号"));
    jdbTable1.setDataSet(queryDataSet2);
  }
public void a(){
jLabel12.setText(queryDataSet1.getString("姓名"));
jLabel13.setText(queryDataSet1.getString("学号"));
if(queryDataSet.rowCount()>0){
jComboBox1.setSelectedItem(queryDataSet.getString("性别"));
jTextField2.setText(queryDataSet.getString("身份证号"));
String date=String.valueOf(queryDataSet.getTimestamp("出生日期")).substring(0,10);
jTextField3.setText(date);
jComboBox2.setSelectedItem(queryDataSet.getString("政治面貌"));
jTextField5.setText(queryDataSet.getString("个人电话"));
jTextField4.setText(queryDataSet.getString("籍贯"));
jTextField6.setText(queryDataSet.getString("家庭电话"));
jTextField8.setText(queryDataSet.getString("家庭邮编"));
jTextField7.setText(queryDataSet.getString("家庭住址"));
}
}

  void jTextField3_actionPerformed(ActionEvent e) {

  }

  void jButton1_actionPerformed(ActionEvent e){
     String sql="delete from stumessage where 学号='"+jLabel13.getText().trim()+"'";

     database.executeStatement(sql);
     if(!(jTextField3.getText().trim().equals(""))){
     String sql1="insert into stumessage values('"+jLabel13.getText().trim()
         +"','"+jLabel12.getText().trim()+"','"+jComboBox1.getSelectedItem()
         +"','"+jTextField2.getText().trim()+"',"+jTextField3.getText().trim()
         +",'"+jComboBox2.getSelectedItem()+"','"+jTextField4.getText().trim()
         +"','"+jTextField5.getText().trim()+"','"+jTextField6.getText().trim()
         +"','"+jTextField7.getText().trim()+"','"+jTextField8.getText().trim()
          +"')";
        database.executeStatement(sql1);
         }else{
        String sql1="insert into stumessage (学号,姓名,性别,身份证号,政治面貌,籍贯,个人电话,家庭电话,家庭住址,家庭邮编) values('"+jLabel13.getText().trim()
         +"','"+jLabel12.getText().trim()+"','"+jComboBox1.getSelectedItem()
         +"','"+jTextField2.getText().trim()+"',"+"'"+jComboBox2.getSelectedItem()+"','"+jTextField4.getText().trim()
         +"','"+jTextField5.getText().trim()+"','"+jTextField6.getText().trim()
         +"','"+jTextField7.getText().trim()+"','"+jTextField8.getText().trim()
         +"')";
              database.executeStatement(sql1);

            }




  }

  void jComboBox3_actionPerformed(ActionEvent e) {
    String year="";
     String xieqi="";
     String select="";
     if(jComboBox3.getSelectedIndex()==0){
       year="";

     }else{
      year=String.valueOf(jComboBox3.getSelectedItem());
     }
   if(jComboBox4.getSelectedIndex()==0){
    xieqi="";
   }else if(jComboBox4.getSelectedIndex()==1){
     xieqi="1";
   }else if(jComboBox4.getSelectedIndex()==2){
     xieqi="2";
   }
   if(jComboBox5.getSelectedIndex()==0){
        select="";
   }else{
   select=String.valueOf(jComboBox5.getSelectedItem());
   }
    if(year.equals("")&&xieqi.equals("")&&select.equals("")){
     jdbTable1.setDataSet(queryDataSet2);
    } if((!year.equals(""))&&xieqi.equals("")&&select.equals("")){
          parameterRow1.setString("学年",year);
          queryDataSet5.executeQuery();
           jdbTable1.setDataSet(queryDataSet5);
    }else if((!year.equals(""))&&(!xieqi.equals(""))&&select.equals("")){
          parameterRow1.setString("学年",year);
            parameterRow1.setString("学期",xieqi);
          queryDataSet6.executeQuery();
            jdbTable1.setDataSet(queryDataSet6);

    }else if((!year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学年",year);
      parameterRow1.setString("学期",xieqi);
      parameterRow1.setString("修习类别",select);
      queryDataSet4.executeQuery();
      jdbTable1.setDataSet(queryDataSet4);
    }else if((year.equals(""))&&(!xieqi.equals(""))&&(!select.equals(""))){
      parameterRow1.setString("学期",xieqi);
   parameterRow1.setString("修习类别",select);
   queryDataSet7.executeQuery();
   jdbTable1.setDataSet(queryDataSet7);
      }else if((year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
        parameterRow1.setString("修习类别",select);
       queryDataSet8.executeQuery();
       jdbTable1.setDataSet(queryDataSet8);
     }/*else if((year.equals(""))&&(!xieqi.equals(""))&&(select.equals(""))){
       parameterRow1.setString("学期",xieqi);
      queryDataSet9.executeQuery();
      jdbTable1.setDataSet(queryDataSet9);
     }
     else if((!year.equals(""))&&(xieqi.equals(""))&&(!select.equals(""))){
           parameterRow1.setString("学年",year);
           parameterRow1.setString("修习类别",select);
           queryDataSet10.executeQuery();
           jdbTable1.setDataSet(queryDataSet10);
          }*/
}}

class studentFrame_jTextField3_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jTextField3_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jTextField3_actionPerformed(e);
  }
}

class studentFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jButton1_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class studentFrame_jComboBox3_actionAdapter implements java.awt.event.ActionListener {
  studentFrame adaptee;

  studentFrame_jComboBox3_actionAdapter(studentFrame adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jComboBox3_actionPerformed(e);
  }
}