c语言 mysql 查询数字_c语言mysql查询数据库

#include

#include

#include

int main()

{

MYSQL mysql;

MYSQL_RES *res=NULL;

MYSQL_ROW row;

MYSQL_FIELD *fields; //保存字段名字信息

unsigned int num_fields;

unsigned int i;

char query[1024];

int flag,t,r;

int serviceID=3;

char test[1024];

mysql_init(&mysql);

//根据需要修改连接信息

if(!mysql_real_connect(&mysql,"targetIP","username","passwd","databaseName",0,NULL,0))

{

printf("Error connecting to database \n");

return 0;

}

else

printf("Connected MYSQL successfully!\n");

memset(query,'\0',1024);

sprintf(query,"select SERVICE_ID,NAME from XXXX where SERVICE_ID !=%d",serviceID);

flag=mysql_real_query(&mysql,query,(unsigned int)strlen(query));

if(flag)

/*failure*/

{

printf("query failed! \n");

return 0;

}

else

{

res=mysql_store_result(&mysql);

//输入内容的title

num_fields = mysql_num_fields(res); //获取查询结果中，字段的个数

fields = mysql_fetch_fields(res); //获取查询结果中，各个字段的名字

for(i = 0; i < num_fields;i++)

{

printf("结果字段%u是： %s\n",i,fields[i].name);

}

//输入内容的行数

printf("Number of rows %lu\n",(unsigned long)mysql_num_rows(res));

if((unsigned long)mysql_num_rows(res)>1024)

{

printf("MAXIPLIST is not enough！\n");

return 0;

}

while(row=mysql_fetch_row(res))

{

//for(t=0;t

//{

printf("ServiceId is %s\n ",row[0]);

strcpy(test,row[1]);

printf("Name is %s",test);

//}

printf("\n");

}

mysql_free_result(res);

mysql_close(&mysql);

return 0;

}

}