How to display multiple images from database using JSP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • selvasoft
    New Member
    • Mar 2010
    • 34

    #1

    How to display multiple images from database using JSP

    Hi
    Please help me any one. I want solution for display multiple images from oracle database.Using JSP.
    here is my code for display one image from database.
    Please Any one give me some ideas.

    Code:
    <%@ page import ="java.sql.*,java.util.*,java.awt.*,java.io.*" %>
    
    
    <%
          String DomainName ="jdbc:oracle:thin: ";
          String UserName=" ";
          String PassWord=" ";
               byte[] image = new byte[300000];
               try
               {
                      
                      int n=0;
                      n =System.in.available();
                      image = new byte[n];
                     Image pic =null;
                      Blob blob =null;
    
                      String QS =" Select simage  from image Where IMGID=1";
    
                       Class.forName("oracle.jdbc.OracleDriver");
                       Connection cn=DriverManager.getConnection(DomainName,UserName,PassWord);  
                       Statement  st=cn.createStatement();
                       ResultSet  rs= st.executeQuery(QS);
         OutputStream o=null;
                       while(rs.next())
                       {
                         image  =rs.getBytes(1);                    
    
    
        response.setContentType("image/gif");
        o =response.getOutputStream();
        o.write(image);
        o.flush();
     
                       }
    
    
        o.close();
        out.close();
                       
    
                 }
               catch(Exception e)
               {
                   System.out.println(e);
               }
    
    %>
Working...