MySql：连接和关闭

c++ connector

下面是一个示例，世界使用c++ connector时注意release版本和debug版本要和响应的动态库匹配才可以

#include <mysql_driver.h>
#include <mysql_connection.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>

int main() {
    // 创建 MySQL Connector/C++ 驱动程序对象
    sql::mysql::MySQL_Driver *driver;
    sql::Connection *con;

    // 初始化驱动程序对象
    driver = sql::mysql::get_mysql_driver_instance();

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

    // 连接到数据库
    con->setSchema("database_name");

    // 执行查询
    sql::Statement *stmt;
    sql::ResultSet *res;
    stmt = con->createStatement();
    res = stmt->executeQuery("SELECT * FROM your_table");

    // 处理结果集
    while (res->next()) {
        std::cout << "Column 1: " << res->getString(1) << std::endl;
        std::cout << "Column 2: " << res->getString(2) << std::endl;
    }

    // 释放资源
    delete res;
    delete stmt;
    delete con;

    return 0;
}