VC 如何通过api与MySQL数据库连接

void CDbtestDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	AfxOleInit();
	m_mysql=mysql_init(NULL);
	mysql_real_connect(m_mysql,m_hst,m_usr,m_pwd,m_db,0,NULL,0);
	mysql_query(m_mysql,"set names GBK");//
	mysql_real_query(m_mysql,"SELECT * FROM tablecodes t",(unsigned long)strlen("SELECT * FROM tablecodes t"));
	m_res=mysql_use_result(m_mysql);
	while((m_row=mysql_fetch_row(m_res))!=NULL)
		((CListBox*)GetDlgItem(IDC_LIST1))->AddString((LPCTSTR)m_row[2]);
	my_ulonglong i=mysql_num_rows(m_res);
	char temp[20];
	AfxMessageBox(itoa(i,temp,10));
	mysql_free_result(m_res);
	mysql_close(m_mysql);
	((CButton*)GetDlgItem(IDC_BUTTON1))->EnableWindow(FALSE);
}