Java

Java RSS

Need to display multiple images from database on a webpage.

•

Join Date: May 2009

Posts: 2

Reputation: raghuprasad is an unknown quantity at this point

Solved Threads: 0

raghuprasad raghuprasad is offline

Offline

Newbie Poster

Need to display multiple images from database on a webpage.

May 11th, 2009

hi,

I am able to display a single image from the database on a webpage using the

following code:

rs1 = st1.executeQuery("select image from pictures where id='5'");
if(rs1.next()){
int len = imgLen.length();
byte [] rb = new byte[len];
InputStream readImg = rs1.getBinaryStream(1);
int index=readImg.read(rb, 0, len);
System.out.println("index"+index);
st1.close();
response.reset();
response.setContentType("image/jpg");
response.getOutputStream().write(rb,0,len);
response.getOutputStream().flush();

Can any one help me to get the code to display more than one image on a *.jsp

file. I tried putting the while loop, but it is'nt doing the job.

Thanks.

•

Join Date: Oct 2008

Posts: 2,605

Reputation: adatapost has much to be proud of

Solved Threads: 460

adatapost

Offline

Posting Maven

Re: Need to display multiple images from database on a webpage.

May 11th, 2009

•

Originally Posted by raghuprasad

hi,

I am able to display a single image from the database on a webpage using the

following code:

rs1 = st1.executeQuery("select image from pictures where id='5'");
if(rs1.next()){
int len = imgLen.length();
byte [] rb = new byte[len];
InputStream readImg = rs1.getBinaryStream(1);
int index=readImg.read(rb, 0, len);
System.out.println("index"+index);
st1.close();
response.reset();
response.setContentType("image/jpg");
response.getOutputStream().write(rb,0,len);
response.getOutputStream().flush();

Can any one help me to get the code to display more than one image on a *.jsp

file. I tried putting the while loop, but it is'nt doing the job.

Thanks.

You have to save images into temp folder of your site.

 Help with Code Tags 
 Java Syntax (Toggle Plain Text) 
 ...
 int f=1;
 String tempfolder="/tmp/";
 String filename="";
 while(rs1.next()){
        int len = imgLen.length();
        byte [] rb = new byte[len];
        InputStream readImg = rs1.getBinaryStream(1);
        int index=readImg.read(rb, 0, len);  
        filename=tempfolder + "A" + f;
        FileOutputStream os=new FileOutputStream(filename);
        os.write(rb);
        os.close();
        out.println("<img src='" + filename + "' />");
        f++;
 }
 ...
 int f=1;
 String tempfolder="/tmp/";
 String filename="";
 while(rs1.next()){
        int len = imgLen.length();
        byte [] rb = new byte[len];
        InputStream readImg = rs1.getBinaryStream(1);
        int index=readImg.read(rb, 0, len);  
        filename=tempfolder + "A" + f;
        FileOutputStream os=new FileOutputStream(filename);
        os.write(rb);
        os.close();
        out.println("<img src='" + filename + "' />");
        f++;
 }