Retrieving Images from a Database

// SAVE to file (same as files topic!)
PreparedStatement ps = con.prepareStatement("SELECT img FROM photos WHERE id=?");
ps.setInt(1, 1);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
    try (InputStream in = rs.getBinaryStream("img");
         FileOutputStream out = new FileOutputStream("out.jpg")) {
        byte[] buf = new byte[4096]; int n;
        while ((n = in.read(buf)) != -1) out.write(buf, 0, n);
    }
    // DISPLAY in Swing (bonus!)
    BufferedImage img = ImageIO.read(new File("out.jpg"));
    JFrame f = new JFrame("photo");
    f.add(new JLabel(new ImageIcon(img)));
    f.setSize(400, 300);
    f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    f.setVisible(true);
}