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);

}