Convert Database ResultSet into a Table

---

The next step is to convert the query ResultSet into a table so that the results can be easily sent to the web browser:

1. Drag a Table Module from the JDBC tab of the Simplicity Enterprise Module Palette to the Modules portion of the Enterprise Composer tree. Drop it just after the SQLStatement Node, but before the XMLExport node.

This adds a ResultTable Module that can convert the fairly complex ResultSet data that an SQLStatement produces into a simple table that is easier to work with. A JDBC ResultSet is a fairly complex object that includes all sorts of information about the query itself (known as Meta-Data) as well as the actual data that was requested in the query. Most of the time, all you really want is the actual data in the form of a table, so the ResultTable module makes it easy to get what you really want in a form that is easy to use.

2. Associate the ResultTable Module with the previous SQLStatement Module by clicking on the Properties node of the ResultTable Module and selecting the SQLStatement item in the list that appears on the ResultTable Properties sheet on the right hand side of the Enterprise Composer.