mysql类使用增删改c_linux下c操作mysql之增删改查

#include #include "/usr/include/mysql/mysql.h"

int main(int argc,char *argv[])

{

MYSQL my_connection,*conn_ptr;

MYSQL_RES *res_ptr;

MYSQL_ROW sqlrow;

int iRet;

int iTableRow,iTableCol,i,j;

char *server = "localhost";

char *user = "root";

char *password = "";

char *database = "csql";

unsigned int uiTimeOut = 7;//设置连接超时7s

conn_ptr = mysql_init(&my_connection);//初始化连接句柄

if( !conn_ptr )

{

fprintf(stderr,"mysql_init failed ! \n");

return EXIT_FAILURE;

}

iRet = mysql_options(&my_connection,MYSQL_OPT_CONNECT_TIMEOUT,(const char *)&uiTimeOut);//设置连接超时

if( iRet )

{

fprintf(stderr,"Connection is timeout! \n");

return EXIT_FAILURE;

}

conn_ptr = mysql_real_connect(&my_connection,server,user,password,database,0,NULL,0);//连接数据库

if( conn_ptr )

{

printf("Connection success!\n");

iRet = mysql_query(&my_connection,"select * from children");//执行SQL语句

if( iRet )

{

fprintf(stderr,"select error %d: %s !\n",mysql_errno(&my_connection),mysql_error(&my_connection));//>打印错误处理具体信息

return EXIT_FAILURE;

}

res_ptr = mysql_store_result(&my_connection);//集合

if( res_ptr )

{

iTableRow = mysql_num_rows(res_ptr);//行

iTableCol = mysql_num_fields(res_ptr);//列

for(i=0; i