Binding a JTable to Swing Controls in NetBeans IDE

Thanks for these instructions Patrick. I haven't been able to find much on the web about binding tables to collections of POJOs.

I'm trying to do the same thing as Richard Osbaldeston - except that I want to bind a JTable (or JXTable) to a List of POJOs using NetBeans tooling. I don't want to bind to a data base directly. I just want to bind to a result list. I gather from this thread that its possible to do this without hand coding special binding, but I haven't been able to reproduce the steps to do it.

Would you please provide an explicit set of steps for this use case?

Patrick wrote:
[quote]Regarding tables and column headers, you can do this in the UI without doing a special binding. In the Design view, right-click the table header and choose Table Columns. Then select the Columns tab. You can then type in the label text that you want for each of the columns.[/quote]and [quote]Actually, in this case, I'm talking about doing that *after* you have already done the binding. The use case I'm thinking of is that you have done your binding already, but that the generated column titles (based on column names in the entity class) don't look exactly how you would want your user to encounter them.[/quote]

I've created a MyPojoList class that extends ArrayList<myEntityClass> and added it to the Palette. Then I placed an instance of this class on the form so that it would appear in the Binding Source pull-down in the elements binding dialog. The default constructor creates an empty list.

Question: Is this the only/best way to make a List available for binding? What interfaces must MyPojoList implement to work with the tooling - ie. any special design-time suport? Or should any collection implementation do?

Next I select my JTable and set Binding | elements. I set the Binding Source to my instance of MyPojoList. I do not use "Import Data to Form..." because I don't want to bind directly to the database. When I set the binding the JTable disappers. I think that the table model generation is failing.

Anyone like to share a simple example of using Netbeans tooling to bind a JTable to a List<myPOJO> where the list is populated at runtime?

 

 

Hi Todd,

if you want to create a list (e.g. consumerList) in NetBeans that you can easily bind (without knowing the db schema), you can try the following. Go to the Form Inspector. Right click 'Other Components'->'add from palette'->Java Persistence->Query Result. Change the name to consumerList. Then you only need to call:

createColumnsFromDB(Consumer.class, consumerList, consumerTable);

after initComponents(). Hope this helps.

Regards,

Peter.

public static void createColumnsFromDB(Class<?> clazz, List list, JTable table, BindingListener bl) {
        BindingGroup myBindingGroup = new BindingGroup();
        JTableBinding tableBinding =
                SwingBindings.createJTableBinding(UpdateStrategy.READ_WRITE, list, table);
        JTableBinding.ColumnBinding columnBinding;

        Field fields[] = clazz.getDeclaredFields();

        for (Field f : fields) {
            // include only primitive types and String
            Class<?> clazzOfField = toWrapper(f.getType());
            
            String name = f.getName();
            if (clazzOfField == null || f.getName().toLowerCase().equals("id")) {
                continue;
            }
            columnBinding = tableBinding.addColumnBinding(ELProperty.create("${" + name + "}"));
            columnBinding.setColumnName(name);
            columnBinding.setColumnClass(clazzOfField);
        }
        //One example:
        //columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${customerId}"));
        //columnBinding.setColumnName("Customer Id");
        //columnBinding.setColumnClass(Integer.class);

        // observe changes to every single property
        myBindingGroup.addBindingListener(bl);
        myBindingGroup.addBinding(tableBinding);
        myBindingGroup.bind();
}

public static Class toWrapper(Class clazz) {
        if (Number.class.isAssignableFrom(clazz)) {
            return clazz;
        } else if (clazz.equals(int.class)) {
            return Integer.class;
        } else if (clazz.equals(long.class)) {
            return Long.class;
        } else if (clazz.equals(boolean.class)) {
            return Boolean.class;
        } else if (clazz.equals(float.class)) {
            return Float.class;
        } else if (clazz.equals(double.class)) {
            return Double.class;
        } else if (clazz.equals(short.class)) {
            return Short.class;
        } else if (clazz.equals(String.class)) {
            return String.class;
        } else {
            return null;
        }
}

I've been readind a lot about data binding in Netbeans and I'm wondering if someone could please help me and tell me how do I bind a two table query into a jTable?

 How do I bind this query "Select * From Trip, TripType" to a jTable?

 

Thank you! 

after some 'extreme' head banging on desk, I found out netbeans wasn't auto-generating the "right" code! Here is the list to which my JTableBinding must be bound, everything works perfectly now! (the new code creates the jimstableList from the ObservableCollections method):

 

jimstableList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : org.jdesktop.observablecollections.ObservableCollections.observableList(jimstableQuery.getResultList());

...

org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, jimstableList, jTable1);

Sorry, but after I edit table data, the data is not synchronized with the database (even though my binding settings is read/write i.e. in advanced settings of table bind).

 

What should I do to make it update database ?

 

thanks

Please i'm trying to bind a JTable to a table in the database and anytime I right-click the JTable and select bind and then "Import to form" an error message prompts up saying i cannot import that it does not support this package..blah blah. Pls can anyone help on how i go about binding my tables. Thanks.

Hello

I am currently working with netbeans and ms access - I want my program to do the following :

- connect to the database from Netbeans 

- display records in table form(in netbeans) from the database

- bind the table

- use of a radio button

- the option to listen to music

 

If someone could help me with a sample program I would be very grateful.

NB : database has to be MS Access.

Thanks 

Rani

I want you

Iam new in java swing and can anyone pls help me by giving the syntax to read value from a jtable and enter data to jtable plzzzzzzzzzzz

Hi, i am using HSQLDB and i've followed your tutorial exactly. However, the following prompted out: [TopLink Info]: 2011.03.16 07:59:11.657--ServerSession(9142687)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007)) [TopLink Info]: 2011.03.16 07:59:12.606--Not able to detect platform for vendor name [HSQL Database Engine]. Defaulting to [oracle.toplink.essentials.platform.database.DatabasePlatform]. The database dialect used may not match with the database you are using. Please explicitly provide a platform using property toplink.platform.class.name. [TopLink Info]: 2011.03.16 07:59:13.209--ServerSession(9142687)--file:/C:/Users/Jessica/Documents/NetBeansProjects/ADT/src/-databasePU login successful BUILD SUCCESSFUL (total time: 15 seconds) what should i do to fix this?

wonderful tutorials..and the swing controls makes it a lot better! mexican dip recipes 

 

 

This website has very good content. Please let me know if you're looking for a article author for your weblog. frac plugs

I like all information that you provide in your articles. arbeitstische

The two set out to create a workout studio and a new way of life.Stoker

It is a really good reading. I do appreciate that youve added relevant and intelligent commentary here thoughTop Rated Coffeemakers HQ