Using JDBC with Lazy Query Container and FilteringTable

    Populating display tables from a database is a deceptively complicated operation, especially when mixing multiple techniques together. This page provides an example of one way to efficiently load data from a SQL database table into a filterable UI, using the Lazy Query Container and FilteringTable add-ons.

    Note: Do not use the SQLContainer package. This is buggy and will have your database and garbage collector crunching in loops.

    and implementation

    Java

    Using the Query with FilteringTable

    Now that we have our Query, we need to create a table to hold it. Here’s one of many ways to do it with FilteringTable.

    Put them together on the UI

    Now we have our Container that reads from the database, and a Table for displaying them, lets put the final pieces together somewhere in some UI code:

    Java

    Java