简单ADO编程源代码剖析.docVIP

HYPERLINK /yangqingna_1986/article/details/6552426 \o 简单ADO编程源代码分析 简单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(int argc, _TCHAR* argv[]) { CoInitialize(NULL); //Initialize the com enviroment _ConnectionPtr pMyConnect(__uuidof(Connection)); //定义连接对象并实例化对象 _RecordsetPtr pRst(__uuidof(Recordset)); //定义记录集对象并实例化对象 try{ //打开数据库 //CString strConnect=DRIVER={Provider=Microsoft.Jet.OLEDB.4.0;Microsoft Access Driver(*.mdb)};uid=;pwd=;DBQ=F://C++ study//ADO//ADO//shujuku.mdb;; CString strConnect=DSN=RocketsPlayers;/ DBQ=F://C++ study//源程序//源程序//chap13//RocketsPlayers.mdb;/ DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;; //CString strConnect=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