【MySQL】MySQL API 示例代码

来源：互联网发布：java方法交换两个变量编辑：程序博客网时间：2024/05/21 07:55

-I/usr/include/mysql -L/usr/lib64/mysql/ -lmysqlclient -lstdc++ -ldl -lpthread -lrt

//实现查询功能#include "mysql.h"#include <stdio.h>#include <stdlib.h>#include <string.h>#define _HOST_ "127.0.0.1"  //主机#define _USER_ "root"    //数据库用户，不是操作用户#define _PASSWD_ "123"   //数据库root用户的密码#define _DB_NAME_ "scott" //数据库名称int main(){    //1. 初始化    MYSQL * mysql = mysql_init(NULL);    if(mysql == NULL){        printf("mysql init err\n");       exit(1);     }    //2. 连接    mysql = mysql_real_connect(mysql,_HOST_,_USER_,_PASSWD_,_DB_NAME_,0, NULL,0);    if(mysql == NULL){    printf("connect to mysql err\n");    exit(1);    }printf("welcome to mysql \n");//使用mysql_query执行查询，但是并没有得到结果集char rSql[512]="select * from emp";if(mysql_query(mysql,rSql) ){printf(" query err:%s\n",rSql);exit(1);}//需要调用mysql_store_result()获取结果集MYSQL_RES *result = mysql_store_result(mysql);unsigned int num_fields;int i;num_fields = mysql_num_fields(result);//取列数//打印表头MYSQL_FIELD *fields;fields = mysql_fetch_fields(result);for(i = 0; i < num_fields; i++){   printf("%s\t", fields[i].name);}printf("\n-----------------------------------------------------------------------\n");//华丽的分割线//打印结果集if(result != NULL){//有结果及，需要处理MYSQL_ROW row;//fetch_row 获取每一行，打印while((row = mysql_fetch_row(result)) ){//得到一行for(i = 0 ; i < num_fields ; i ++){printf("%s\t",row[i]);}printf("\n");//每行处理加一个换行}//释放mysql_free_result(result);//释放结果集}    //3. 断开    mysql_close(mysql);    return 0;}

阅读全文

0 0