怎么给VC连接mysql数据库

#include <mysql_driver.h>
#include <mysql_connection.h>

using namespace sql;

int main()
{
    // 创建MySQL数据库连接对象
    sql::mysql::MySQL_Driver *driver;
    sql::Connection *con;

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

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

    // 设置使用的数据库
    con->setSchema("database_name");

    // 创建Statement对象
    sql::Statement *stmt;
    stmt = con->createStatement();

    // 执行SQL查询语句
    sql::ResultSet *res;
    res = stmt->executeQuery("SELECT * FROM table_name");

    // 处理查询结果
    while (res->next()) {
        cout << "Column1: " << res->getString("column1") << endl;
        cout << "Column2: " << res->getInt("column2") << endl;
    }

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

    return 0;
}