db_datamodule.java~15~

中小学校园的教师

/**
 * <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();
  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 {
    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;
  }
}