Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Java
Expertise: Advanced
Nov 3, 2004

Read an Image from a Database and Show it in a Browser

This script reads the image from the databse and uses JDBC and stream to write it into a browser.

//import the required files
import ...
//class declaration
public class ... extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response)
                               throws ServletException, IOException {
 
  Connection conn = null;
  byte[] buffer = new byte[4 * 1024];  
  int len;  
  try {
      //database connectivity
      DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
      conn = DriverManager.getConnection("jdbc:oracle:thin:@url:1521:omm","uname","pwd"); 
	
      response.setContentType("image/gif");
      //getting stream
      ServletOutputStream out = response.getOutputStream();
      //executing query
      Statement stmt = conn.createStatement();
      //note IMAGE field may be CLOB/BLOB in the database
      ResultSet rs = stmt.executeQuery("SELECT IMAGE FROM table_image WHERE IMAGE_ID = 101") ;
      if (rs.next()) { //reading &writting using stream 
        BufferedInputStream bis = new BufferedInputStream(rs.getBinaryStream("IMAGE"));
        while ((len = bis.read(buffer, 0, buffer.length)) != -1) {
          out.write(buffer, 0, len);
        }
      } 
    }
    catch ( Exception e ) {//exception handling
    }
  
}
}
David Elayaraja
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap