FormattedDataSet API / News: Recent posts

The FormattedDataSet live demo that has been available for several years at www.fdsapi.com is being removed due to rising hosting costs.

The ArrayConverter class has been added. This class is great for formatting arrays for display in a web browser. For example it can make numbers comma delimeted or format dates in a locale specific manner. However, ArrayConverter is more general than that and really can covert any cell of an array into any Object. See the javadocs at http://www.fdsapi.com for examples.

ArraySQL allows a java developer to query 2 dimensional Object arrays (Object[][]) in a SQL-like manner. Improvements have been made in syntax error checking and a few bug fixes have been made. ArraySQL is easy to use. Sample syntax follows:

select rowNum(), 'String Constant', * from array where (col0='william' and col1='reid') or (col0='jeff' and col1='beck') order by col1 desc, col0 asc

The ArraySQL was added to the FormattedDataSet API.
ArraySQL allows SQL like synax to be applied to Arrays.
This class can be used with the FormattedDataSet or as a standalone utility class.
The API also has the ability to convert ResultSet's into 2 dimensional Arrays.
This allows you to query ResultSets as the following example shows.
See the javadocs at http://www.fdsapi.com for more examples.... read more

The FormattedDataSet has added a utility class for Java 2 dim arrays (Obejct[][]) that allow a developer to query arrays. The class does for arrays what a SQL 'select' statement does for database tables. The API allows a developer to filter by columns and rows. Filtering columns is similar to the list of columns in a select statement and filtering rows is similar to a 'select' statements 'where clause' (i.e column and row filters used together are like the following: 'select col1,col2, col5 from array where col1="jones"and col2>20000'.)

All FormattedDataSet API Code has been made more easily viewable by simply typing in the java class name in the following format. Due to browser compatibility issues the code is also viewable by appending .txt to the class instead of .java.

http://www.fdsapi.com/javadocs/com/fdsapi/FormattedDataSet.txt

http://www.fdsapi.com/javadocs/com/fdsapi/FormattedDataSet.java

More documentation has been included on the FormattedDataSet Home Page (http://www.fdsapi.com). The documentation includes the FormatteDataSet Users Manual, and two HTML PowerPoint presentations. All are available via the related links section at the top of the home page. This documentation was previously only available via download.

JAMon API - An easy, fast, flexible Java performance tuning and scalability measuring API has just been moved to SourceForge. The FormattedDataSet uses JAMon to measure many things including all calls to the FormattedDataSet class and all JDBC calls. Because JAMon is required to use the FormattedDataSet you can use JAMon to monitor other aspects of your application too.

Check it out at http://www.jamonapi.com or off of the link at http://www.jamonapi.com. To see the types of statisitics that JAMon gathers in FDS (FormattedDataSet) go to http://www.fdsapi.com and select 'Live Demo' and then 'JAMon Stats'.

The FormattedDataSet API is possibly the easiest way to generate dynamic text including HTML, XML, WML, JavaScript....

An online demo application is now available at http://www.fdsapi.com. The application allows developers to more clearly see the FormattedDataSet in action by entering SQL and having the results come back as an html table that is sortable by clicking on the column headers.

A servlet filter has also been added to the application that tracks performance and hit counts for web resource files such as JSPs, HTML, GIFs, and JPGs.... read more

The FormattedDataSet Java API has been released. The FormattedDataSet API is the easiest way to generate dynamic text (HTML, XML, WML, JavaScript...).

It has been released under a BSD license and source code, binaries, and documentation are all available. The FormattedDataSet combines data and formatting to generate the dynamic text. Templates contain formatting.

Out of the box the FormattedDataSet can generate all common HTML elements (table, list box, drop down list box, multi-select list box), and XML. Developers can easily create their own templates too. Here is some sample JSP code that uses the same query to generate XML and an HTML table:... read more