Bookmark Topic Watch Topic
  • New Topic

Displaying images dynamically from database

 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 34686
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
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?
 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 152
Chrome Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hey great thanks to you guys. I'll try it asap


Thanks
 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator



Hey is it we have to add something like <% around here cause it seems to be in error.
Thanks
 
Pravin Shirke
Ranch Hand
Posts: 152
Chrome Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
image.jpg
[Thumbnail for image.jpg]
Print Screen of the product so that when hyperlink can go to spceific description:)
 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
1.jpg
[Thumbnail for 1.jpg]
Product Image with description
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64990
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
There only needs to be one topic discussing this.
 
    Bookmark Topic Watch Topic
  • New Topic