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();
}