简单ado编程源代码分析

《简单ado编程源代码分析》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、简单ADO编程源代码分析1.//ADO.cpp:Definestheentrypointfortheconsoleapplication.2.//3.4.#include"stdafx.h"5.#include6.#include7.#include8.#include9.#import"C:/ProgramFiles/CommonFiles/System/ado/msado15.dll"no_namespacerename("EOF","a

2、doEOF")10.11.usingnamespacestd;12.13.14.int_tmain(intargc,_TCHAR*argv[])15.{16.CoInitialize(NULL);//Initializethecomenviroment17._ConnectionPtrpMyConnect(__uuidof(Connection));//定义连接对象并实例化对象18._RecordsetPtrpRst(__uuidof(Recordset));//定义记录集对象并实例化对象19.try{20

3、.//打开数据库21.//CStringstrConnect="DRIVER={Provider=Microsoft.Jet.OLEDB.4.0;MicrosoftAccessDriver(*.mdb)};uid=;pwd=;DBQ=F://C++study//ADO//ADO//shujuku.mdb;";22.CStringstrConnect="DSN=RocketsPlayers;/23.DBQ=F://C++study//源程序//源程序//chap13//RocketsPlayers.mdb;/

4、24.DriverId=25;FIL=MSAccess;MaxBufferSize=2048;PageTimeout=5;";25.//CStringstrConnect="Provider=SQLOLEDB;DataSource=F://C++study//ADO//ADO//shujuku.mdb;";26.pMyConnect->Open((_bstr_t)strConnect,"","",NULL);1.//pMyConnect->Open("Provider=Microsoft.Jet.OLEDB

5、.4.0;DataSource=shujuku.mdb;PersistSecurityInof=False;","","",adModeUnknown);2.}3.catch(_com_error&e)4.{5.cout<<"Initializedatabasefailed"<

6、dl;12.13.try{14.pRst=pMyConnect->Execute("select*fromRockets",NULL,adCmdText);15.if(!pRst->BOF)16.{17.pRst->MoveFirst();18.}19.else20.{21.cout<<"Thedatainthetableisnull"<column_name;27.for(inti=0;i

7、t->Fields->GetCount();i++)28.{29.cout<Fields->GetItem(_variant_t((long)i))->Name<<"/t";30.column_name.push_back(pRst->Fields->GetItem(_variant_t((long)i))->Name);31.}32.cout<adoEOF)3.{4.vector<_bstr_t>::iteratorit

8、er=column_name.begin();5./*for(iter;iter!=column_name.end();iter++)6.{*/7.if(pRst->GetCollect(*iter).vt!=VT_NULL)8.{9.//cout<<(_bstr_t)pRst->GetCollect(*iter)<<"/t/ti="<