vc与mysql数据库连接

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

int main() {
    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");

    // 连接成功后，可以执行各种数据库操作，例如执行SQL查询语句
    sql::Statement* stmt = con->createStatement();
    sql::ResultSet* res = stmt->executeQuery("SELECT * FROM table_name");

    // 遍历结果集并输出
    while (res->next()) {
        std::cout << "Column1: " << res->getString(1) << std::endl;
        std::cout << "Column2: " << res->getString(2) << std::endl;
    }

    // 关闭连接
    delete res;
    delete stmt;
    delete con;

    return 0;
}