linux c mysql 多线程,linux下多線程連接mysql（C語言）

int main()

{

mysql_library_init(0,NULL,NULL);

pthread_t producer;

pthread_t consumer_1;

pthread_t consumer_2;

//produce_fun不涉及數據庫鏈接，不貼出來

pthread_create(&producer,NULL,produce_fun,NULL);

pthread_create(&consumer_1,NULL,consume_fun,NULL);

pthread_create(&consumer_2,NULL,consume_fun,NULL);

//下面的三句非常重要，main線程等待其他三個線程的結束，避免main線程執行到mysql_library_end時退出，而

//其他三個線程仍然在運行並報錯的情形

pthread_join(producer,NULL);

pthread_join(consumer_1,NULL);

pthread_join(consumer_2,NULL);

mysql_library_end();

return 0;

}

void addRecord_d(MYSQL *ptr_db,const char *t_name,int item){

char query_buffer[100];

sprintf(query_buffer,"insert into %s values(0,%d)",t_name,item);

int ret=mysql_query(ptr_db,query_buffer);

if(ret){

fprintf(stderr,"%s%s\n","cannot add record to ",t_name);

return;

}

unsigned long long update_id=mysql_insert_id(ptr_db);

printf("add record (%llu,%d) ok.",update_id,item);

}

void * consume_fun(void *arg){

MYSQL db;

MYSQL *ptr_db=mysql_init(&db);

mysql_real_connect();

//藍色部分可以改為其他任何帶操作數據庫語句的代碼

//procedure

while(1){

printf("consumer...");

int item=consume(&p);

addRecord_d(ptr_db,"test",item);

}

mysql_thread_end();

pthread_exit(NULL);

}