c++连接MySql数据库

来源:互联网 发布:刑不上大夫知乎 编辑:程序博客网 时间:2024/05/17 04:40
#include <iostream>#include<mysql/mysql.h>using namespace std;MYSQL *con;//该结构体代表了一个数据库连接句柄MYSQL_RES *res;//该结构体代表返回行的查询结果,返回的信息作为结果集,时一张数据表MYSQL_ROW row;//这个是一行数据的显示int main() {    char server[20] = "localhost";    char user[20] = "root";    char password[20] = "123456";    char database[20] = "mystudent";    con = mysql_init(NULL);//成功con不为NULL,失败con为NULL    if (!mysql_real_connect(con, server, user, password, database, 0, NULL, 0)) {        cout << "connect failed" << endl;    }    mysql_set_character_set(con, "utf8");    if (mysql_query(con, "select * from student")) {        cout << "query failed";    }//成功返回0,不成功返回非0    res = mysql_use_result(con);    //依次从结果集中获取每一行并打印    while ((row = mysql_fetch_row(res)) != NULL) {        cout << row[0] << " " << row[1] << " " << row[2] << " " << endl;    }    //释放结果集    mysql_free_result(res);    //关闭数据库    mysql_close(con);    return 0;}