/** * <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 考試時(shí)間, exam_teacher AS 監(jiān)考老師\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 考場(chǎng), exam_class AS 教室, exam_seat_no AS 座號(hào), \n  " +      "    card_id AS 學(xué)號(hào)\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 節(jié)次, term_id AS 學(xué)期, course_set_start AS 開始時(shí)間, " +      "\n      course_set_end AS 結(jié)束時(shí)間\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 學(xué)期\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 學(xué)期\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 年級(jí), grade.grade_master AS 年級(jí)主任, \n     " +      " grade.grade_telephone AS 年級(jí)辦公電話, class.class_name AS 班級(jí), \n      " +      "class.class_master AS 班主任, grade.grade_office AS 年級(jí)辦公室\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;  }}