How to load Image using iBatis?

[Simpson Kumar]

In our application we have to display multiple images on a JSP, and these images are already stored in SQL Server Database.

I can read that Image by JDBC code very simple. Here is the Template

ResultSet rs =stmt.executeQuery("select image from Q1A1 where q1Id=2");
               InputStream readImg = null;
if(rs.next())  
    readImg = rs.getBinaryStream(1);        
BufferedInputStream in  = new BufferedInputStream(readImg);
response.setContentType("image/jpg");
response.setHeader("Content-Disposition",  " inline; filename=" );
 
ServletOutputStream out = response.getOutputStream();
byte[] buffer = new byte[4 * 1024];
int data;
while((data = in.read(buffer)) != -1)
{
out.write(buffer, 0, data);
}
out.flush();
 
               }
 
    

From ResultSet object we can read InputStream object and by using this we can write image on JSP.

My question is there any possibilities to get the InputStream object as Image?

[Ulf Dittmer]

The javax.imageio.ImageIO.read method can transform an InputStream into a BufferedImage (which is a more useful subclass of Image), provided that the image is a GIF, BMP, JPEG or PNG.

[Simpson Kumar]

Thank you Ulf for quick reply..

Can we retrieve that object from through iBATIS?

Say for example, I have an object called ImageVO and it contains InputStream (private InputStream imageStream as instance variable and from iBATIS query

   (select image as imageStream, image_id as imageStreamId from IMAGE where image_id = #imageStreamId#)
 
 

can we retrieve InputStream object?