JIDE Data Grids: Bridging the Gap between the Database and JTable

JIDE Software introduces JIDE Data Grids and 2.4.0 release.

JIDE Data Grids  

JIDE Data Grids is a new product built on top of the JIDE Grids to bridge the gap between the Database and the JTable. The goals of this product are to leverage the Database and Hibernate's filtering and sorting feature to JIDE Grids so that the client doesn't need to download all the records, and to bring the seamless paging support to table models and list models. Without getting into too much details, please continue to the product page to see features and screenshots. You can run web start demo to see several demos for JIDE Data Grids. Even though we release it as beta to in order to collect more feedbacks, the qualify and the APIs of the existing classes are stable enough to be used in the production code.  

JIDE Data Grids product is included in the JIDE Ultimate Suite. The Single Developer License for JIDE Data Grids is $99.99. It depends on JIDE Grids so you also need to purchase JIDE Grids if you don't have it. You can click here to find out more pricing information. For all JIDE Ultimate Suite customers, you can use this new product for free after asking us for a new license key. For all other customers, you can purchase this product separately along with JIDE Grids or upgrade to JIDE Ultimate Suite so that you will get the JIDE Data Grids or any future component products we will introduce for free. If you have any other questions, please feel free to email sales@jidesoft.com. 

Filters and CustomFilterEditor  

In this release, we bring the filtering support in JIDE Grids to the next level. Previously, the FilterableTableModel is complete but there aren't many user interface components to customize the filters except some simple text filtering and equality-based filtering through QuickFilterField, QuickFilterPane and AutoFilterTableHeader. However, FilterableTableModel can handle way more complex filtering than these simple ones. In this release, we introduced many built-in filters – from simple EqualFilter, LessThanFilter etc to more complex RegexFilter, BetweenFilter to SQL compatible filters such as LikeFilter (as in SQL LIKE statement), InFilter (as in SQL IN statement). With these filters, we are able to build CustomFilterEditor and TableCustomFilterEditor to allow your users defining filters using an easy-to-use user interface. You can refer to CustomFilterDemo.java for such an example. AutoFilterTableHeader "(Custom...)" option also uses CustomFilterEditor instead of asking you to implement it. Hopefully with this release you would never need to write a custom filter using code in most cases.

TableHeaderPopupMenuInstaller and TableHeaderPopupMenuCustomizer  

These two classes together provides an extensible solution to replace the existing TableColumnChooser to make it possible for you to custom the popup menu for the table header. GroupTable and AggregateTable use it to allow user to group or aggregate the columns through the popup menu. Any regular JTable also can use it for the column auto-resizing, show/hide columns in addition to any other menu items you want to add to the popup menu. 

TableCustomStyleEditor and TableSortItemEditor  

There are also a couple new components and features in this release. TableCustomStyleEditor is an interface which allows your user to define cell styles for the table columns. TableSortItemEditor is an interface which allows your user to customize the sort order in addition to clicking on the table header in case additional options are needed. There are also many bug fixes as usual. Please refer to the chagne log to for all the new features and bug fixes. Please pay special attention to the "Backward Compatible Issues" session as we deleted many deprecated methods in this major release.