fgradeclasssetting.java

中小学校园的教师

      }
      DbUtil.close(rs);
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(con);
    }

    for(int i=1;i<=10;i++){
      jCBClassNum.addItem(String.valueOf(i));
    }

    //添加学年
    jCBTermYear.addItem("2006-2007") ;
    jCBTermYear.addItem("2007-2008") ;
    jCBTermYear.addItem("2008-2009") ;
    jCBTermYear.addItem("2009-2010") ;
    jCBTermYear.addItem("2010-2011") ;
    jCBTermNo.addItem("1") ;
    jCBTermNo.addItem("2") ;
    jCBTermNo.addItem("3") ;
    jCBTermNo.addItem("4") ;

    }

  void jBClassAdd_actionPerformed(ActionEvent e) {

    Connection con = null;
    PreparedStatement ps =null;
    String sql =null;
    ResultSet rs=null;
    try{
      con = DBConnection.getConnection();
      for(int i=0;i<=jCBClassNum.getSelectedIndex();i++){


        if(i==0){
              sql = "SELECT * "+
              "FROM class "+
              "WHERE (grade_name = ?)";

          ps = con.prepareStatement(sql);
          ps.setString(1, jCBGrade.getSelectedItem().toString()   );
          System.out.print(sql) ;
          System.out.print(String.valueOf(jCBGrade.getSelectedIndex()+1)) ;
          rs = ps.executeQuery();
          if(rs.next()){
            JOptionPane.showMessageDialog(null," 该年级已设置班级\n  如要修改请重置");
            break;
          }
        }

        sql = "INSERT INTO class "+
             "(grade_name, class_name)"+
             "VALUES ( ?,?)";

        ps = con.prepareStatement(sql);
        ps.setString(1, jCBGrade.getSelectedItem().toString() );
        ps.setString(2, jCBGrade.getSelectedItem().toString()+String.valueOf(i+1)+"班");

        System.out.print(sql) ;
        System.out.print(jCBGrade.getSelectedItem().toString()) ;
        System.out.print(jCBGrade .getSelectedItem().toString()+String.valueOf(i+1)+"班") ;
        ps.executeUpdate();
      }
      //jTGrade;
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(con);
    }
    DB_DataModule.getDataModule().getQDSGradeClass().refresh();

    }

  void jBClass_Reset_actionPerformed(ActionEvent e) {
    String sql = "DELETE FROM class WHERE (grade_name = ?) ";

    Connection con = null;
    try{
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, jCBGrade.getSelectedItem().toString() );
      System.out.print(sql) ;
      ps.executeUpdate();
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(con);
    }
    //更新数据库

    DB_DataModule.getDataModule().getQDSGradeClass().refresh();
  }

  void jdbCBclass_actionPerformed(ActionEvent e) {




  }

  void jdbCBclass_itemStateChanged(ItemEvent e) {


  }

  void jBTermAdd_actionPerformed(ActionEvent e) {
    String sql = "INSERT INTO term (term_id) VALUES (?) ";

    Connection con = null;
    try{
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, jCBTermYear.getSelectedItem().toString() +"_"+jCBTermNo.getSelectedItem().toString() );
      System.out.print(sql) ;
      System.out.print(jCBTermYear.getSelectedItem().toString() +"_"+jCBTermNo.getSelectedItem().toString()) ;
      ps.executeUpdate();
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
      JOptionPane.showMessageDialog(null," 该学期以存在，请勿重复添加");

    }finally{
      DB_DataModule.getDataModule().getQDSTerm() .refresh();
      DbUtil.close(con);
    }

  }

  void jBGrademasterSet_actionPerformed(ActionEvent e) {
    String text=null;
    Connection con = null;
    PreparedStatement ps =null;
    String sql =null;
    ResultSet rs=null;

 try{
 con = DBConnection.getConnection();
 sql="UPDATE grade "+
     "SET grade_master = '"+jdbCBGrademaster.getSelectedItem().toString() +" '"+
     "WHERE (grade_name = '"+jCBGrade.getSelectedItem().toString() +"')";
     Statement stmt=con.createStatement();
   rs=stmt.executeQuery(sql);
 while(rs.next())
 {
   System.out.print(rs.getString(1));
 }
   }catch(Exception ee){

 }finally{
   DbUtil.close(con);
 }

  }

  void jBClassmasterSet_actionPerformed(ActionEvent e) {
    String text=null;
    Connection con = null;
    PreparedStatement ps =null;
    String sql =null;
    ResultSet rs=null;

 try{
 con = DBConnection.getConnection();
 sql="UPDATE class "+
     "SET class_master = '"+jdbCBClassmaster.getSelectedItem().toString() +" '"+
     "WHERE (class_name = '"+jdbCBclass.getSelectedItem().toString() +"')";
     Statement stmt=con.createStatement();
   rs=stmt.executeQuery(sql);
 while(rs.next())
 {
   System.out.print(rs.getString(1));
 }
   }catch(Exception ee){

 }finally{
   DbUtil.close(con);
 }


  }


  }




class FgradeclassSetting_jCBGrade_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jCBGrade_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCBGrade_actionPerformed(e);
  }
}

class FgradeclassSetting_this_windowAdapter extends java.awt.event.WindowAdapter {
  FgradeclassSetting adaptee;

  FgradeclassSetting_this_windowAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void windowActivated(WindowEvent e) {
    adaptee.this_windowActivated(e);

  }
  public void windowOpened(WindowEvent e) {
    adaptee.this_windowOpened(e);
  }
}

class FgradeclassSetting_jBClassAdd_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jBClassAdd_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBClassAdd_actionPerformed(e);
  }
}

class FgradeclassSetting_jBClass_Reset_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jBClass_Reset_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBClass_Reset_actionPerformed(e);
  }
}

class FgradeclassSetting_jdbCBclass_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jdbCBclass_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jdbCBclass_actionPerformed(e);
  }
}

class FgradeclassSetting_jdbCBclass_itemAdapter implements java.awt.event.ItemListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jdbCBclass_itemAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void itemStateChanged(ItemEvent e) {
    adaptee.jdbCBclass_itemStateChanged(e);
  }
}

class FgradeclassSetting_jBTermAdd_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jBTermAdd_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBTermAdd_actionPerformed(e);
  }
}

class FgradeclassSetting_jBGrademasterSet_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jBGrademasterSet_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBGrademasterSet_actionPerformed(e);
  }
}

class FgradeclassSetting_jBClassmasterSet_actionAdapter implements java.awt.event.ActionListener {
  FgradeclassSetting adaptee;

  FgradeclassSetting_jBClassmasterSet_actionAdapter(FgradeclassSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBClassmasterSet_actionPerformed(e);
  }
}