mfc通过odbc连接mysql

#include <afxdb.h>

void ConnectToMySQL()
{
    // 创建数据库对象
    CDatabase db;

    // 打开数据库连接
    CString strConnection;
    strConnection.Format(_T("ODBC;DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=localhost;DATABASE=mydatabase;UID=myuser;PWD=mypassword;"));
    if (!db.OpenEx(strConnection, CDatabase::noOdbcDialog))
    {
        AfxMessageBox(_T("Failed to connect to MySQL database!"));
        return;
    }

    // 执行SQL查询
    CRecordset rs(&db);
    rs.Open(CRecordset::forwardOnly, _T("SELECT * FROM mytable"));

    // 处理查询结果
    while (!rs.IsEOF())
    {
        CString strValue;
        rs.GetFieldValue(_T("mycolumn"), strValue);
        AfxMessageBox(strValue);
        rs.MoveNext();
    }

    // 关闭记录集和数据库连接
    rs.Close();
    db.Close();
}