12.5. Example GUI Application: Database Query Viewer
In this section, we write an application with a graphical user interface that retrieves a result set from a database and displays the data in a resizable table. Users of <cfgrid> will find this application somewhat familiar. While this simple example does not allow the user to edit the cells of the query result set from within the grid, or re-sort the data by doubleclicking the column name headings, such functionality could be added with existing classes in the API.
Note
This example can be used with drivers other than Type I drivers. In order to use a query result set in this way with a Type I driver (such as the JDBC:ODBC bridge), you must manually cache the result set to scroll through the ...
Get Java™ for ColdFusion® Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
