<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>

<%       Blob image = null;
        Connection con = null;
        byte[] imgData = null ;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/abc","root","123");
            stmt = con.createStatement();
            rs = stmt.executeQuery("select * from image");
            if (rs.next()) {
                image = rs.getBlob(2);
                imgData = image.getBytes(1,(int)image.length());
            } else {
                out.println("Display Blob Example");
                out.println("image not found for given id>");
                return;
            }

            // display the image
         response.setContentType("image/png");
         OutputStream o = response.getOutputStream();
         o.write(imgData);
         o.flush();
         o.close();
        } catch (Exception e) {
            out.println("Unable To Display image");
            out.println("Image Display Error=" + e.getMessage());
            return;
        } finally {
            try {
                rs.close();
                stmt.close();
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    %>