xcode里用mysql

首先在build setting 里作这几个改动

在mysql里原创建有一个stu表在student database里。

按照网上搜的代码照葫芦画瓢用c++ 链接mysql 输出上面的数据

#include <iostream>
#include <mysql.h>
using namespace std;
int main(){
    const char user[] = "root";
    const char password[] = "DDKwestbrook0";
    const char host[] = "localhost";
    const char table[] = "student";//database
    unsigned int port = 3306;//server port
    MYSQL mysql;
    MYSQL_RES *result;
    MYSQL_ROW sql_row;
    MYSQL_FIELD *fd;
    char column[32][32];
    int res;
    mysql_init(&mysql);
    if (mysql_real_connect(&mysql, host, user, password, table, port, NULL, 0)) {
        cout<<"connect succeed!"<<endl;
       // mysql_query(&mysql, "SET NAMES GBK");设置编码格式，否则在cmd下无法显示中文
        res=mysql_query(&mysql, "select * from stu");//查询
        if (!res) {
            result=mysql_store_result(&mysql);
            //保存查询的数据到result
            if (result) {
                int i,j;
                cout<<"number of result : "<<(unsigned long)mysql_num_rows(result)<<endl;
                for (i=0; fd=mysql_fetch_field(result); i++) {
                    //获取列名
                    strcpy(column[i], fd->name);
                }
                j=mysql_num_fields(result);
                for (i=0; i<j; i++) {
                    cout<<column[i]<<endl;
                }
                while (sql_row=mysql_fetch_row(result)) {
                    //获得具体的数据
                    for (i=0; i<j; i++) {
                        cout<<sql_row[i];
                    }
                    cout<<endl;
                }
            }
        }
        else{
            cout<<"query sql failed"<<endl;
        }
    }
    else{
        cout<<"connect failed!"<<endl;
    }
    if (result!=NULL) {
        mysql_free_result(result);
        //释放资源结果
    }
    mysql_close(&mysql);
    //断开链接
    return 0;

}

结果是：