1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| #include <winsock.h> #include <mysql.h> #include <iostream> using namespace std;
#pragma comment(lib,"libmysql.lib") int main() { const char user[] = "username"; const char pswd[] = "password"; const char host[] = "localhost"; const char table[] = "mydb"; unsigned int port = 3306; MYSQL myCont; MYSQL_RES *result; MYSQL_ROW sql_row; MYSQL_FIELD *fd; char column[32][32]; int res; mysql_init(&myCont); if(mysql_real_connect(&myCont,host,user,pswd,table,port,NULL,0)) { cout<<"connect succeed!"<<endl; mysql_query(&myCont, "SET NAMES GBK"); res=mysql_query(&myCont,"select * from mytable"); if(!res) { result=mysql_store_result(&myCont); if(result) { int i,j; cout<<"number of result: "<<(unsigned long)mysql_num_rows(result)<<endl; for(i=0;fd=mysql_fetch_field(result);i++) { strcpy(column[i],fd->name); } j=mysql_num_fields(result); for(i=0;i<j;i++) { printf("%10s\t",column[i]); } printf("\n"); while(sql_row=mysql_fetch_row(result)) { for(i=0;i<j;i++) { printf("%10s\t",sql_row[i]); } printf("\n"); } } } else { cout<<"query sql failed!"<<endl; } } else { cout<<"connect failed!"<<endl; } if(result!=NULL) mysql_free_result(result); mysql_close(&myCont); return 0; }
|