fexamroom.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.util.Random;

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

public class FExamRoom extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JPanel jPExamSite = new JPanel();
  JLabel jLTerm = new JLabel();
  JLabel jLExamType = new JLabel();
  JLabel jLCourse = new JLabel();
  JdbComboBox jdbExamType = new JdbComboBox();
  JButton jBExamCheck = new JButton();
  JComboBox jCBTerm = new JComboBox();
  DB_DataModule dB_DataModule_ExamRoom;
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  TitledBorder titledBorder3;
  TitledBorder titledBorder4;
  TitledBorder titledBorder5;
  TitledBorder titledBorder6;
  TitledBorder titledBorder7;
  JPanel jPExamSiteInfo = new JPanel();
  JButton jBExamSet = new JButton();
  TitledBorder titledBorder8;
  JdbComboBox jdbCBCourse = new JdbComboBox();
  JPanel jPExam = new JPanel();
  TitledBorder titledBorder9;
  TitledBorder titledBorder10;
  XYLayout xYLayout2 = new XYLayout();
  TableScrollPane tSPExam = new TableScrollPane();
  JdbTable jdbTExam = new JdbTable();
  JLabel jLTeacher = new JLabel();
  JdbComboBox jdbCBTeacher = new JdbComboBox();
  JLabel jLExamTime = new JLabel();
  JTextField jTFExamTime = new JTextField();

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

  void jbInit() throws Exception {
    dB_DataModule_ExamRoom = Digital_Campus_DataModule.DB_DataModule.getDataModule();
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"考场表");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    titledBorder5 = new TitledBorder("");
    titledBorder6 = new TitledBorder("");
    titledBorder7 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"考场座号信息查看");
    titledBorder8 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"考场时间和监考老师设置");
    titledBorder9 = new TitledBorder("");
    titledBorder10 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"考场座位信息");
    this.setResizable(false);
    this.setSize(new Dimension(800, 600));
    this.addWindowListener(new FExamRoom_this_windowAdapter(this));
    this.getContentPane().setLayout(xYLayout1);
    jPExamSite.setLayout(null);
    jPExamSite.setFont(new java.awt.Font("Dialog", 0, 13));
    jPExamSite.setBorder(titledBorder7);
    jPExamSite.setDebugGraphicsOptions(0);
    jLTerm.setFont(new java.awt.Font("Dialog", 0, 14));
    jLTerm.setText("学期：");
    jLTerm.setBounds(new Rectangle(90, 27, 45, 20));
    jLExamType.setFont(new java.awt.Font("Dialog", 0, 14));
    jLExamType.setText("类型：");
    jLExamType.setBounds(new Rectangle(444, 25, 60, 18));
    jLCourse.setBounds(new Rectangle(266, 25, 60, 18));
    jLCourse.setText("科目：");
    jLCourse.setFont(new java.awt.Font("Dialog", 0, 14));

    jdbExamType.setItems(new String[] {"期中考试 ", "期末考试", "小考", "中考", "高考"});
    jdbExamType.setBounds(new Rectangle(487, 24, 90, 22));
    jBExamCheck.setBounds(new Rectangle(618, 25, 94, 21));
    jBExamCheck.setFont(new java.awt.Font("Dialog", 0, 13));
    jBExamCheck.setActionCommand("查看考场");
    jBExamCheck.setText("查看考场");
    jBExamCheck.addActionListener(new FExamRoom_jBExamCheck_actionAdapter(this));

    jCBTerm.setBounds(new Rectangle(130, 24, 116, 22));
    jCBTerm.addActionListener(new FExamRoom_jCBTerm_actionAdapter(this));
    jPExamSiteInfo.setDebugGraphicsOptions(0);
    jPExamSiteInfo.setBorder(titledBorder8);
    jPExamSiteInfo.setFont(new java.awt.Font("Dialog", 0, 13));
    jPExamSiteInfo.setLayout(null);
    jBExamSet.setBounds(new Rectangle(491, 23, 94, 21));
    jBExamSet.setFont(new java.awt.Font("Dialog", 0, 13));
    jBExamSet.setActionCommand("设置");
    jBExamSet.setText("设置");
    jBExamSet.addActionListener(new FExamRoom_jBExamSet_actionAdapter(this));

    jdbCBCourse.setBounds(new Rectangle(316, 26, 108, 22));
    jPExam.setBorder(titledBorder10);
    jPExam.setLayout(xYLayout2);
    jdbTExam.setDataSet(dB_DataModule_ExamRoom.getQDSExam());
    jLTeacher.setFont(new java.awt.Font("Dialog", 0, 13));
    jLTeacher.setBorder(null);
    jLTeacher.setToolTipText("");
    jLTeacher.setText("监考老师");
    jLTeacher.setBounds(new Rectangle(113, 24, 61, 19));
    jdbCBTeacher.setMinimumSize(new Dimension(31, 25));
    jdbCBTeacher.setBounds(new Rectangle(189, 24, 68, 19));
    jLExamTime.setFont(new java.awt.Font("Dialog", 0, 12));
    jLExamTime.setToolTipText("");
    jLExamTime.setText("开始时间：");
    jLExamTime.setBounds(new Rectangle(290, 23, 65, 20));
    jTFExamTime.setText("");
    jTFExamTime.setBounds(new Rectangle(365, 24, 81, 19));
    jPExamSite.add(jBExamCheck, null);
    jPExamSite.add(jLExamType, null);
    jPExamSite.add(jdbExamType, null);
    jPExamSite.add(jCBTerm, null);
    jPExamSite.add(jLTerm, null);
    jPExamSite.add(jdbCBCourse, null);
    jPExamSite.add(jLCourse, null);
    this.getContentPane().add(jPExam,      new XYConstraints(15, 167, 774, 414));
    jPExam.add(tSPExam,       new XYConstraints(6, 9, 752, 387));
    tSPExam.getViewport().add(jdbTExam, null);
    this.getContentPane().add(jPExamSiteInfo,     new XYConstraints(12, 90, 774, 65));
    this.getContentPane().add(jPExamSite,    new XYConstraints(13, 11, 772, 65));
    jPExamSiteInfo.add(jLExamTime, null);
    jPExamSiteInfo.add(jBExamSet, null);
    jPExamSiteInfo.add(jTFExamTime, null);
    jPExamSiteInfo.add(jdbCBTeacher, null);
    jPExamSiteInfo.add(jLTeacher, null);
  }

  void this_windowActivated(WindowEvent e) {

    //年级
    String sql = "SELECT * FROM term ";

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

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

    //教师
    String sqlTeacher = "SELECT * FROM teacher ";

    Connection conTeacher = null;
    try{
      conTeacher = DBConnection.getConnection();
      PreparedStatement psTeacher = conTeacher.prepareStatement(sqlTeacher);
      ResultSet rsTeacher = psTeacher.executeQuery();
      while(rsTeacher.next() )
      {
        jdbCBTeacher.addItem(rsTeacher.getString("teacher_name"));
      }
      DbUtil.close(rsTeacher);
      DbUtil.close(psTeacher);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(conTeacher);
    }

  }

  void jCBTerm_actionPerformed(ActionEvent e) {
    String sql = "SELECT * "+
        "FROM course "+
        "WHERE (course_name like '%1%') "+
        " AND (course_term = '"+jCBTerm.getSelectedItem().toString()+"')";
    System.out.print(sql+"\n") ;
    Connection con = null;
    jdbCBCourse.setItems(null);
    try{
      con = DBConnection.getConnection();
      PreparedStatement ps = con.prepareStatement(sql);
      ResultSet rs = ps.executeQuery();
      while(rs.next())
      {
        jdbCBCourse.addItem(rs.getString("course_name"));
      }

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


  }

  void jBExamCheck_actionPerformed(ActionEvent e) {
    String sql = "SELECT * "+
        "FROM exam "+
        "WHERE (exam_name = '%"+jCBTerm.getSelectedItem().toString() +"%') AND (exam_name = '%"+jdbCBCourse.getSelectedItem().toString() +"%') AND (exam_name = '%"+jdbExamType.getSelectedItem().toString() +"%') ";
  }

  void jBExamSet_actionPerformed(ActionEvent e) {
    String sql = "UPDATE exam_room "+
        "SET exam_teacher = '"+jdbCBTeacher.getSelectedItem().toString() +"', exam_time = '"+jTFExamTime.getText()  +"' "+
        "WHERE (exam_name = '%"+jCBTerm.getSelectedItem().toString() +"%') AND (exam_name = '%"+jdbCBCourse.getSelectedItem().toString() +"%') AND (exam_name = '%"+jdbExamType.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);
    }

  }
}

class FExamRoom_this_windowAdapter extends java.awt.event.WindowAdapter {
  FExamRoom adaptee;

  FExamRoom_this_windowAdapter(FExamRoom adaptee) {
    this.adaptee = adaptee;
  }
  public void windowActivated(WindowEvent e) {
    adaptee.this_windowActivated(e);
  }
}

class FExamRoom_jCBTerm_actionAdapter implements java.awt.event.ActionListener {
  FExamRoom adaptee;

  FExamRoom_jCBTerm_actionAdapter(FExamRoom adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jCBTerm_actionPerformed(e);
  }
}

class FExamRoom_jBExamCheck_actionAdapter implements java.awt.event.ActionListener {
  FExamRoom adaptee;

  FExamRoom_jBExamCheck_actionAdapter(FExamRoom adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExamCheck_actionPerformed(e);
  }
}

class FExamRoom_jBExamSet_actionAdapter implements java.awt.event.ActionListener {
  FExamRoom adaptee;

  FExamRoom_jBExamSet_actionAdapter(FExamRoom adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExamSet_actionPerformed(e);
  }
}