Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Struts and the fly likes Show Image from MySQL on JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Show Image from MySQL on JSP " Watch "Show Image from MySQL on JSP " New topic

Show Image from MySQL on JSP

shally kumar

Joined: Jul 30, 2008
Posts: 7
Hi All,

I have made a picture search database using struts2 and MySQL. I am able to store pictures in MySQL as BLOB datatype using struts2. Now I want to retrieve(search) those pictures and show them back on JSP. I can retrieve and store picture in byte[] variable in action but, don't understand how to pass it to JSP for display.

Could anyone please guide me what is the best approach for doing this. I don't want to save picture on disk and then display. If it's possible that I can directly retrieve and display, that would be great.

Appreciate your help and time.

Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

You wouldn't pass the byte array to a JSP. That's because a JSP is for producing something (usually HTML) in a text format. Images are not in a text format.

The thing to do with your byte array is to just copy it to the servlet response's output stream. You will also have to set the response's content type to something which matches the image format. For more information read the Ranch's FAQ about that: Image Servlet .
shally kumar

Joined: Jul 30, 2008
Posts: 7
Thanks Paul. That was good link, just I was having some difficulties in implementing it. So, finally I decided to change my strategy and instead of uploading/downloading pictures from MySQL, I changed it to upload/retrieve from file system (root directory) and save the metadata in the database.

Thanks again.
I agree. Here's the link:
subject: Show Image from MySQL on JSP
It's not a secret anymore!