#include "midb\dbhashtable.h" cdbhashtable* pht = new cdbhashtable; pht->clear(); cdbcomfunctions m_pdbfunction; cstring sdynsqlstr.format("select * from t1"); cdbresultset* prset = m_pdbfunction.getsqlresultset(sdynsqlstr); if(prset->getstatus()) { prset->filldbhashtable(pht); } delete prset; //extracting hash table extraction // using column index int nrows = pht->getint("data.row.count"); int ncols = pht->getint("data.column.count"); cstring skey; for(int krow = 0; krow < nrows; krow++) { skey.format("data.row.%d", krow); cstringarray* pstrary = pdataht->getstringarray(skey); cstring col0 = pdataary->getat(0); cstring col1 = pdataary->getat(1); } // do for number of data rows // using column index // using column name cstring skey; cdbrecordmap m_precmap; m_precmap.setnameary("5", "apptype", "optiontype", "comboorder", "dbitem", "comboitem"); for(int krow = 0; krow < nrows; krow++) { skey.format("data.row.%d", krow); cstringarray* pstrary = pdataht->getstringarray(skey); m_precmap.setvalueary(pstrary); sapptype = m_precmap.getstring("apptype"); soptiontype = m_precmap.getstring("optiontype"); } // do for number of data rows // using column name how to insert / delete cdbpool* ppool = cdbpool::getinstance(); idbconnection* m_pdbconn = ppool->getconnection(); cstring sdynsqlstr("delete from t1 where id = 10"); if(sdynsqlstr.getlength() > 0) { bresult = m_pdbconn>executesql(sdynsqlstr); }
delete pht; how to initialize connect to database %% define the configuration parameters which are user by the application %% parameters format is like a key=value pair %% prepend % to comment the line %% database decision parameters %% use access for ms access database, oracle to access oracle database %% use db.database as 1-ms access, 2-ms oracle driver %% use db.usedsn as 1-dsn connection, 0-dsn less connection db.database=1 db.usedsn=0 %% database initializations %% %% ms access %% ms access initialization parameters db.msaccess.dsn=balco db.msaccess.uid= db.msaccess.pwd= %% for dsn-less connection db.msaccess.dbq=c:\my\mypoc\accessdb\stagg.mdb %% %% msoracle %% msoracle initialization parameters db.msoracle.dsn= db.msoracle.uid=rgowda db.msoracle.pwd=rgowda %% for dsn-less connection %% for prdcserver database db.msoracle.sid=global %% for shimsha server database %% db.msoracle.sid=shimshad %% for shimsha machine local database %% db.msoracle.sid=shimshadblocal %%
cstring msg; bool binit = true; cdbconfig* pconfig = cdbconfig::getinstance(); binit = pconfig->initialize("data/dbconfig.dat"); if(!binit) { return(0); } cstring sdbconnectstr = pconfig->getdbconnectstr(); cdbpool* ppool = cdbpool::getinstance(); binit = ppool->initdbpool(sdbconnectstr, 1); if(!binit) { msg.format("initializing db info failed for dsn = [%s]", sdbconnectstr); afxmessagebox(msg); return(0); } // if not able to initialize database