retrieve image from my sql database using jsp

PreparedStatement pst = null;

ResultSet rs=null;

pst = conn.prepareStatement("select image from imagedetails where imageid='"+imageid+"'");

rs=pst.executeQuery();

while(rs.next())

{

byte[] b=rs.getBytes("image");

FileOutputStream fos=new FileOutputStream("c://image.jpg");

fos.write(b);

}

hi this the code to retrieve the image from DB and write to a file.

kamal_shana at 2007-7-12 0:58:08 >