eriezelagera

Convert blob object to BufferedImage

Jan 23rd, 2014
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.73 KB | None | 0 0
  1. /** Read image from the database for the given ID, then convert to BufferedImage */
  2. public BufferedImage readImage(String id) {
  3.     BufferedImage bufImg = null;
  4.        
  5.     try {
  6.         PreparedStatement pst = conn.prepareStatement("SELECT photo FROM vehicles WHERE veh_reg_no = ?");
  7.             pst.setString(1, id);
  8.             System.out.println(pst);
  9.             ResultSet rset = pstmt.executeQuery();
  10.            
  11.         // Only one result expected
  12.             rset.next();
  13.             // Read image via InputStream
  14.             InputStream in = rset.getBinaryStream("photo");
  15.             // Decode the inputstream as BufferedImage
  16.             bufImg = ImageIO.read(in);
  17.       } catch(Exception e) {
  18.          e.printStackTrace();
  19.       }
  20.       return bufImg;
  21. }
Advertisement
Add Comment
Please, Sign In to add comment