MySql SDK 编程简单查询

来源：互联网发布：工商网络监管工作总结编辑：程序博客网时间：2024/06/10 03:24

#include "stdafx.h"int main(int argc, char* argv[]){//初始化MYSQL *mysql =  mysql_init(NULL); //链接数据库if (mysql_real_connect(mysql,"localhost","root","admin","test",NULL,NULL,0)) {//执行SQL语句if (mysql_query(mysql,"select * from `data`") == 0) {//获得存储结果MYSQL_RES *res = mysql_store_result(mysql);if (res != 0){//获得行数MYSQL_ROW rows;while (rows = mysql_fetch_row(res)){//获得列数unsigned int uRowCount = mysql_num_fields(res);//循环打印列for (unsigned int ui=0 ; ui < uRowCount; ui++){printf("%s ",rows[ui]);}printf("\r\n");}mysql_free_result(res);}else{printf("get mysql res failed!\r\n");}}else{printf("execute sql failed! %s\r\n",mysql_error(mysql));}}else{printf("connect mysql faild!\r\n");}mysql_close(mysql);return 0;}

我尝试用简单的方法，给出一个简单过程，让大家知道流程是怎么的！

代码打包下载地址

http://download.csdn.net/detail/u012607841/6792107

0 0

MySql SDK 编程 简单查询

MySql SDK 编程简单查询