mfc mysql执行sql文件

#include <mysql.h>
#include <iostream>
#include <fstream>
#include <string>

void ExecuteSQLFile(const std::string& dbHost, const std::string& dbName, const std::string& dbUser, const std::string& dbPass, const std::string& sqlFilePath) {
    MYSQL* conn = mysql_init(NULL);
    if (!mysql_real_connect(conn, dbHost.c_str(), dbUser.c_str(), dbPass.c_str(), dbName.c_str(), 0, NULL, 0)) {
        std::cerr << "Connection error: " << mysql_error(conn) << std::endl;
        mysql_close(conn);
        return;
    }

    std::ifstream sqlFile(sqlFilePath);
    if (!sqlFile.is_open()) {
        std::cerr << "Failed to open SQL file: " << sqlFilePath << std::endl;
        mysql_close(conn);
        return;
    }

    std::string sqlContent((std::istreambuf_iterator<char>(sqlFile)), std::istreambuf_iterator<char>());
    sqlFile.close();

    if (mysql_query(conn, sqlContent.c_str())) {
        std::cerr << "SQL execution error: " << mysql_error(conn) << std::endl;
    } else {
        std::cout << "SQL executed successfully" << std::endl;
    }

    mysql_close(conn);
}

int main() {
    std::string dbHost = "localhost";
    std::string dbName = "testdb";
    std::string dbUser = "root";
    std::string dbPass = "password";
    std::string sqlFilePath = "path/to/your/sqlfile.sql";

    ExecuteSQLFile(dbHost, dbName, dbUser, dbPass, sqlFilePath);

    return 0;
}