Two Laptop Bag*
The moose likes JSP and the fly likes Displaying images dynamically from database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Reply locked New topic
Author

Displaying images dynamically from database

Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51
Hey guys do you know whether is there any samples of displaying 100 images dynamically from database(Sql query browser) on the jsp path.
My data type for image is called 'varchar'.


In here I had declare a folder in my web content called images and there is a sub folder called Beanie with all the image im it like 1120.jpg..... and in my database i enter the record for image is called 1120.jpg. So that the string can be get

Thanks
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30780
    
157

Loh,
Welcome to JavaRanch!

It's good practice to keep the JDBC code out of the JSP. So you would write the JDBC code to get a list of image names and stick them in a request attribute. Then the JSP would loop through that attribute list and display them.

Are you having trouble with a specific part of the code you posted?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51
Icic. Thanks for welcoming me

Oh ya but i did put the jdbc above the jsp as for the looping is it it indicate at the jsp paga or?

My code is for the project page i am doing is:


Thanks Hope to receive your reply soon!
Pravin Shirke
Ranch Hand

Joined: Apr 05, 2008
Posts: 150

hi loh,
what you can do is just put a while loop inside your for loop and iterate over the result set.
your code slightly modified ADDED while loop
eg.


[Vipassana] - It is seeing the reality as it is, And not as you want it to be.!!!
SCJP1.5.
Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51
Hey great thanks to you guys. I'll try it asap


Thanks
Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51



Hey is it we have to add something like <% around here cause it seems to be in error.
Thanks
Pravin Shirke
Ranch Hand

Joined: Apr 05, 2008
Posts: 150

hey loh,
Oops sorry for the inconvience, actually i copied the code of yours and pasted i guess it did not paste properly you should write the img tag for that
e.g:

i guess this should solve the problem..
hope it works
bye
Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51
Hey hey I try the codes that you gave me but it ends up no record.

Hope to receive your reply soon
Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51
Hey sorry I have decided to stick to the String Instead of blob. Sorry.

Oh ya I had made a mistake, i had change to a page whereby all the images is display out at one time. When I click on a certain picture it will hyperlink to the description of that certain product .Example: when click on the Yellow beanie it will go to the specific description of the product and when click on pink beanie if will go to the specific description of the pink beanie

However I could not hyperlink it.

What happen?


Thanks



[Thumbnail for image.jpg]

Loh Peggie
Ranch Hand

Joined: Jul 09, 2009
Posts: 51
Hey guys do you have any example to display blob images store in database(my sql server) and dispaly it on jsp whereby they call the images from the servlets and display it on jsp four by four in a row?

And the image can also be display with its details like the prod color, prod name, prod price,etc.

My database is called : save_image

My attributes are:

id(int)
prodname(varchar)----name of image
prodcolor
prodImage(blob)

Thank you



[Thumbnail for 1.jpg]

Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61437
    
  67

There only needs to be one topic discussing this.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Displaying images dynamically from database