简单ADO编程源代码分析.docxVIP

简单ADO编程源代码分析// ADO.cpp : Defines the entry point for the console application. // #include stdafx.h #include iostream #include string #include vector #include afx.h #import C:/Program Files/Common Files/System/ado/msado15.dll no_namespace rename(EOF, adoEOF) using namespace std; int _tmain(intargc, _TCHAR* argv[]) { CoInitialize(NULL); //Initialize the com enviroment_ConnectionPtrpMyConnect(__uuidof(Connection)); //定义连接对象并实例化对象_RecordsetPtrpRst(__uuidof(Recordset)); //定义记录集对象并实例化对象try{ //打开数据库//CStringstrConnect=DRIVER={Provider=Microsoft.Jet.OLEDB.4.0;Microsoft Access Driver(*.mdb)};uid=;pwd=;DBQ=F://C++ study//ADO//ADO//shujuku.mdb;; CStringstrConnect=DSN=RocketsPlayers;/DBQ=F://C++ study//源程序//源程序//chap13//RocketsPlayers.mdb;/ DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;; //CStringstrConnect=Provider=SQLOLEDB;Data Source=F://C++ study//ADO//ADO//shujuku.mdb;; pMyConnect-Open((_bstr_t)strConnect,,,NULL); //pMyConnect-Open(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=shujuku.mdb;Persist Security Inof=False;,,,adModeUnknown); } catch(_com_error e) { coutInitialize database failedendl; coute.Description()endl; coute.HelpFile()endl; return 0; } coutConnect database success!endl; try{ pRst = pMyConnect-Execute(select * from Rockets, NULL, adCmdText); if(!pRst-BOF) { pRst-MoveFirst(); } else { coutThe data in the table is nullendl; return 0; } //存储表的所有列名vector_bstr_t column_name; for(int i=0; ipRst-Fields-GetCount();i++) { coutpRst-Fields-GetItem(_variant_t((long)i))-Name/t; column_name.push_back(pRst-Fields-GetItem(_variant_t((long)i))-Name); } coutendl; //对表进行遍历访问while(!pRst-adoEOF) { vector_bstr_t::iterator iter = column_name.begin(); /*for(iter;iter!=column_name.end();iter++) {*/ if(pRst-GetCollect(*iter).vt != VT_NULL) { //cout(_bstr_t)pRst-GetCollect(*iter)/t/t i=iendl; cout/t(_bstr_t)pRst-Fields-Item[_variant_t(PlayerID)]-Value; cout/t(_bstr_t)pRst-Fields-Item[_variant_t(Name)]-Value; cout/t(_bstr_t)pRst-Fields-Item[_variant_t(Number)]-Value; cout/t