import java.applet.*;
  import java.awt.*;
   import java.util.*;
    import dao350.*;
     import com.ms.com.* ;
  
public class dao extends Applet {

	String msg ;

    // variáveis usadas para o suporte DAO
    boolean readOnly = false;
    String strDatabase = "\\\\sidnei\\c\\banco\\Northwind.mdb";
    String strRecordset = "Produtos";
    int recordCount;


	
	// objetos do DAO 
	_DBEngine  m_IEngine;
    Database   database;
    Recordset  recordset;


	// propriedades do banco de dados
     Variant vExclusive ;
     Variant vReadOnly  ;
     Variant vConnect   ;


    // define nova tabela para leitura
     Variant vOpenType ;
     Variant vOptions  ;
	 Variant vLockType ;
	
	 
	

  public void init()
    {
        // abre banco de dados e configura informação dos campos.
        // inicializa banco de dados atraves do gerenciador de licença.
        
	 



	// propriedades do banco de dados
    vExclusive = new Variant();
    vReadOnly  = new Variant();
    vConnect   = new Variant();


    // define nova tabela para leitura
    vOpenType = new Variant();
    vOptions  = new Variant();
	vLockType = new Variant();


		
            //ILicenseMgr licmgr = (ILicenseMgr)new LicenseMgr();

			ILicenseMgr mgr = new LicenseMgr();
			m_IEngine = (_DBEngine)mgr.createWithLic
			(
			"mbmabptebkjcdlgtjmskjwtsdhjbmkmwtrak",
			"{00000010-0000-0010-8000-00AA006D2EA4}",
            null, 
			ComContext.INPROC_SERVER 
			) ;
  

			vExclusive.putBoolean(false);
			vReadOnly.putBoolean(readOnly);
			vConnect.putString("");

		
			database = m_IEngine.OpenDatabase(strDatabase, vExclusive, vReadOnly, vConnect);
	
       
			vOpenType.putShort((short)RecordsetTypeEnum.dbOpenDynaset);
			
			// NOTE: The RecordsetOptionEnum.dbReadOnly value is shared by LockTypeEnum
			// There is no LockTypeEnum value denoting read only concurrency
			vLockType.putInt(readOnly ? RecordsetOptionEnum.dbReadOnly : LockTypeEnum.dbOptimistic);
			recordset = database.OpenRecordset(strRecordset, vOpenType, vOptions, vLockType);


			// Fields fields = recordset.getFields() ;

			msg = "Conectado " + strDatabase;
	

  }

  		public void paint(Graphics g) {
			g.drawString(msg, 25,25) ;
		}


}