第三章 和c++串联起来

• 命令： g++ mysql.cc -L usr/lib/mysql -lmysqlclient

#include<mysql/mysql.h>
#include<iostream>
using namespace std;
MYSQL *conn;
MYSQL_RES *res;
MYSQL_ROW row;
int main()
{
    const char *server = "localhost";
    const char *user= "root";
    const char *password = "alex";
    const char *database = "test03";
    conn = mysql_init(NULL);
    if(!mysql_real_connect(conn,server,user,password,database,0,NULL,0))
    {
        cout<<"connect error"<<endl;
        return 0;
    }
    mysql_set_character_set(conn,"utf8");
    if(mysql_query(conn,"select * from students"))
    {
        cout<<"query error"<<endl;
        return 0;
    }
    res = mysql_use_result(conn);
    while((row = mysql_fetch_row(res))!=NULL)
    {
        cout<<row[0]<<" "<<row[1]<<endl;
    }
    mysql_free_result(res);
    mysql_close(conn);
    return 0;
}