This week's book giveaway is in the JDBC and Relational Databases forum.
We're giving away four copies of Murach's MySQL and have Joel Murach on-line!
See this thread for details.
Win a copy of Murach's MySQL this week in the JDBC and Relational Databases forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Displaying images dynamically from database

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:D
 
author & internet detective
Posts: 41849
904
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!:)
 
Ranch Hand
Posts: 152
Eclipse IDE Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Hey great thanks to you guys. I'll try it asap:)


Thanks:D
 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Eclipse IDE Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:D
 
Loh Peggie
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:D
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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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:D
1.jpg
[Thumbnail for 1.jpg]
Product Image with description
 
Sheriff
Posts: 67745
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
There only needs to be one topic discussing this.
 
God is a comedian playing for an audience that is afraid to laugh - Voltair. tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
    Bookmark Topic Watch Topic
  • New Topic