This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
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
Author

Show Image from MySQL on JSP

shally kumar
Greenhorn

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.

Thanks
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

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
Greenhorn

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.
 
GeeCON Prague 2014
 
subject: Show Image from MySQL on JSP