c++ ado连接mysql数据库_C++通过ADO连接ACCESS(或者SQL Server)数据库例子 | 学步园

#include "iostream.h"

#include "stdio.h"

#import "C:/program files/common files/system/ado/msado15.dll" no_namespace rename("EOF","adoEOF")

int main(int argc, char* argv[])

{

::CoInitialize(NULL);

_ConnectionPtr m_pConnection;

m_pConnection.CreateInstance("ADODB.Connection");

try

{

m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database//mydb.mdb","","",adModeUnknown);

//m_pConnection->Open("Server=192.168.0.150,1433;uid=sa;pwd=123456;DATABASE=temp;Provider=SQLOLEDB;","","",-1);//连接SQL Server

}

catch(_com_error e)

{

cout<

return FALSE;

}

_RecordsetPtr m_pRecordset;

m_pRecordset.CreateInstance("ADODB.Recordset");

try

{

m_pRecordset->Open("SELECT * FROM test",

m_pConnection.GetInterfacePtr(),

adOpenDynamic,

adLockOptimistic,

adCmdText);

}

catch(_com_error *e)

{

cout<ErrorMessage()<

}

_variant_t var;

char *ID,*name;

try

{

if(!m_pRecordset->BOF)

m_pRecordset->MoveFirst();

else {

cout<

return 1;

}

while(!m_pRecordset->adoEOF)

{

var = m_pRecordset->GetCollect("ID");

if(var.vt != VT_NULL)

ID= _com_util::ConvertBSTRToString((_bstr_t)var);

var = m_pRecordset->GetCollect("name");

if(var.vt != VT_NULL)

name=_com_util::ConvertBSTRToString((_bstr_t)var);

cout<

m_pRecordset->MoveNext();

}

}

catch(_com_error *e)

{

cout<ErrorMessage()<

}

m_pRecordset->Close();

m_pRecordset = NULL;

if(m_pConnection->State)

m_pConnection->Close();

m_pConnection= NULL;

return 0;

}