dataselect.c

读取mysql数据库中某个表的内容

#include <mysql.h>
#include <stdio.h>
#include <string.h>
#include <unistd.h>
int dataselect(char abc[20])
{
	MYSQL mysql;
	MYSQL_RES *res;
	MYSQL_ROW row;
	char *query;
	int t,num;
	char databasename[20];
	strcpy(databasename,abc);
	mysql_init(&mysql);
	query = malloc(100);
	
	if(!mysql_real_connect(&mysql,"localhost","root","123456","test",0,NULL,0))
	{
		      printf("error connecting to database : %s\n",mysql_error(&mysql));
	}
	else
		printf("connecting....\n");
	
	sprintf(query , "select * from %s",databasename);
	//query = "select * from Radartest";
	t = mysql_real_query(&mysql,query,(unsigned int) strlen(query));
	
	if(t)
	{
		printf("error making query:%s\n");
	}
	else 
		printf("%s made ...\n");
	
	res = mysql_store_result(&mysql);
	while(row = mysql_fetch_row(res))
	{
		num = mysql_num_fields(res);
	//	printf("column = %d\n",num);
		for(t = 0;t < num;t ++)
		{
			printf("%s\n",row[t]);
		}
		printf("%d\n",strlen(query));
		printf("/n");
	}
	
	mysql_free_result(res);
	sleep(10);
	mysql_close(&mysql);
//	delete [] query;
	return 0;
}
int main(){
	char name[20];
	strcpy(name,"Radartest");
	dataselect(name);
	return 0;
	
}