如何将MySQL Blob字段转换为insert语句的字符串

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class BlobToStringExample {
    public static void main(String[] args) {
        String jdbcUrl = "jdbc:mysql://localhost:3306/database_name";
        String username = "username";
        String password = "password";
        String tableName = "table_name";
        String blobColumnName = "blob_column_name";

        try {
            // 创建数据库连接
            Connection connection = DriverManager.getConnection(jdbcUrl, username, password);
            
            // 创建SQL语句
            String sql = "SELECT " + blobColumnName + " FROM " + tableName;
            
            // 创建SQL语句执行器
            Statement statement = connection.createStatement();
            
            // 执行SQL查询
            ResultSet resultSet = statement.executeQuery(sql);
            
            // 获取Blob字段的值
            if (resultSet.next()) {
                byte[] blobBytes = resultSet.getBytes(blobColumnName);
                
                // 将字节数组转换为十六进制字符串
                StringBuilder hexString = new StringBuilder();
                for (byte b : blobBytes) {
                    hexString.append(String.format("%02X", b));
                }
                
                // 构建insert语句
                String insertSql = "INSERT INTO " + tableName + " (" + blobColumnName + ") VALUES ('" + hexString + "');";
                System.out.println(insertSql);
            }
            
            // 关闭资源
            resultSet.close();
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}