-2

I save images in db as blobs and I want to retrieve an image and display it in browser in jsp file. How I implement it in Java ? Thanks

liron
  • 1
  • 1

1 Answers1

0

try this method and solve your doubts.

    Connection connection = DriverManager.getConnection(url, username, password);
    Statement stmt = connection.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT col_blob FROM mysql_all_table");

    if (rs.next()) {
      Blob blob = rs.getBlob("col_blob");
      long blobLength = blob.length();

      int pos = 1; // position is 1-based
      int len = 10;
      byte[] bytes = blob.getBytes(pos, len);

      InputStream is = blob.getBinaryStream();
      int b = is.read();

another example tojust goto this link

listen to me, if you had any doubt you should must give me comments.

jmail
  • 5,944
  • 3
  • 21
  • 35
  • Thanks,The retrieve from db is clear , How I display it in Jsp ? – liron Mar 03 '14 at 06:23
  • if you want to display the image in web page. – jmail Mar 03 '14 at 06:25
  • Yes.I want to display it in web page – liron Mar 03 '14 at 06:26
  • @liron, stack flow is not allow to ask the same post in different type of question, because this post will be going to see the future users(doubt). so, that only I've not posting the answer. but, this first and last to answer your question, because your new user that only, just goto this site and display the image, **http://bytes.com/topic/java/answers/884256-how-display-more-image-database-using-jsp**. – jmail Mar 03 '14 at 07:29