How to display all images in jsp from database?

[prasath03]

Hi Experts,

Please Help me its very urgent.....

I stored number of images and related informations are in MS-SQL
database, datatype is "image". I want to display all the images and
related information on the jsp page.

I tried the following code, but it doesn't work properly because it
showed only one image from the database and doesn't show the price value.

ResultSet rs=st.executeQuery("select * from image_table");
while(rs.next())
{
byte barray[] = rs.getBytes(4);
String get_price=rs.getString(5);
response.setContentType("image/gif");
response.getOutputStream().write(barray);
out.println("Price in Rs. "+get_price);
}
response.getOutputStream().flush();
response.getOutputStream().close();

How can I display the all images and related information in jsp?
If anybody know the solution kindly send me the coding or suggestion
to my mail-id(<removed>).

Thanks in Advance......



V. Prasath @ Arjunan.

[sumittyagi]

Hi Experts,

Please Help me its very urgent.....

I stored number of images and related informations are in MS-SQL
database, datatype is "image". I want to display all the images and
related information on the jsp page.

I tried the following code, but it doesn't work properly because it
showed only one image from the database and doesn't show the price value.

ResultSet rs=st.executeQuery("select * from image_table");
while(rs.next())
{
byte barray[] = rs.getBytes(4);
String get_price=rs.getString(5);
response.setContentType("image/gif");
response.getOutputStream().write(barray);
out.println("Price in Rs. "+get_price);
}
response.getOutputStream().flush();
response.getOutputStream().close();

How can I display the all images and related information in jsp?
If anybody know the solution kindly send me the coding or suggestion
to my mail-id(<removed>).

Thanks in Advance......



V. Prasath @ Arjunan.

Hi prasath03!
Welcome to TSDN,

You have two points wrong in your code.
1. You can't send more than 1 image at a time.
2. You have to set content length in the response.

So the ideal way is to have the src of your image pointing to your image processing servlet. and send any unique id of the image with that, (as a primary key of the image.

eg:
<img src="abcServlet?imgId=124" name="xyz">

and at servlet you will do:

ResultSet rs=st.executeQuery("select * from image_table where img_id=" + request.getParameter('imgId'));
if(rs.next())
{
byte barray[] = rs.getBytes(4);
String get_price=rs.getString(5);
response.setContentType("image/gif");
response.setContentLength(barray.length);
response.getOutputStream().write(barray);
out.println("Price in Rs. "+get_price);
}
response.getOutputStream().flush();
response.getOutputStream().close();
 

[dmjpro]

You have two points wrong in your code.
1. You can't send more than 1 image at a time.
2. You have to set content length in the response.

sumittyagi,Please explain me these two lines in details.

Kind regards,
Dmjpro.

[prasath03]

Hi prasath03!
Welcome to TSDN,

You have two points wrong in your code.
1. You can't send more than 1 image at a time.
2. You have to set content length in the response.

So the ideal way is to have the src of your image pointing to your image processing servlet. and send any unique id of the image with that, (as a primary key of the image.

eg:
<img src="abcServlet?imgId=124" name="xyz">

and at servlet you will do:

ResultSet rs=st.executeQuery("select * from image_table where img_id=" + request.getParameter('imgId'));
if(rs.next())
{
byte barray[] = rs.getBytes(4);
String get_price=rs.getString(5);
response.setContentType("image/gif");
response.setContentLength(barray.length);
response.getOutputStream().write(barray);
out.println("Price in Rs. "+get_price);
}
response.getOutputStream().flush();
response.getOutputStream().close();
 

Hi sumittyagi,

Thanks for ur reply..........

I inserted the image without id_no(primary key). Don't neglect my sql query. I need to display all images and related information without id_no. Is there any way to display the images and related information without id_no in same query? Kindly suggest me.

V. Prasath @ Arjunan.

[sumittyagi]

Hi sumittyagi,

Thanks for ur reply..........

I inserted the image without id_no(primary key). Don't neglect my sql query. I need to display all images and related information without id_no. Is there any way to display the images and related information without id_no in same query? Kindly suggest me.

V. Prasath @ Arjunan.

Although there is no logic in storing images in database without any ids, even then if you want to show your images, then simply store all the image arrays in an arraylist and store that arraylist in session. also store a counter in session so that u can track how many images have been already displayed.

But don't forget to remove those images from database after all images have been displayed.

But I am again suggesting u, its not a good coding style.

[prasath03]

Although there is no logic in storing images in database without any ids, even then if you want to show your images, then simply store all the image arrays in an arraylist and store that arraylist in session. also store a counter in session so that u can track how many images have been already displayed.

But don't forget to remove those images from database after all images have been displayed.

But I am again suggesting u, its not a good coding style.

Again thanks for ur reply,

I am new in jsp. You said store the images in arraylist, but i haven't store the arraylist in session. Although i have already tried store the images in arrarylist and related information. If i want to display all the contents it displays all the contents. But only images displays like ([B@1c8f91e). Is there any way to print orginal image?
Herewith i attached my source code...

List list = new ArrayList();
while(rs.next())
{
list.add(rs.getString(1));
String file_extension=rs.getString(3);
barray = rs.getBytes(4);
list.add(file_extension);
fileoutputstream = new FileOutputStream(file_extension);

for (int i = 0; i < barray.length; i++) {

list.add(barray);
} }

}

The following output is when i executed..

32.jpg
[B@1fb2ef9
111
43.jpg
[B@1c8f91e
111
images.jpg


Regards,

V. Prasath @ Arjunan.

[pavi6285]

i want to store an image in my database ACCESS.
i stored it as OLE/OBJECT.
i want to retriewve it through JSP.
if i retrieve it didnt display that image . it shows some undefined format as S@{ghdk
i dont know correctly sir...
how to set image in access and how to retrieve it from DB through jsp ..
pls help me very urgent...
give some examples...... to my mailID

[pavi6285]

i want to store an image in my database ACCESS.
i stored it as OLE/OBJECT.
i want to retriewve it through JSP.
if i retrieve it didnt display that image . it shows some undefined format as [B@1c8f91e).
i dont know correctly sir...
how to set image in access and how to retrieve it from DB through jsp ..
pls help me very urgent...
give some examples...... to my mailID

[sumittyagi]

Again thanks for ur reply,

I am new in jsp. You said store the images in arraylist, but i haven't store the arraylist in session. Although i have already tried store the images in arrarylist and related information. If i want to display all the contents it displays all the contents. But only images displays like ([B@1c8f91e). Is there any way to print orginal image?
Herewith i attached my source code...

List list = new ArrayList();
while(rs.next())
{
list.add(rs.getString(1));
String file_extension=rs.getString(3);
barray = rs.getBytes(4);
list.add(file_extension);
fileoutputstream = new FileOutputStream(file_extension);

for (int i = 0; i < barray.length; i++) {

list.add(barray);
} }

}

The following output is when i executed..

32.jpg
[B@1fb2ef9
111
43.jpg
[B@1c8f91e
111
images.jpg


Regards,

V. Prasath @ Arjunan.

I just forgot to tell you that images takes their own request, and each image display needs to be treated as separate request.

See this thread for a discussion on the same topic.