C++连接Mysql

来源:互联网 发布:梦想破灭 知乎 编辑:程序博客网 时间:2024/06/03 09:04
#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”不包括“”