C++连接Mysql

#include <cstdlib>
#include <iostream>
#include <windows.h>
#include <mysql/mysql.h>


using namespace std;

int main(int argc, char *argv[])
{
  char* user="root";
  char* host="localhost";
  char* db="czp";
  char* pwd="czp123";
  char* encode="GBK";
  char* select="select * from test";
  MYSQL *mysql;
  MYSQL_RES *res;
  MYSQL_ROW row;
  
  mysql=mysql_init(0);
  if (mysql_real_connect(mysql, host, user, pwd, db, 0, NULL, 0))
  {
      cout<<"Connectd Ok"<<endl;                                                
  }
  if(!mysql_set_character_set(mysql,encode))
  {
         cout<<"set character "<<encode<<endl;                           
  }
  if(mysql_query(mysql,select))
  {
      cout<<"query"<<endl;                         
  }
  if(!(res=mysql_store_result(mysql)))
  {
      cout<<"error"<<endl;                                
  }
  MYSQL_FIELD * field;
  while(field= mysql_fetch_field(res))
  {
       cout<<field->name<<"      ";                              
  }
    cout<<"\n";
  while (row =mysql_fetch_row (res))
  {
        cout<<row[0]<<"   "<<row[1]<<endl;                         
  }
  cout<<"\n";
  mysql_free_result(res);
  mysql_close(mysql);
  system("PAUSE");	
  return EXIT_SUCCESS;
}





     *注意： 需要对工程作如下设置：
     1）“工程”-〉“工程属性” 中 “参数”选项卡
     在“编译器”和“C++编译器”中加入
    “-Wall”和“-W”不包括“”，在“连接器”中加入“-lmysql”不包括“”