MYSQL的C API函数使用

#include "Header.h" void main() { MYSQL mysql; MYSQL_RES* res; MYSQL_ROW row; unsigned int num_fileds,num_rows; int i; mysql_init(&mysql); printf("The DataBase Version is: %s\n",mysql_get_client_info());//输出数据库版本 if( !mysql_real_connect(&mysql,"localhost","root","900914","mysql",3306,NULL,0) ) { //连接数据库失败 printf("%s\n",mysql_error(&mysql)); return ; } printf("The Link Style Version is: %s\n",mysql_get_host_info(&mysql));//返回描述正在使用的连接类型的字符串，包括服务其主机名 printf("The Protol Version is: %d\n",mysql_get_proto_info(&mysql));//返回正在使用协议版本 printf("The Server Version is: %s\n",mysql_get_server_info(&mysql));//返回服务器版本号 //指示服务者将一些调试信息写入日志文件 if( mysql_dump_debug_info(&mysql) != 0) { //操作失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } //新建表 if( mysql_query(&mysql, "truncate table pet") != 0) //mysql_query(&mysql, "delete from pet") { //新建表失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } //新建表 /* if( mysql_query(&mysql, "create table pet(name VARCHAR(20),owner VARCHAR(20),species VARCHAR(20), sex CHAR(1), birth DATE)" ) != 0) { //新建表失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } */ //向表中插入 if( mysql_query(&mysql, "insert into pet values('Fluffy','GWen','cat','m','2013-08-01')" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } if( mysql_query(&mysql, "insert into pet values('Whistler','Green','bird','m','2012-07-01')" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } //直接将文本插入 if( mysql_query(&mysql, "load data local infile 'G:/pet.txt' into table pet" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } //显示所有数据库 if( mysql_query(&mysql, "show databases" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } /* //显示数据库中表 if( mysql_query(&mysql, "show tables" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } //显示表列名 if( mysql_query(&mysql, "show columns from pet" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } */ //检索信息:雌性宠物 if( mysql_query(&mysql, "select * from pet where sex = 'm'" ) != 0) { //插入失败 printf("%s\n",mysql_error(&mysql)); mysql_close(&mysql); return ; } //查看检索结果 res = mysql_store_result(&mysql);//查询结果全部存储进来 num_fileds = mysql_num_fields(res);//列数目 num_rows = (unsigned int)mysql_num_rows(res);//行数目 printf("The num. of row is: %d, the num. of field is: %d\n",num_fileds,num_rows); printf("\n Output the info. of male pets:\n"); while(row = mysql_fetch_row(res))//返回一行数据 { unsigned long *lengths; lengths = mysql_fetch_lengths(res);//返回每行各表项内容长度 for(i = 0; i < (int)num_fileds; i++) { printf("[%.*s] ", (int) lengths[i], row[i] ? row[i] : "NULL"); } printf("\n"); } printf("\n The Latest Operation Info. is: %s\n",mysql_info(&mysql));//返回关于最近执行得查询的信 mysql_free_result(res);//释放资源 mysql_close(&mysql); }