mfc向mysql插入数据

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

void InsertData() {
    try {
        // 创建MySQL连接驱动
        sql::mysql::MySQL_Driver* driver = sql::mysql::get_mysql_driver_instance();

        // 创建连接
        std::unique_ptr<sql::Connection> con(driver->connect("tcp://127.0.0.1:3306", "username", "password"));

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

        // 创建预处理语句
        std::unique_ptr<sql::PreparedStatement> pstmt(con->prepareStatement("INSERT INTO table_name (column1, column2) VALUES (?, ?)"));

        // 设置参数
        pstmt->setString(1, "value1");
        pstmt->setString(2, "value2");

        // 执行插入操作
        pstmt->executeUpdate();

        // 关闭连接
        con->close();
    } catch (sql::SQLException& e) {
        std::cerr << "SQL Error: " << e.what() << std::endl;
    } catch (std::runtime_error& e) {
        std::cerr << "Runtime Error: " << e.what() << std::endl;
    }
}