Massimo Casella writes:
> I have an image stored in a field of my database. I must show this image
in
> a html page on Apache server.
> Can I show the images without write before the file in the server
> filesistem?
Sure -- you can write a servlet which retrieves the image from the database
and streams the image directly from the database back to the client,
something
like this:
ResultSet rs = stmt.executeQuery("select image from images where blah
blah");
if (rs.next()) {
response.setContentType("image/gif");
InputStream is = rs.getBinaryStream(1);
OutputStream os = response.getOutputStream();
byte[] buf = new byte[4096];
int cnt;
while ((cnt = is.read(buf)) > 0) os.write(buf, 0, cnt);
}
Of course, you probably also want to handle Content-Length, not found,
exceptions, etc.
(The latest release of the Quadcap Embeddable Database, 1.0b14, contains
a sample application, including source code, for an image database, which
includes an ImageServlet that does the above, as well as a JSP-based
user interface to the image database. You can download it from the Quadcap
website at http://www.quadcap.com/home.html)
Stan Bailes
Quadcap Software
http://www.quadcap.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
