从文本文件中读取数据并将数据存储到表中会使用c++生成损坏的表

#include <iostream>
#include <fstream>
#include <string>
#include <mysql_driver.h>
#include <mysql_connection.h>

using namespace std;

int main() {
    // 打开文本文件
    ifstream inputFile("data.txt");
    if (!inputFile.is_open()) {
        cout << "无法打开文件" << endl;
        return 1;
    }

    // 连接到数据库
    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;
    stmt = con->createStatement();
    stmt->execute("CREATE TABLE IF NOT EXISTS my_table (id INT, name VARCHAR(50))");

    // 读取文件并插入数据到表中
    string line;
    while (getline(inputFile, line)) {
        // 解析数据
        int id;
        string name;
        // 这里根据实际的数据格式进行解析，假设每行数据格式为"id,name"
        size_t commaPos = line.find(",");
        if (commaPos != string::npos) {
            id = stoi(line.substr(0, commaPos));
            name = line.substr(commaPos + 1);
        } else {
            cout << "数据格式错误：" << line << endl;
            continue;
        }

        // 插入数据到表中
        stmt->execute("INSERT INTO my_table (id, name) VALUES (" + to_string(id) + ", '" + name + "')");
    }

    // 关闭文件和数据库连接
    inputFile.close();
    delete stmt;
    delete con;

    return 0;
}