C++导入和使用ADO

#include<iostream>
#include <comdef.h>
#include <adodb.h>

int main()
{
    try
    {
        // 创建ADO连接
        _ConnectionPtr pConnection = NULL;
        pConnection.CreateInstance(__uuidof(Connection));

        // 连接到数据库
        pConnection->Open("Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=mydb;User ID=myuser;Password=mypassword;", "", "", adConnectUnspecified);

        // 创建ADO命令
        _CommandPtr pCommand = NULL;
        pCommand.CreateInstance(__uuidof(Command));
        pCommand->ActiveConnection = pConnection;
        pCommand->CommandText = "SELECT * FROM mytable";

        // 执行查询
        _RecordsetPtr pRecordset = NULL;
        pRecordset.CreateInstance(__uuidof(Recordset));
        pRecordset = pCommand->Execute(NULL, NULL, adCmdText);

        // 遍历结果集
        while (!pRecordset->EndOfFile)
        {
            std::cout << pRecordset->Fields->GetItem("column1")->Value<< std::endl;
            pRecordset->MoveNext();
        }

        // 关闭连接
        pConnection->Close();
    }
    catch (_com_error &e)
    {
        std::cout << "Error: " << e.ErrorMessage()<< std::endl;
    }

    return 0;
}