Java从PostgreSQL读取字节数组并写入镜像文件

import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ImageWriter {
    public static void main(String[] args) {
        String url = "jdbc:postgresql://localhost:5432/mydatabase";
        String username = "myusername";
        String password = "mypassword";
        String query = "SELECT image_data FROM images WHERE image_id = ?";

        try (Connection conn = DriverManager.getConnection(url, username, password);
             PreparedStatement stmt = conn.prepareStatement(query)) {
            // 设置需要查询的image_id
            stmt.setInt(1, 1);

            try (ResultSet rs = stmt.executeQuery()) {
                if (rs.next()) {
                    // 读取字节数组
                    InputStream inputStream = rs.getBinaryStream("image_data");
                    byte[] buffer = new byte[1024];
                    int bytesRead;
                    
                    // 创建镜像文件
                    FileOutputStream outputStream = new FileOutputStream("image.jpg");

                    // 写入字节数组到镜像文件
                    while ((bytesRead = inputStream.read(buffer)) != -1) {
                        outputStream.write(buffer, 0, bytesRead);
                    }

                    // 关闭输入流和输出流
                    inputStream.close();
                    outputStream.close();
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}