fcoursesetting.java

中小学校园的教师

      while(rs.next())
      {
        jCBGrade.addItem(rs.getString("grade_name"));

      }

      sql = "SELECT * FROM course ";
      ps = con.prepareStatement(sql);
      rs = ps.executeQuery();
      int i=0;
      while(rs.next())
     {
       if(i<rowdata.length)
          {
            rowdata[i][0] = rs.getString("course_name");
            rowdata[i][1] = rs.getString("course_term");
            i++;
          }
     }





      DbUtil.close(rs);
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(con);
    }
    jCBChooseCouse.addItem("语文");
    jCBChooseCouse.addItem("数学");
    jCBChooseCouse.addItem("英语");
    jCBChooseCouse.addItem("物理");
    jCBChooseCouse.addItem("化学");


  }

  void jCBGrade_actionPerformed(ActionEvent e) {
    String sql =  "SELECT COUNT(class_id) AS class_count "+
        "FROM class "+
        "WHERE (grade_name = '"+jCBGrade.getSelectedItem().toString()+"')";
       Connection con = null;
    try{
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      System.out.print(sql) ;
      System.out.print(jCBGrade.getSelectedItem().toString()) ;
      ResultSet rs = ps.executeQuery();
      if(rs.next()){
        jTFClassNumber.setText(String.valueOf(rs.getInt("class_count")) );
      }

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

  }

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

  try{
  con = DBConnection.getConnection();
  System.out.print(jComboBox3.getSelectedIndex());
  int x=jComboBox3.getSelectedIndex()+1;
  sql="UPDATE dbo.course_set "+
       "SET term_id = '"+jCBTerm.getSelectedItem().toString()+"', course_set_end = '"+jTextField2.getText().toString()+"', course_set_start = '"+jTextField1.getText().toString()+"' "+
       "WHERE (course_set_id = "+x+") ";

      System.out.print(sql);


  Statement stmt=con.createStatement();
    rs=stmt.executeQuery(sql);
  while(rs.next())
  {
    System.out.print(rs.getString(1));
  }
    }catch(Exception ee){

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

  void jCBTerm_actionPerformed(ActionEvent e) {


  }

  void jButton1_actionPerformed(ActionEvent e) {
    String sql = "DELETE FROM dbo.course "+
                 "WHERE (course_name like '%"+jCBGrade.getSelectedItem().toString()+"%') AND (course_term = '"+jCBTerm.getSelectedItem().toString()+"') ";

        Connection con = null;
        try{
          con = DBConnection.getConnection();
          PreparedStatement ps = con.prepareStatement(sql);

          System.out.print(sql) ;
          ps.executeUpdate();
          DbUtil.close(ps);
        }catch(Exception ee){
          ee.printStackTrace();
        }finally{
          DbUtil.close(con);
        }
DB_DataModule.getDataModule().getQDSCourse() .refresh();
  }

  void jButton2_actionPerformed(ActionEvent e) {
    int x=jComboBox3.getSelectedIndex()+1;
    String sql = "UPDATE dbo.course_set "+
       "SET term_id = '', course_set_end = '', course_set_start = '' "+
       "WHERE (course_set_id = "+x+") ";

            Connection con = null;
            try{
              con = DBConnection.getConnection();
              PreparedStatement ps = con.prepareStatement(sql);

              System.out.print(sql) ;
              ps.executeUpdate();
              DbUtil.close(ps);
            }catch(Exception ee){
              ee.printStackTrace();
            }finally{
              DbUtil.close(con);
            }
    DB_DataModule.getDataModule().getQDSCourseSet().refresh();

  }

  void jCBTerm_itemStateChanged(ItemEvent e) {

  }

  void jButton3_actionPerformed(ActionEvent e) {
    String sql = null;
         Connection con = null;

         try{
           con = DBConnection.getConnection();
           sql = "SELECT * "+
                 "FROM dbo.course  "+
                 "WHERE (course_term = '"+jCBTerm.getSelectedItem().toString()+"') AND (course_name like '%"+jCBGrade.getSelectedItem().toString()+"%') ";
           //System.out.print(sql);
           PreparedStatement ps = con.prepareStatement(sql);
           ResultSet rs = ps.executeQuery();
           //ps = con.prepareStatement(sql);
           rs = ps.executeQuery();
           int i=0;
           for(int j=0;j<rowdata.length;j++)//重置表为空
          {
            for(int k=0;k<2;k++)
              rowdata[j][k]=null;
          }
          jTable1.repaint();


           while(rs.next())
           {
             if(i<rowdata.length)
                {
                  rowdata[i][0] = rs.getString("course_name");
                  rowdata[i][1] = rs.getString("course_term");
                  i++;
                }

           }

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

  }
}

class FCourseSetting_jBCourseAdd_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jBCourseAdd_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBCourseAdd_actionPerformed(e);
  }
}

class FCourseSetting_this_windowAdapter extends java.awt.event.WindowAdapter {
  FCourseSetting adaptee;

  FCourseSetting_this_windowAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void windowActivated(WindowEvent e) {
    adaptee.this_windowActivated(e);
  }
}

class FCourseSetting_jCBGrade_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jCBGrade_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCBGrade_actionPerformed(e);
  }
}

class FCourseSetting_jBTime_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jBTime_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBTime_actionPerformed(e);
  }
}

class FCourseSetting_jCBTerm_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jCBTerm_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCBTerm_actionPerformed(e);
  }
}

class FCourseSetting_jButton1_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jButton1_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class FCourseSetting_jButton2_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jButton2_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class FCourseSetting_jCBTerm_itemAdapter implements java.awt.event.ItemListener {
  FCourseSetting adaptee;

  FCourseSetting_jCBTerm_itemAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void itemStateChanged(ItemEvent e) {
    adaptee.jCBTerm_itemStateChanged(e);
  }
}

class FCourseSetting_jButton3_actionAdapter implements java.awt.event.ActionListener {
  FCourseSetting adaptee;

  FCourseSetting_jButton3_actionAdapter(FCourseSetting adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}