// 0518A.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include #include #include #include //步骤1:添加对ADO的支持 #import "C:\Program Files (x86)\Common Files\System\ado\msado15.dll" no_namespace rename("EOF", "adoEOF") using namespace std; int _tmain(int argc, _TCHAR* argv[]) { CoInitialize(NULL); //初始化COM环境 _ConnectionPtr pMyConnect(__uuidof(Connection));//定义连接对象并实例化对象 _RecordsetPtr pRst(__uuidof(Recordset));//定义记录集对象并实例化对象 try { //步骤2:创建数据源连接 /*打开数据库“SQLServer”,这里需要根据自己PC的数据库的情况 */ pMyConnect->Open("Provider=SQLOLEDB; Server=.;Database=B; uid=sa; pwd=123;","","",adModeUnknown); } catch(_com_error &e) { cout<Execute("select * from Table_BB",NULL,adCmdText); //执行SQL: select * from Table_BB if(!pRst->BOF) { pRst->MoveFirst(); } else { cout< column_name; /*存储表的所有列名,显示表的列名*/ for(int i=0; i< pRst->Fields->GetCount();i++) { cout<Fields->GetItem(_variant_t((long)i))->Name<Fields->GetItem(_variant_t((long)i))->Name); } cout<adoEOF) { vector<_bstr_t>::iterator iter=column_name.begin(); for(iter;iter!=column_name.end();iter++) { if(pRst->GetCollect(*iter).vt !=VT_NULL) { cout<GetCollect(*iter)<MoveNext(); cout<
c++ mysql 取出数据,c++从数据库的表中读取数据
最新推荐文章于 2023-01-06 22:02:00 发布