MFC连接MYSQL

先安装MYSQL 的ODBC驱动,然后在系统的数据源当中添加好新的DSN

然后就可以在代码当中连接了:

	try{
		CDatabase db;
		if(db.Open(NULL,FALSE,FALSE,"ODBC;DSN=mysqlDatabase;UID=root;PWD=********"))
		{
			MessageBox("Connection OK");
		}else{
			MessageBox("Connection failed");
		}
	}catch(CDBException* e)
	{
		AfxMessageBox(e->m_strError);
		e->Delete();
	}

获取结果集:

			CRecordset m_set(&db);
			m_set.Open( CRecordset::forwardOnly,("select * from Test"));
			while(!m_set.IsEOF()){
			CString name;
			m_set.GetFieldValue("name",name);
			MessageBox(name);
			m_set.MoveNext();
			}