MySql SDK 编程 简单查询

#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