mysql.zip_MYSQL_c++ mysql

/* * ===================================================================================== * * Filename: mysql.c * * Description: * * Version: 1.0 * Created: 12/14/2015 05:29:22 PM * Revision: none * Compiler: gcc * * Author: YOUR NAME (), * Organization: * * ===================================================================================== */ #include <stdlib.h> #include<mysql/mysql.h> #include<stdio.h> #include<string.h> int main() { MYSQL test; MYSQL_RES * res; MYSQL_ROW row; unsigned int num; int i; char buf[]="hehe"; char buf1[]="nv"; mysql_init(&test); if (!mysql_real_connect(&test, "localhost", "root", "kalamodo", "test", 3306, 0, 0)) { perror("connect:"); return 0; } printf("mysql connect success\n"); #if 0 if (mysql_real_query(&test, "select * from user", (unsigned long)strlen("select * from user"))) { perror("query:"); return 0; } printf("mysql query success\n"); #endif // char *strInsert = "insert into user(name,sex) values(buf, 'nv')"; char strInsert[100] = "0"; //unsigned long insertLen = (unsigned long)strlen(strInsert); sprintf(strInsert,"insert into user(name,sex) values(%s,%s)",buf,buf1); //if (mysql_real_query(&test, "INSERT INTO user(id,name,sex) VALUES(3,'she','nv')", (unsigned long)strlen("select * from user"))) int index = 10; while(index--) { if (mysql_query(&test, strInsert)) { perror("query:insert"); return 0; } } printf("mysql insert success\n"); res = mysql_store_result(&test); if (NULL == res) { perror("store failure:"); return 0; } num=mysql_num_fields(res); while((row = mysql_fetch_row(res))) { for(i=0;i<num;i++) { printf("| %s", row[i]); } printf("\n"); } mysql_free_result(res); mysql_close(&test); return 0; }