package data;

import com.borland.dx.dataset.*;
import com.borland.dx.dataset.DataModule;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import  com.borland.dx.sql.dataset.*;
public class LoginDataModule1 implements DataModule {

    private static LoginDataModule1 myDM;
    Database database1=new Database();
    QueryDataSet queryDataSet1=new QueryDataSet();
    public LoginDataModule1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }


    private void jbInit() throws Exception {
        //建立數(shù)據(jù)庫(kù)連接
        String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=loginC1";
        String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
        database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(url,"sa","",false,driver));
        //取得loginUser數(shù)據(jù)表的數(shù)據(jù)
        queryDataSet1.setQuery(new QueryDescriptor(database1,"select * from loginUser",null,true,Load.AS_NEEDED) );

    }
    //取得數(shù)據(jù)模塊的方法
    public static LoginDataModule1 getDataModule() {
        if (myDM == null) {
            myDM = new LoginDataModule1();
        }
        return myDM;
    }
    //取得數(shù)據(jù)庫(kù)聯(lián)接的方法
    public Database getDatabase1(){
        return database1;
    }
    //取得數(shù)據(jù)查詢(xún)的方法
    public QueryDataSet getQueryDataset1(){
        return queryDataSet1;
    }
}