【MySQL学习】C++外部调用

#include "mysql.h"
MYSQL *mysql;
MYSQL_RES *rec;
MYSQL_ROW row; 
1
2
3
4

（1）连接

char *server = "localhost";
char *user = "root";
char *password = "hello";
char *database = "mysql";
mysql = mysql_init(NULL);
if(!mysql_real_connect(mysql, server, user, password, database, 0, NULL, 0))
    printf("Connect Failed: %sn\n", mysql_error(mysql));
else
    printf("Connect Succeed ! \n");
1
2
3
4
5
6
7
8
9

（2）运行

string str="show databases;";
if(mysql_real_query(mysql,str.c_str(),str.length()))  
{  
    cout << mysql_error(mysql) << endl;  
    return -1;  
}  
1
2
3
4
5
6

（3）显示结果

rec=mysql_store_result(mysql);
while(row = mysql_fetch_row(rec))  
{  
    for(int i = 0;i < mysql_num_fields(rec);i++)  
    {  
        if(row[i] != NULL)  
            cout << row[i] << "\t";  
        else  
            cout << "" << "\t";  
    }  
    cout << "\n";  
}  
1
2
3
4
5
6
7
8
9
10
11
12

（4）释放记录

mysql_free_result(rec);
1

（5）关闭连接

mysql_close(mysql);
1

（6）获取记录数

mysql_num_fields(rec);
1