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
2
-
have u try something or search on google ?Kick– Kick2014-03-03 05:54:42 +00:00Commented Mar 3, 2014 at 5:54
-
if you want the jsp code or db code.jmail– jmail2014-03-03 05:55:44 +00:00Commented Mar 3, 2014 at 5:55
Add a comment
|
1 Answer
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.
4 Comments
liron
Thanks,The retrieve from db is clear , How I display it in Jsp ?
jmail
if you want to display the image in web page.
liron
Yes.I want to display it in web page
jmail
@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, bytes.com/topic/java/answers/….