如何在C++中连接MySQL数据库？

#include <iostream>
#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>

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

        // 创建驱动程序实例
        driver = get_driver_instance();

        // 建立连接
        con = driver->connect("tcp://127.0.0.1:3306", "username", "password");

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

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

        // 执行查询
        res = stmt->executeQuery("SELECT * FROM your_table");

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

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

    } catch (sql::SQLException &e) {
        std::cout << "# ERR: SQLException in " << __FILE__;
        std::cout << "(" << __FUNCTION__ << ") on line " << __LINE__ << std::endl;
        std::cout << "# ERR: " << e.what();
        std::cout << " (MySQL error code: " << e.getErrorCode();
        std::cout << ", SQLState: " << e.getSQLState() << " )" << std::endl;
    }

    return 0;
}

#include <iostream>
#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/prepared_statement.h>

int main() {
    try {
        sql::Driver *driver;
        sql::Connection *con;
        sql::PreparedStatement *pstmt;

        // 创建驱动程序实例
        driver = get_driver_instance();

        // 建立连接
        con = driver->connect("tcp://127.0.0.1:3306", "username", "password");

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

        // 开始事务
        con->setAutoCommit(false);

        // 准备语句
        pstmt = con->prepareStatement("INSERT INTO your_table (name) VALUES (?)");

        // 执行多次插入
        pstmt->setString(1, "John");
        pstmt->executeUpdate();

        pstmt->setString(1, "Doe");
        pstmt->executeUpdate();

        // 提交事务
        con->commit();

        // 清理资源
        delete pstmt;
        delete con;

    } catch (sql::SQLException &e) {
        std::cout << "# ERR: SQLException in " << __FILE__;
        std::cout << "(" << __FUNCTION__ << ") on line " << __LINE__ << std::endl;
        std::cout << "# ERR: " << e.what();
        std::cout << " (MySQL error code: " << e.getErrorCode();
        std::cout << ", SQLState: " << e.getSQLState() << " )" << std::endl;

        // 如果发生错误，回滚事务
        if (con != nullptr) {
            con->rollback();
        }
    }

    return 0;
}