vc ado连接mysql

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

int main() {
    // 初始化 COM 库
    CoInitialize(NULL);

    // 创建 Connection 对象
    _ConnectionPtr pConn(__uuidof(Connection));

    try {
        // 设置连接字符串
        _bstr_t strConn = "Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=localhost;Database=testdb;Uid=root;Pwd=password;";

        // 打开连接
        pConn->Open(strConn, "", "", adConnectUnspecified);

        // 创建 Command 对象
        _CommandPtr pCmd(__uuidof(Command));
        pCmd->ActiveConnection = pConn;
        pCmd->CommandText = "SELECT * FROM users";

        // 执行查询并获取结果集
        _RecordsetPtr pRs(__uuidof(Recordset));
        pRs = pCmd->Execute(NULL, NULL, adCmdText);

        // 遍历结果集
        while (!pRs->adoEOF) {
            _variant_t var = pRs->Fields->GetItem("username")->Value;
            std::wcout << var.bstrVal << std::endl;
            pRs->MoveNext();
        }

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

    // 释放 COM 库
    CoUninitialize();

    return 0;
}