mfc odbc mysql数据库_MFC- Mysql数据库连接-ODBC

1、安装mysql 驱动

2、控制面板->管理工具->数据源(ODBC)添加mysql

3、数据库操作源代码

try

{

CDatabase db;

CRecordset rs( &db );

db.Open("MysqlDb");

rs.Open( CRecordset::forwardOnly, _T("SELECT * FROM stu order by id desc "));/*asc*/

//short nFields = rs.GetODBCFieldCount();

while(!rs.IsEOF())

{

CString varID;

rs.GetFieldValue("id", varID);

mList.InsertItem(0,varID);// CListCtrl mList;

CString varName;

rs.GetFieldValue("name", varName);

mList.SetItemText(0, 1, varName);

CString varAge;

rs.GetFieldValue("age", varAge);

mList.SetItemText(0, 2, varAge);

rs.MoveNext();

}

GetDlgItem(IDC_BUTTON)->EnableWindow(FALSE);

rs.Close();

db.Close();

}

catch(CDBException *e)

{

AfxMessageBox(e->m_strError);

e->Delete();

}