典型的vc操作MYSQL的过程

#define OK 0typedef int RESULT;void InitUserComboBox(){CMainFrame *pMainFrame = (CMainFrame*)AfxGetMainWnd();MYSQL *pMySQL;// Initialize a MYSQL object.pMySQL = mysql_init(NULL);if (pMySQL == NULL){return;}// Establish a connection to MYSQL databasepMySQL = mysql_real_connect(pMySQL, pMainFrame->strMySQLIP,pMainFrame->strMySQLUser, pMainFrame->strMySQLPass, pMainFrame->strMySQLDB, pMainFrame->nMySQLPort, NULL, 0);if (pMySQL == NULL){return;}// Set the default character set for the current connectionmysql_set_character_set(pMySQL, "GBK");// specify the default (current) database RESULT ret;ret = mysql_select_db(pMySQL, "HrINetDB");if (ret != OK){mysql_close(pMySQL);return;}// Execute a queryCString strSql = _T(" select empName from T_SC_UserManager where iState<>'0' ");ret = mysql_query(pMySQL, strSql);if (ret != OK){mysql_close(pMySQL);return;}// Store result setMYSQL_RES *pRes;pRes = mysql_store_result(pMySQL);if (pRes == NULL){mysql_close(pMySQL);return;}// Get the number of result setint num = mysql_num_rows(pRes);if (num <= 0){mysql_free_result(pRes);mysql_close(pMySQL);return;}// Retrieves the next row of a result setMYSQL_ROW row;while (row = mysql_fetch_row(pRes)){m_comUser.AddString(row[0]);}// Frees the memory allocated for a result set mysql_free_result(pRes);// Closes a previously opened connectionmysql_close(pMySQL);}