/*
* =====================================================================================
*
* 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;
}
