mfc读取mysql

#include <afxdb.h>

void CMyApp::DoDataExchange(CDataExchange* pDX)
{
    CDialogEx::DoDataExchange(pDX);
}

BEGIN_MESSAGE_MAP(CMyApp, CDialogEx)
END_MESSAGE_MAP()

BOOL CMyApp::OnInitDialog()
{
    CDialogEx::OnInitDialog();

    // 连接字符串
    CString strConnection = _T("DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=mydatabase;UID=myuser;PWD=mypassword;");

    // 创建数据库连接
    CDatabase db;
    if (!db.OpenEx(strConnection, CDatabase::noOdbcDialog))
    {
        AfxMessageBox(_T("无法连接到数据库"));
        return FALSE;
    }

    // 执行查询
    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();

    return TRUE;  // return TRUE  unless you set the focus to a control
}