display multiple images from database on a webpage.

[G. Ritardo]

Single image

Code

GeSHi (java):
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();
Created by GeSHI 1.0.7.20

Multiple images

Code

GeSHi (java):
rs1 = st1.executeQuery("select image from pictures where id in(5,6,7)");
      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();
Created by GeSHI 1.0.7.20

[ashish]

see the link below here 


http://www.javaforums.net...asql-t3320.0.html;new#new.
regards,
phe9oxis,
http://www.guidebuddha.com