db_datamodule.java

中小学校园的教师

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

import java.awt.*;
import java.awt.event.*;
import com.borland.dx.dataset.*;
import com.borland.dx.sql.dataset.*;

public class DB_DataModule implements DataModule {
  private static DB_DataModule myDM;
  Database db_Campus = new Database();
  QueryDataSet qDSGradeClass = new QueryDataSet();
  QueryDataSet qDSTerm = new QueryDataSet();
  QueryDataSet qDSGrade = new QueryDataSet();
  QueryDataSet qDSCourse = new QueryDataSet();
  QueryDataSet qDSCourseSet = new QueryDataSet();
  QueryDataSet qDSExam = new QueryDataSet();
  QueryDataSet qDSExamRoom = new QueryDataSet();
  public static DB_DataModule getDataModule() {
    if (myDM == null) {
      myDM = new DB_DataModule();
    }
    return myDM;
  }

  public DB_DataModule() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    qDSExamRoom.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT exam_name AS 考试名称, exam_type AS 考试类型, classroom_name AS 考试教室, " +
      "\n      exam_time AS 考试时间, exam_teacher AS 监考老师\nFROM exam_room\nORDER " +
      "BY exam_name DESC, exam_type, classroom_name", null, true, Load.ALL));
    qDSExam.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT exam_name AS 考场, exam_class AS 教室, exam_seat_no AS 座号, \n  " +
      "    card_id AS 学号\nFROM exam\nORDER BY exam_name DESC, exam_class, " +
      "exam_seat_no", null, true, Load.ALL));
    qDSCourseSet.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT course_set_id AS 节次, term_id AS 学期, course_set_start AS 开始时间, " +
      "\n      course_set_end AS 结束时间\nFROM course_set", null, true, Load.ALL));
    qDSCourse.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT course_name AS 课程名称, course_term AS 学期\nFROM course", null, true, Load.ALL));
    qDSGrade.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT *\nFROM grade", null, true, Load.ALL));
    qDSTerm.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT term_id AS 学期\nFROM term", null, true, Load.ALL));
    qDSGradeClass.setReadOnly(true);
    qDSGradeClass.setEditable(true);
    qDSGradeClass.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db_Campus, "SELECT grade.grade_name AS 年级, grade.grade_master AS 年级主任, \n     " +
      " grade.grade_telephone AS 年级办公电话, class.class_name AS 班级, \n      " +
      "class.class_master AS 班主任, grade.grade_office AS 年级办公室\nFROM class " +
      "INNER JOIN\n      grade ON class.grade_name = grade.grade_name", null, true, Load.ALL));
    db_Campus.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:Digital_Campus", "dbw", "123456", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
  }
  public com.borland.dx.sql.dataset.Database getDb_Campus() {
    return db_Campus;
  }

  public com.borland.dx.sql.dataset.QueryDataSet getQDSGradeClass() {
    return qDSGradeClass;
  }
  public com.borland.dx.sql.dataset.QueryDataSet getQDSTerm() {
    return qDSTerm;
  }

  public com.borland.dx.sql.dataset.QueryDataSet getQDSGrade() {
    return qDSGrade;
  }
  public com.borland.dx.sql.dataset.QueryDataSet getQDSCourse() {
    return qDSCourse;
  }
  public com.borland.dx.sql.dataset.QueryDataSet getQDSCourseSet() {
    return qDSCourseSet;
  }
  public com.borland.dx.sql.dataset.QueryDataSet getQDSExam() {
    return qDSExam;
  }
  public com.borland.dx.sql.dataset.QueryDataSet getQDSExamRoom() {
    return qDSExamRoom;
  }
}