如何从MySQL获取BLOB图像

import java.sql.*;

public class RetrieveBlobImageFromMySQL {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, username, password)) {
            String sql = "SELECT image_data FROM images WHERE image_id = ?";
            int imageId = 1;

            try (PreparedStatement stmt = conn.prepareStatement(sql)) {
                stmt.setInt(1, imageId);

                try (ResultSet rs = stmt.executeQuery()) {
                    if (rs.next()) {
                        Blob blob = rs.getBlob("image_data");
                        byte[] imageData = blob.getBytes(1, (int) blob.length());

                        // 处理BLOB图像数据，例如保存为文件或进行进一步处理
                        // ...

                        System.out.println("BLOB图像获取成功！");
                    } else {
                        System.out.println("未找到指定的图像数据！");
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}