0

I'm developing a Struts application where I want to display images present in MySQL DB in BLOB datatype.

I don't want to store those images to local system but I want to directly display them in a browser. We need to store them in an temp memory. I am able to fetch it and store it into FileOutputStrem and from this object i need to pass an image to JSP.

Below is the code 

ResultSet result = statement.executeQuery();

if (result.next()) {
    Blob blob = result.getBlob("photo");
    InputStream inputStream = blob.getBinaryStream();
    // read the input stream...

}

Please let me know how can I do this.

Roman C
  • 49,761
  • 33
  • 66
  • 176
Suman
  • 1
  • 1

1 Answers1

0

You can use

byte[] content = result.getBytes("photo");
response.setContentType("image/jpg");
response.setContentLength(content.length);
response.getOutputStream().write(content);

Html Code

$(document).ready(function () {
    $("#submit").click(function () {
        $.ajax({
            type: "GET",
            url: "servleturl",
            success: function (result) {
                $("#content").html('<img src="'+result+'" >'); 
            }
        });
    });
});
Mahesh
  • 248
  • 4
  • 19
  • $(document).ready(function () { $("#submit").click(function () { $.ajax({ type: "GET", url: "servleturl", success: function (result) { $("#content").html(''); } }); }); }); – Mahesh Mar 25 '15 at 08:31
  • i want to fetch images from database and add to bean to get into jsp – Suman Mar 25 '15 at 08:41
  • Can you please try private byte[] data; in your bean and set data = result.getBytes("photo"); And add car_image in jsp – Mahesh Mar 25 '15 at 09:25