如何使用连接器c++在mySQL表二进制(16)字段中存储c++字节数组？

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

#include <sstream>

// 假设您已经创建了名为"my_table"的MySQL表

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

  // 连接到MySQL数据库
  con->setSchema("your_database");

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

  // 准备SQL语句，将字节数组存储在二进制字段中
  unsigned char byteArray[] = {0x01, 0x02, 0x03, 0x04};
  std::ostringstream byteArrayString;
  for (unsigned int i = 0; i < sizeof(byteArray); i++) {
    byteArrayString << std::hex << static_cast<unsigned int>(byteArray[i]);
  }
  std::string sqlQuery = "INSERT INTO my_table (binary_field) VALUES (x'" +
                         byteArrayString.str() + "')";

  // 执行SQL查询
  stmt->execute(sqlQuery);

  // 清理资源
  delete stmt;
  delete con;

  return 0;
}