xcode里用mysql

来源：互联网发布：nvidia cuda windows 编辑：程序博客网时间：2024/05/17 01:45

首先在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;}

结果是：

阅读全文

0 0