windows 連結mysql

int main(int argc, char* argv[]){const char *host = "localhost";//主機const char *user = "root";//使用者名稱const char *passwd = "12321 ";//密碼const char *db = "mydb";//資料庫名unsigned int port = 3306;//mysql連接埠const char *unix_socket = 0;unsigned long client_flag = 0;MYSQL mysql;MYSQL_RES *result;MYSQL_FIELD *field;    MYSQL_ROW sql_row;string temp_time = GetNewTime(3);string sql_select = "select kid,keyword_hash,keyword,record_time from words_realtime where record_time < '"+temp_time+"'";mysql_library_init(0,NULL,NULL);//初始化MYSQL C APImysql_init(&mysql);mysql_options(&mysql,MYSQL_SET_CHARSET_NAME,"GBK");if(mysql_real_connect(&mysql,host,user,passwd,db,port,unix_socket,client_flag)){cout<<"database connection OK!"<<endl<<endl;int res = mysql_query(&mysql,sql_select.c_str());if(!res){//mysql_query執行成功返回0cout<<"Query success!"<<endl<<endl;result = mysql_store_result(&mysql);if(result){int i,j;                cout<<"number of result: "<<(unsigned long)mysql_num_rows(result)<<endl<<endl;for(i=0;field=mysql_fetch_field(result);i++)//擷取列名{cout<<field->name<<"";}cout<<endl;while(sql_row = mysql_fetch_row(result)){for(i=0;i<mysql_num_fields(result);i++)                    {                        cout<<sql_row[i]<<"";                    }                    cout<<endl;}}}else{cout<<mysql_error(&mysql)<<endl;}}mysql_close(&mysql);system("pause");return 0;}