6.#in"> 6.#in" />
欢迎来到天天文库
浏览记录
ID:1932439
大小:37.06 KB
页数:5页
时间:2017-11-13
《简单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","adoEOF
2、")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.//打开数据库21
3、.//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;/24.DriverId=25;
4、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.4.0;DataSource=shuj
5、uku.mdb;PersistSecurityInof=False;","","",adModeUnknown);2.}3.catch(_com_error&e)4.{5.cout<<"Initializedatabasefailed"<6、onnect->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;iFields->GetCount();i++)28.{7、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>::iteratoriter=column_name.begin();5./*for(iter8、;iter!=column_name.end();iter++)6.{*/7.if(pRst->GetCollect(*iter).vt!=VT_NULL)8.{9.//cout<<(_bstr_t)pRst->GetCollect(*iter)<<"/t/ti="<
6、onnect->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;iFields->GetCount();i++)28.{
7、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>::iteratoriter=column_name.begin();5./*for(iter
8、;iter!=column_name.end();iter++)6.{*/7.if(pRst->GetCollect(*iter).vt!=VT_NULL)8.{9.//cout<<(_bstr_t)pRst->GetCollect(*iter)<<"/t/ti="<
此文档下载收益归作者所有