datamodule1.java

JAVA数据库编程实例随书源码 JAVA数据库编程实例随书源码

/**
 * Title:        JBuilder数据模块的应用
 * Description:  Java语言演示程序：JBuilder数据模块的应用，用于北京师范大学计算机系Java课程教学示范。
 * Copyright:    Copyright (c) 2002
 * Company:      北京师范大学计算机系
 * @author 孙一林
 * @version 1.0
 */
package mydatamoduleapp;

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

public class DataModule1 implements DataModule {
  private static DataModule1 myDM;
  Database database1 = new Database();
  QueryDataSet studentbase = new QueryDataSet();
  public static DataModule1 getDataModule() {
    if (myDM == null) {
      myDM = new DataModule1();
    }
    return myDM;
  }

  public DataModule1() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    studentbase.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT studentbase.\"学号\",studentbase.\"姓名\",studentbase.\"年龄\",studentbase.\"性别\",studentbase.\"系名\" " +
      "FROM\"D:\\DataBase\\student\".studentbase", null, true, Load.ALL));
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "student", "123456", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
  }
  public Database getDatabase1() {
    return database1;
  }
  public QueryDataSet getStudentbase() {
    return studentbase;
  }
}