Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Binding a JTable column to a bound combobox

 
Hugo Rabson
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
NetBeans makes it easy to create a Jtable and bind it to a table from an SQL database, thanks to TopLink Essentials.

...But how do I bind a column in the database to a particular table?

Let's say you have a table called Employees. Each row contains a unique ID#, a name (e.g. John Smith) and the ID of the employee's department. You may edit the table to change any of this information.

This table has been bound to a Jtable called EmployeesTable.

I would like to edit each employee's department not as a number but as a combobox populated with the department names (Sales, Marketing, etc.), pulled from another table (called Departments, let's say). When the user selects the department name, the ID# of the department should be fed back to the column in that row of the table.

Binding an SQL table to a JComboBox is trivial, thanks to the BeansBinding tools. However, I haven't figured out how to bind *all* entries in a column of a JTable that way.

I've been trying to figure this out since October, without success. *Any* advice would be appreciated. Although I'm not new to programming, I am new to Java. Thank you for your time.
 
Maki Jav
Ranch Hand
Posts: 447
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

You will have to use AbstractTableModel and ListSelectionListener for this.

Maki Jav
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic