C++连接mysql CURD

C++连接数据库并查询数据表person：
person数据表：

#include <string>
#include <stdio.h>
#include <iostream>
#include <mysql.h>

using namespace std;

int  main()  
{  
  MYSQL mysql;
  mysql_init(&mysql);
  if (!mysql_real_connect(&mysql,"127.0.0.1","root","123123123","ming",0,0,0))//连接数据库
  {
      //unable to connect
      printf("Oh Noes!\n");
  }
  else
  {
      printf("Connected.\n");
  }
  mysql_query(&mysql,"set names gbk");
  char* pQuery = "select * from person;"; //查询语句
	if(mysql_real_query(&mysql,pQuery,strlen(pQuery)) != 0)
	{
		const char* pCh = mysql_error(&mysql);
    printf("query failed %s\n", pCh);
		return 1;
	} else
  {
     printf("query successed\n");
  }
  MYSQL_RES *res = mysql_store_result(&mysql);
  if(res != NULL) {
    unsigned int nCol = mysql_num_fields(res);
			MYSQL_ROW column;
			while(column=mysql_fetch_row(res))
			{
				for(int c=0;c<nCol;c++)
				{
					printf("%s\t",column[c]);
				}
			}
			mysql_free_result(res);
  }
  mysql_close(&mysql);
  return 0;
}

执行结果：