How to delete and update sql table through JTable

[Narendra kodli]

Hello dear friends, i am newbie to this java forum, i have a problem given below

I want to do delete and update operations for sql table through JTable using swings, i am able to display the sql table in JTable but unable to do delete and update queries through JTable which should be reflected in sql table.

please help me

[Pierre Sugar]

I assume you retrieve data from a database and want to display the data in a JTable. If so forward the data to your table model and invoke fireTableDataChanged(). The old data will be cleared and replaced by the new data.
HTH
Pierre

[Narendra kodli]

Thanks for your reply...
Yes i can display table in jtable but my problem is to perform delete and update operation of sql through jtable.i.e jtable cells should act like text box.

[Cole Terry]

Narendra kodli wrote:Hello dear friends, i am newbie to this java forum, i have a problem given below

I want to do delete and update operations for sql table through JTable using swings, i am able to display the sql table in JTable but unable to do delete and update queries through JTable which should be reflected in sql table.

please help me

There is no direct way to sync the data in the JTable with one in the database. At least you must write some code: update the database according to data of the table's model.

[Narendra kodli]

http://www2.sys-con.com/itsg/virtualcd/Java/archives/0702/hendry/index.html#source

from above link i got code for jtable but it still not working for me, can any one help.

[Pierre Sugar]

Implement the setValueAt() method in your table model. In setValueAt() fire a property change to inform listeners on changes. In the listener class update your database with new values.

setValueAt() in your table model

    @Override
    public void setValueAt(Object object, int rowIndex, int columnIndex) {
        Item item = items.get(rowIndex);//items is holding the data, e.g. in an ArrayList
        switch (columnIndex) {
            case 0 :
                return;
            case 1 :
                String description = (String)object;
                item.setDescription(description);
                break;
            case 2 :
                String size = (String)object;
                item.setSize(size);
                break;
            default:
                assert(false);
        }
        super.fireTableRowsUpdated(rowIndex, rowIndex); //update your JTable
        boolean changed = !this.cellChanged;
        this.changeSupport.firePropertyChange("cellChanged", this.cellChanged, changed); //inform listeners about changes
        this.cellChanged = changed;
    }

Listen on changes in your listener class and update the database

    public void propertyChange(PropertyChangeEvent evt) {
        String propertyName = evt.getPropertyName();
        if (propertyName.equals("cellChanged")) {
            //retrieve the currently selected object in your JTable
            //update your database with the changed object
        }
    }

[Rob Spoor]

Why use a PropertyChangeListener? With TableModelListener you can already do this. Simply listen for TableModelEvents with a type of TableModelEvent.UPDATE.

[Pierre Sugar]

TableModelListener is definitely the better solution.