devxlogo

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

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 filesimport ...//class declarationpublic 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    }  }}
See also  Why ChatGPT Is So Important Today
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist