package xscjgl;

import com.borland.dx.dataset.DataModule;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.ConnectionDescriptor;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;

/**
 * <p>Title: java course design</p>
 *
 * <p>Description:學生查成績，管理員輸成績、管理。二種權限的學生成績管理系統 </p>
 *
 * <p>Copyright: lixing (c) 2006</p>
 *
 *
 * @author 04級計算機教育班 黎興
 * @version 1.0
 */
 */
public class DataModule1 implements DataModule {
    /**
     * Data module reference.
     */
    private static DataModule1 myDM;
    Database database1 = new Database();
    QueryDataSet Query = new QueryDataSet();

    /**
     * DataModule constructor.
     */
    public DataModule1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Initialize.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mydb",
                "tqti", "111111", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        Query.setQuery(new QueryDescriptor(database1, "SELECT * FROM student", null, true,
                                             Load.ALL));
    }

    /**
     * Get data module reference.
     *
     * @return DataModule reference
     */
    public static DataModule1 getDataModule() {
        if (myDM == null) {
            myDM = new DataModule1();
        }
        return myDM;
    }

    public Database getDatabase1() {
        return database1;
    }

    public QueryDataSet getStudent() {
        return Query;
    }
}