C++如何连接MySQL数据库_C++使用Connector/C++操作MySQL数据库教程

<font face="Courier New">
g++ -o main main.cpp -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlcppconn
</font>

<font face="Courier New">
#include <mysqlx/xdevapi.h>
#include <mysql_connection.h>
#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>
#include <iostream>

using namespace std;

int main() {
    sql::Driver *driver;
    sql::Connection *con;
    sql::Statement *stmt;
    sql::ResultSet *res;

    try {
        // 获取数据库驱动
        driver = get_driver_instance();
        // 建立连接 (主机, 用户名, 密码)
        con = driver->connect("tcp://127.0.0.1:3306", "root", "your_password");

        // 选择数据库
        con->setSchema("testdb");

        // 创建语句对象
        stmt = con->createStatement();

        // 执行查询
        res = stmt->executeQuery("SELECT id, name FROM users");

        // 遍历结果
        while (res->next()) {
            cout << "ID: " << res->getInt("id")
                 << ", Name: " << res->getString("name") << endl;
        }

        // 清理资源
        delete res;
        delete stmt;
        delete con;

    } catch (sql::SQLException &e) {
        cout << "SQLException in " << __FILE__;
        cout << " (" << __FUNCTION__ << ") on line " << __LINE__ << endl;
        cout << "Error: " << e.what();
        cout << " [Error Code]: " << e.getErrorCode() << endl;
    }

    return 0;
}
</font>