怎样在C++中处理BLOB数据？

#include <mysqlx/xdevapi.h>
#include <iostream>
#include <fstream>

int main() {
    try {
        // 连接到数据库
        mysqlx::Session session("localhost", 33060, "root", "password");
        mysqlx::Schema schema = session.getSchema("test");

        // 假设我们有一个表叫做blobs，包含一个BLOB字段
        mysqlx::Table table = schema.getTable("blobs");

        // 读取BLOB数据
        mysqlx::RowResult result = table.select("blob_data").execute();
        mysqlx::Row row = result.fetchOne();

        if (row) {
            mysqlx::Value blobValue = row[0];
            std::string blobData = blobValue.get<std::string>();

            // 将BLOB数据写入文件
            std::ofstream file("output.bin", std::ios::binary);
            file.write(blobData.c_str(), blobData.size());
            file.close();

            std::cout << "BLOB data written to output.bin" << std::endl;
        }

        // 写入BLOB数据
        std::ifstream inputFile("input.bin", std::ios::binary | std::ios::ate);
        std::streamsize size = inputFile.tellg();
        inputFile.seekg(0, std::ios::beg);

        std::vector<char> buffer(size);
        if (inputFile.read(buffer.data(), size)) {
            mysqlx::RowResult insertResult = table.insert("blob_data")
                .values(mysqlx::Value(std::string(buffer.begin(), buffer.end())))
                .execute();

            std::cout << "BLOB data inserted into database" << std::endl;
        }

        inputFile.close();
    } catch (const mysqlx::Error &err) {
        std::cout << "Error: " << err << std::endl;
    }

    return 0;
}