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 {
        //建立數據庫連接
        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數據表的數據
        queryDataSet1.setQuery(new QueryDescriptor(database1,"select * from loginUser",null,true,Load.AS_NEEDED) );

    }

    public static LoginDataModule1 getDataModule() {
        if (myDM == null) {
            myDM = new LoginDataModule1();
        }
        return myDM;
    }
}