Upload Media

What's happening? This example interacts with a simple database schema, set up by default in the sample "personnel" hsql database installed with the database block. There is one table "media" with two fields: a primary key, and a binary field "image". When a file upload is received from the simple form on this page, the modular db action auto increments the primary key, and loads the binary file contents into the column (declared as type="binary" in database.xml). That's it.

Additionally, when this page is loaded, esql queries the media table and places an image tag for each row, using "primarykeyvalue".jpg for the src. The sitemap is configured to serve *.jpg using the database reader (declared in the root database samples sitemap) which simply retrieves the binary data from the database and streams it to the browser.

For this sample uploads need to be enabled in web.xml. This happens by default via the property config.enable-uploads in build.properties.

File (must be an image)

Request Attributes

{ Enumeration e=request.getAttributeNames(); while ( e.hasMoreElements() ) { String attribute = (String) e.nextElement(); Object value = request.getAttribute(attribute); } }

attribute ="value"

Request Parameters

{ Enumeration e=request.getParameterNames(); while ( e.hasMoreElements() ) { String attribute = (String) e.nextElement(); Object[] value = request.getParameterValues(attribute); for (int i=0; i < value.length; i++) { } } }

attribute[i] ="value[i]"