display images from database instead of the pathway:(

Peggie1990 · July 7th, 2009, 09:33 PM

Hey guys do you know how to display blob images from mysql query browser instead of retrieving the path? I heard from my friend that it has something related to url:)

Code:

 
Product Name: Green Beanie 
Product Color: Green 
Product Description: It is natural green that makes you eyesight better and is eco-friendly 
Product Price: $22.00 
Quantity: 1 
Image: com.mysql.jdbc.Blob@b40ec4(the path whereby I want image instead of this:))

Thanks:D

iamrakesh22 · July 8th, 2009, 09:46 AM

Basically what you need to do is
1. Write a servlet [or similar component] which takes id of the image [id column for the row] and reads the blob value.
2. Set appropriate mime type for the response object [image mime type].
3. Write the byte stream to the response object

On the jsp you have write <img ../> tag, and give the servlet path as 'src' attribute, with image id as request parameter [example src="myservlet?image=1234" ].

Hope it works :-)

In fact you'll find many post in this forum related to this topic, try searching for them :-)

Peggie1990 · July 8th, 2009, 10:11 AM

Thanks for ur help:)