fexammanage.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;
import java.io.IOException;


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


public class FExamManage extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  JPanel jPExamRoom = new JPanel();
  JLabel jLTerm = new JLabel();
  JLabel jLExamType = new JLabel();
  JButton jBCourseAdd = new JButton();
  JComboBox jCBTerm = new JComboBox();
  JPanel jPExamSite = new JPanel();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  TitledBorder titledBorder3;
  JComboBox jCBGrade = new JComboBox();
  JLabel jLGrade = new JLabel();
  JdbComboBox jdbExamType = new JdbComboBox();
  DB_DataModule dB_DataModule_Exam;
  JPanel jPExam = new JPanel();
  TitledBorder titledBorder4;
  XYLayout xYLayout2 = new XYLayout();
  XYLayout xYLayout3 = new XYLayout();
  TableScrollPane tSPExamRoom = new TableScrollPane();
  JdbTable jdbTExamRoom = new JdbTable();
  TableScrollPane tSPExam = new TableScrollPane();
  JdbTable jdbTExam = new JdbTable();
  class Course{
      String Course_Name;
    }
    class Classes{
      int Class_Id;
      String Class_Name;
      int Class_Size;

    }


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

  void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"考场安排情况");
    dB_DataModule_Exam = Digital_Campus_DataModule.DB_DataModule.getDataModule();
    titledBorder4 = new TitledBorder(BorderFactory.createEtchedBorder(Color.white,new Color(148, 145, 140)),"考场信息");
    jPExamRoom.setLayout(xYLayout3);
    jPExamRoom.setAutoscrolls(false);
    jPExamRoom.setBorder(titledBorder3);
    this.getContentPane().setLayout(xYLayout1);
    this.setResizable(false);
    this.setSize(new Dimension(800, 600));
    this.setTitle("考试管理");
    this.addWindowListener(new FExamManage_this_windowAdapter(this));
    jLTerm.setFont(new java.awt.Font("Dialog", 0, 14));
    jLTerm.setText("学期：");
    jLTerm.setBounds(new Rectangle(72, 25, 45, 20));
    jLExamType.setFont(new java.awt.Font("Dialog", 0, 14));
    jLExamType.setText("类型：");
    jLExamType.setBounds(new Rectangle(459, 25, 60, 18));
    jBCourseAdd.setBounds(new Rectangle(618, 25, 94, 21));
    jBCourseAdd.setText("生成考场");
    jBCourseAdd.addActionListener(new FExamManage_jBCourseAdd_actionAdapter(this));

    jCBTerm.setBounds(new Rectangle(108, 24, 129, 22));
    jPExamSite.setLayout(null);
    jPExamSite.setFont(new java.awt.Font("Dialog", 0, 13));
    jPExamSite.setBorder(titledBorder3);
    jPExamSite.setDebugGraphicsOptions(0);

    jCBGrade.setBounds(new Rectangle(305, 23, 117, 22));
    jLGrade.setBounds(new Rectangle(264, 27, 60, 18));
    jLGrade.setText("年级：");
    jLGrade.setFont(new java.awt.Font("Dialog", 0, 14));
    jdbExamType.setItems(new String[] {"期中考试 ", "期末考试", "小考", "中考", "高考"});
    jdbExamType.setBounds(new Rectangle(502, 23, 90, 22));
    jPExam.setFont(new java.awt.Font("Dialog", 0, 13));
    jPExam.setBorder(titledBorder4);
    jPExam.setLayout(xYLayout2);
    jdbTExamRoom.setDataSet(dB_DataModule_Exam.getQDSExamRoom());
    jdbTExam.setDataSet(dB_DataModule_Exam.getQDSExam());
    this.getContentPane().add(jPExamSite,   new XYConstraints(6, 5, 783, 65));
    this.getContentPane().add(jPExamRoom,     new XYConstraints(8, 80, 785, 186));
    this.getContentPane().add(jPExam,     new XYConstraints(10, 275, 785, 300));
    jPExamSite.add(jBCourseAdd, null);
    jPExamSite.add(jLTerm, null);
    jPExamSite.add(jCBTerm, null);
    jPExamSite.add(jLExamType, null);
    jPExamSite.add(jdbExamType, null);
    jPExamSite.add(jCBGrade, null);
    jPExamSite.add(jLGrade, null);
    jPExamRoom.add(tSPExamRoom,    new XYConstraints(8, 3, 755, 151));
    tSPExamRoom.getViewport().add(jdbTExamRoom, null);
    jPExam.add(tSPExam,   new XYConstraints(9, 4, 757, 262));
    tSPExam.getViewport().add(jdbTExam, 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"));
      }
      sql = "SELECT * FROM grade";
      ps = con.prepareStatement(sql);
      rs = ps.executeQuery();
      while(rs.next())
      {
        jCBGrade.addItem(rs.getString("grade_name"));
      }

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

  }

  void jBCourseAdd_actionPerformed(ActionEvent e) {
    int i,j,k,CoursesCount=0,ClasssesCount=0;
    Connection conCourses = null;
    Connection conCoursesCount = null;
    String Course_Name[]=null;
    String Classes_Info[][]=null;
    //判断该学期考试是否已经生成
    Connection concon = null;
    try{
      String sql = "SELECT * "+
          "FROM exam_room "+
          "WHERE (exam_name LIKE '%"+jCBTerm.getSelectedItem().toString()+"%') AND (classroom_name like '%"+jCBGrade.getSelectedItem().toString()+"%') AND (exam_type = '"+jdbExamType.getSelectedItem().toString() +"')";
      concon = DBConnection.getConnection();
      PreparedStatement ps = concon.prepareStatement(sql);
      System.out.print(sql+"\n") ;
      ResultSet rs = ps.executeQuery();
      if(rs.next()){
        JOptionPane.showMessageDialog(null," 以安排了该学期的考场，就算你不满意也不能改了，不好意思");
      }
      else{//可以添加

      }
      DbUtil.close(ps);
    }catch(Exception ee){
      ee.printStackTrace();
    }finally{
      DbUtil.close(concon);
    }
    //读出所有课程
    String sqlCourses = "SELECT * "+
        "FROM course "+
        "WHERE (course_name like '%"+jCBGrade.getSelectedItem().toString()+"1%') "+
        " AND (course_term = '"+jCBTerm.getSelectedItem().toString()+"')";
    try{
      conCourses = DBConnection.getConnection();
      PreparedStatement psCourses = conCourses.prepareStatement(sqlCourses);
      System.out.print(sqlCourses) ;

      ResultSet rsCourses = psCourses.executeQuery();
      //课程总数
      String sqlCoursesCount = "SELECT COUNT(*) AS course_count "+
        "FROM course "+
        "WHERE (course_name like '%"+jCBGrade.getSelectedItem().toString()+"1%') "+
        " AND (course_term = '"+jCBTerm.getSelectedItem().toString()+"')";
    conCoursesCount = DBConnection.getConnection();

    PreparedStatement psCoursesCount = conCoursesCount.prepareStatement(sqlCoursesCount);
    System.out.print(sqlCoursesCount) ;
    ResultSet rsCoursesCount = psCoursesCount.executeQuery();
      if(rsCoursesCount.next()){
        CoursesCount=rsCoursesCount.getInt("course_count");
        System.out.print(CoursesCount+"\n") ;
        Course_Name = new  String[CoursesCount];
        for(i=0;i<CoursesCount;i++){
          if(rsCourses.next()){
            //Strcpy(Course_Info[i].Course_Name,String.valueOf(rsCourses.getString("course_name")));
            System.out.print(sqlCourses+"\n") ;
            //System.out.print(rsCourses.getString("course_name")) ;
            String Str_course_name=rsCourses.getString("course_name").toString() ;