fgradeclasssetting.java

中小学校园的教师

package untitled2;


import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import com.borland.dbswing.*;
import Digital_Campus_DataModule.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.border.*;
import java.sql.Statement;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class FgradeclassSetting extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JComboBox jCBGrade = new JComboBox();
  JLabel jLGrade = new JLabel();

  TableScrollPane tSlPGradeClass = new TableScrollPane();
  JdbTable jTGradeClass = new JdbTable();
  JPanel jPGradeClass = new JPanel();
  JLabel jLClassNum = new JLabel();
  JComboBox jCBClassNum = new JComboBox();
  JButton jBClassAdd = new JButton();
  JLabel jLClassmaster = new JLabel();
  JLabel jLGrademaster = new JLabel();
  JPanel jPMaster = new JPanel();
  JButton jBClassmasterSet = new JButton();
  XYLayout xYLayout2 = new XYLayout();
  DB_DataModule dB_DataModule_GradeClass;
  JButton jBClass_Reset = new JButton();
  TitledBorder titledBorder1;
  XYLayout xYLayout3 = new XYLayout();
  TitledBorder titledBorder2;
  Border border1;
  TitledBorder titledBorder3;
  Border border2;
  TitledBorder titledBorder4;
  JdbComboBox jdbCBClassmaster = new JdbComboBox();
  JLabel jLClass = new JLabel();
  JdbComboBox jdbCBclass = new JdbComboBox();
  JdbComboBox jdbComboBox1 = new JdbComboBox();
  JdbComboBox jdbCBGrademaster = new JdbComboBox();
  JButton jBGrademasterSet = new JButton();
  XYLayout xYLayout4 = new XYLayout();
  JPanel jPTerm = new JPanel();
  JButton jBTermAdd = new JButton();
  JComboBox jCBTermNo = new JComboBox();
  JLabel jLTermYear = new JLabel();
  JComboBox jCBTermYear = new JComboBox();
  JLabel jLTermNo = new JLabel();
  TableScrollPane tSlPTerm = new TableScrollPane();
  JdbTable jTTerm = new JdbTable();

  public FgradeclassSetting() {
    try {
      jbInit();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    jBClassmasterSet.setFont(new java.awt.Font("Dialog", 0, 13));
    jBClassmasterSet.setActionCommand("添加");

    dB_DataModule_GradeClass = Digital_Campus_DataModule.DB_DataModule.getDataModule();
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    border1 = BorderFactory.createBevelBorder(BevelBorder.LOWERED,Color.white,Color.white,new Color(103, 101, 98),new Color(148, 145, 140));
    titledBorder3 = new TitledBorder(border1,"班主任设置");
    border2 = new TitledBorder(BorderFactory.createBevelBorder(BevelBorder.LOWERED,Color.white,Color.white,new Color(103, 101, 98),new Color(148, 145, 140)),"班主任设置");
    titledBorder4 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"年级班级主任设置");
    this.setLocale(java.util.Locale.getDefault());
    this.setResizable(false);
    this.setSize(new Dimension(800, 600));
    this.setTitle("年级班级设置");
    this.addWindowListener(new FgradeclassSetting_this_windowAdapter(this));
    this.getContentPane().setLayout(xYLayout1);
    jCBGrade.setFont(new java.awt.Font("Dialog", 0, 13));
    jCBGrade.setPreferredSize(new Dimension(31, 25));
    jCBGrade.setToolTipText("");
    jCBGrade.addActionListener(new FgradeclassSetting_jCBGrade_actionAdapter(this));
    jLGrade.setFont(new java.awt.Font("Dialog", 0, 13));
    jLGrade.setLocale(java.util.Locale.getDefault());
    jLGrade.setText("年级：");


    jPGradeClass.setFont(new java.awt.Font("宋体", 0, 13));
    jPGradeClass.setName("");
    jPGradeClass.setAlignmentX((float) 0.5);
    jPGradeClass.setBorder(titledBorder4);
    jPGradeClass.setDebugGraphicsOptions(0);
    jPGradeClass.setPreferredSize(new Dimension(50, 600));
    jPGradeClass.setToolTipText("");
    jPGradeClass.setLayout(xYLayout2);
    jLClassNum.setText("班级个数：");
    jLClassNum.setFont(new java.awt.Font("Dialog", 0, 13));

    jCBClassNum.setToolTipText("");
    jCBClassNum.setFont(new java.awt.Font("Dialog", 0, 13));
    jCBClassNum.setPreferredSize(new Dimension(31, 25));
    jBClassAdd.setText("添加");
    jBClassAdd.addActionListener(new FgradeclassSetting_jBClassAdd_actionAdapter(this));

    jLClassmaster.setFont(new java.awt.Font("Dialog", 0, 13));
    jLClassmaster.setBorder(null);
    jLClassmaster.setText("班主任");

    jLGrademaster.setText("年级主任");
    jLGrademaster.setLocale(java.util.Locale.getDefault());
    jLGrademaster.setFont(new java.awt.Font("Dialog", 0, 13));
    jPMaster.setPreferredSize(new Dimension(50, 600));
    jPMaster.setLayout(xYLayout3);
    jPMaster.setLocale(java.util.Locale.getDefault());
    jPMaster.setBorder(titledBorder4);
    jPMaster.setDebugGraphicsOptions(0);
    jBClassmasterSet.setText("重置");
    jBClassmasterSet.addActionListener(new FgradeclassSetting_jBClassmasterSet_actionAdapter(this));
    tSlPGradeClass.setPreferredSize(new Dimension(478, 600));
    jTGradeClass.setDataSet(dB_DataModule_GradeClass.getQDSGradeClass());
    jTGradeClass.setEditable(false);
    jTGradeClass.setEditableFocusedCellForeground(Color.black);
    jBClass_Reset.setText("重置");
    jBClass_Reset.addActionListener(new FgradeclassSetting_jBClass_Reset_actionAdapter(this));

    jdbCBClassmaster.setMinimumSize(new Dimension(31, 25));
    jLClass.setFont(new java.awt.Font("Dialog", 0, 13));
    jLClass.setToolTipText("");
    jLClass.setText("班级");
    jBGrademasterSet.setFont(new java.awt.Font("Dialog", 0, 13));
    jBGrademasterSet.setToolTipText("");
    jBGrademasterSet.setRolloverEnabled(false);
    jBGrademasterSet.setText("重置");
    jBGrademasterSet.addActionListener(new FgradeclassSetting_jBGrademasterSet_actionAdapter(this));
    jdbCBclass.addActionListener(new FgradeclassSetting_jdbCBclass_actionAdapter(this));
    jdbCBclass.addItemListener(new FgradeclassSetting_jdbCBclass_itemAdapter(this));
    jPTerm.setDebugGraphicsOptions(0);
    jPTerm.setBorder(titledBorder4);
    jPTerm.setLocale(java.util.Locale.getDefault());
    jPTerm.setLayout(xYLayout4);
    jPTerm.setPreferredSize(new Dimension(50, 600));
    //jBTermAdd.addActionListener(new FgradeclassSetting_jBTermAdd_actionAdapter(this));
    jBTermAdd.setText("添加");
    jBTermAdd.addActionListener(new FgradeclassSetting_jBTermAdd_actionAdapter(this));
    jCBTermNo.setPreferredSize(new Dimension(31, 25));
    jCBTermNo.setFont(new java.awt.Font("Dialog", 0, 13));
    jCBTermNo.setToolTipText("");
    jLTermYear.setText("学年：");
    jLTermYear.setLocale(java.util.Locale.getDefault());
    jLTermYear.setFont(new java.awt.Font("Dialog", 0, 13));
    //jCBTermYear.addActionListener(new FgradeclassSetting_jCBTermYear_actionAdapter(this));
    jCBTermYear.setToolTipText("");
    jCBTermYear.setEditable(false);
    jCBTermYear.setMaximumRowCount(8);
    jCBTermYear.setPreferredSize(new Dimension(31, 25));
    jCBTermYear.setEnabled(true);
    jCBTermYear.setFont(new java.awt.Font("Dialog", 0, 13));
    jCBTermYear.setMinimumSize(new Dimension(31, 25));
    jLTermNo.setFont(new java.awt.Font("Dialog", 0, 13));
    jLTermNo.setLocale(java.util.Locale.getDefault());
    jLTermNo.setText("学期：");
    tSlPTerm.setPreferredSize(new Dimension(478, 600));
    jTTerm.setDataSet(dB_DataModule_GradeClass.getQDSTerm());
    jTTerm.setEditable(false);
    jTTerm.setEditableFocusedCellForeground(Color.black);
    jPMaster.add(jdbCBGrademaster, new XYConstraints(90, 13, 96, 21));
    jPMaster.add(jBGrademasterSet, new XYConstraints(217, 13, 60, 20));
    jPMaster.add(jdbCBclass, new XYConstraints(350, 11, 78, -1));
    jPMaster.add(jLClass, new XYConstraints(312, 13, -1, -1));
    jPMaster.add(jLClassmaster, new XYConstraints(444, 14, -1, -1));
    jPMaster.add(jdbCBClassmaster, new XYConstraints(494, 13, 68, 19));
    jPMaster.add(jBClassmasterSet, new XYConstraints(585, 13, 69, 20));
    jPMaster.add(jLGrademaster, new XYConstraints(21, 12, -1, -1));
    this.getContentPane().add(jPTerm, new XYConstraints(7, 9, 329, 76));
    jPGradeClass.add(jCBClassNum, new XYConstraints(206, 9, 53, 21));
    jPGradeClass.add(jCBGrade, new XYConstraints(39, 9, 76, 20));
    jPGradeClass.add(jLGrade, new XYConstraints(3, 10, -1, -1));
    jPGradeClass.add(jLClassNum, new XYConstraints(128, 10, -1, -1));
    jPGradeClass.add(jBClassAdd, new XYConstraints(278, 7, -1, -1));
    jPGradeClass.add(jBClass_Reset,    new XYConstraints(354, 7, 59, -1));
    this.getContentPane().add(tSlPTerm,          new XYConstraints(12, 180, 188, 389));
    tSlPTerm.getViewport().add(jTTerm, null);
    this.getContentPane().add(jPMaster,    new XYConstraints(10, 98, 782, 77));
    this.getContentPane().add(tSlPGradeClass,     new XYConstraints(234, 179, 552, 389));
    jPTerm.add(jLTermYear, new XYConstraints(2, 8, -1, -1));
    jPTerm.add(jCBTermYear,   new XYConstraints(45, 8, 89, 20));
    jPTerm.add(jCBTermNo,  new XYConstraints(176, 7, 53, 21));
    jPTerm.add(jBTermAdd, new XYConstraints(247, 6, -1, -1));
    jPTerm.add(jLTermNo,   new XYConstraints(141, 8, -1, -1));
    this.getContentPane().add(jPGradeClass,     new XYConstraints(361, 10, 432, 75));
    tSlPGradeClass.getViewport().add(jTGradeClass, null);
  }

  void jCBGrade_actionPerformed(ActionEvent e) {
    jdbCBclass.setItems(null);
    jdbCBGrademaster.setItems(null);
    jdbCBClassmaster.setItems(null);


    String sql =  "SELECT * "+
               "FROM class "+
               "WHERE (grade_name = ?)";
       Connection con = null;
    try{
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, jCBGrade.getSelectedItem().toString()  );
      ResultSet rs = ps.executeQuery();
      while(rs.next())
      {
        jdbCBclass.addItem(rs.getString("class_name"));
      }
      DbUtil.close(rs);
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(con);
    }


   String sqlNianJiao =  "SELECT * "+
                        "FROM teacher ";
   try{
     con = DBConnection.getConnection();
     PreparedStatement ps = con.prepareStatement(sqlNianJiao);
     ResultSet rs = ps.executeQuery();
     while(rs.next())
     {
       jdbCBGrademaster.addItem(rs.getString("teacher_name"));


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


  try{
     con = DBConnection.getConnection();
     PreparedStatement ps = con.prepareStatement(sqlNianJiao);
     ResultSet rs = ps.executeQuery();
     while(rs.next())
     {
       jdbCBClassmaster.addItem(rs.getString("teacher_name"));


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

  }

  void this_windowOpened(WindowEvent e) {


  }


  void this_windowActivated(WindowEvent e) {
    String sql = "SELECT * FROM grade ";

    Connection con = null;
    try{
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      ResultSet rs = ps.executeQuery();
      while(rs.next())
      {
        jCBGrade.addItem(rs.getString("grade_name"));