display an image stored in the database with Java

Question

I have a problem when I want to display an image stored in the database with OLE using JAVA.

Answer 1

If your image data is stored in your database as some blob, you would probably want to use an ImageIcon and construct it using the byte[] imageData constructor:

ImageIcon(byte[] imageData)

Creates an ImageIcon from an array of bytes which were read from an image file containing a supported image format, such as GIF, JPEG, or (as of 1.3) PNG.

Answer 2

Trying to do a good guess, I would say you have to read it from the database using a blob, something like:

PreparedStatement pstmt = connection.prepareStatement("SELECT imageblob FROM YOUR_TABLE where id = ?");
pstmt.setInt( 1, imageId );
ResultSet rs = pstmt.executeQuery();
byte[]data = null;
while( rs.next() ) {
    data = rs.getBlob(1).getBytes();
}

And then displaying it with a servlet by writing the data to the output stream.

....

response.setContentType("image/jpg");
response.getOutputStream().write(data,0,data.length );
response.getOutputStream().flush();        

But this is just a guess, because your question lack of essential information.

Here's are some links related to Blob and Servlets

http://www.java2s.com/Code/Java/Database-SQL-JDBC/BlobJDBCdealswithBinaryData.htm

http://java.sun.com/j2se/1.5.0/docs/guide/jdbc/blob.html

http://www.roseindia.net/servlets/retreiveimage.shtml

I hope this helps