vc利用ado连接mysql

#include <iostream>
#include <windows.h>
#include <atlbase.h>
#include <adoint.h>
#include <adodb.h>

int main() {
    CoInitialize(NULL);

    // 创建ADO连接对象
    CComPtr<ADODB::_Connection> pConnection;
    HRESULT hr = pConnection.CoCreateInstance(__uuidof(ADODB::Connection));
    if (FAILED(hr)) {
        std::cerr << "Failed to create ADO connection object." << std::endl;
        CoUninitialize();
        return -1;
    }

    // 设置连接字符串
    _bstr_t connectionString = "Driver={MySQL ODBC 8.0 Unicode Driver};Server=your_server;Database=your_database;Uid=your_username;Pwd=your_password;";
    hr = pConnection->Open(connectionString, "", "", ADODB::adConnectUnspecified);
    if (FAILED(hr)) {
        std::cerr << "Failed to open connection." << std::endl;
        CoUninitialize();
        return -1;
    }

    // 创建ADO命令对象
    CComPtr<ADODB::_Command> pCommand;
    hr = pCommand.CoCreateInstance(__uuidof(ADODB::Command));
    if (FAILED(hr)) {
        std::cerr << "Failed to create ADO command object." << std::endl;
        pConnection->Close();
        CoUninitialize();
        return -1;
    }

    // 设置命令文本
    pCommand->put_ActiveConnection(pConnection);
    pCommand->put_CommandText(CComBSTR("SELECT * FROM your_table"));

    // 执行命令并获取结果集
    CComPtr<ADODB::_Recordset> pRecordset;
    hr = pCommand->Execute(NULL, NULL, ADODB::adCmdText, &pRecordset);
    if (FAILED(hr)) {
        std::cerr << "Failed to execute command." << std::endl;
        pConnection->Close();
        CoUninitialize();
        return -1;
    }

    // 处理结果集
    while (!pRecordset->adoEOF) {
        CComVariant varValue;
        pRecordset->Fields->get_Item(CComVariant("your_column"))->Value = varValue;
        std::wcout << varValue.bstrVal << std::endl;
        pRecordset->MoveNext();
    }

    // 关闭连接
    pConnection->Close();
    CoUninitialize();

    return 0;
}