displaying images from database(mysqlquerybrowser) in jsp:)

Peggie1990 · June 27th, 2009, 02:11 AM

Hello I am Peggie.
Well, I am a newbie in using jsp. I hope that maybe you guys can provide some samples of displaying images from database(mysqlquerybrowser) in jsp page. I also make use of package to call out the connection.

My database in mysql query browser is called: image

And the attribute is
prodID (INT)
ProdImage(blob)

Thanks:)
Hope to receive reply from you guys soon!

June 29th, 2009, 12:01 AM

Just google,
you will get many samples. Similar posts are already in this forum.

i think you already know how to connect with mysql
otherwise look,
http://www.roseindia.net/jdbc/jdbc-m...lConnect.shtml

some links for image display,
http://www.theserverside.com/discuss...thread_id=5444
http://fdegrelle.over-blog.com/article-992927-6.html

Peggie1990 · June 29th, 2009, 04:27 AM

Thanks:)
Oh ya when i try to declare blob at the java page, the 'blob' data type is in error.
Do you guys know how to resolve this?
Thanks:)

June 29th, 2009, 05:36 AM

Quote:

Originally Posted by Peggie1990

declare blob at the java page

how you are doing this?
Post the code too..

Peggie1990 · June 29th, 2009, 05:39 AM

Okay:)

Code:

 
package sg.nyp.edu.sit.model;

public class Image {
int imageID;
Blob image;
public int getImageID() {
return imageID;
}
public void setImageID(int imageID) {
this.imageID = imageID;
}
public Blob getImage() {
return image;
}
public void setImage(Blob image) {
this.image = image;

Code:

Thankshttp://p2p.wrox.com/images/icons/icon10.gif

June 29th, 2009, 06:33 AM

I don't used java.sql.Blob.
My suggestion is to use a byte array for storing binary data like image.

java.sql.Blob provides methods for conversion.
see
http://db.apache.org/derby/docs/10.0...e/sqlj208.html

Peggie1990 · June 29th, 2009, 06:47 AM

Thanks:)

I'll try it:)