Removing row from java (netbeans) connected to database

Asked Dec 18 '17 at 07:46

Active Dec 18 '17 at 08:02

Viewed 62 times

Im trying to remove row from java connected to database using this code

String sql="delete from buku where kode_buku=?";
int viewIndex = tabelDaftarBuku.getSelectedRow();

if(viewIndex != -1) 
{
    int modelIndex = tabelDaftarBuku.convertRowIndexToModel(viewIndex); 
    DefaultTableModel model2 = (DefaultTableModel)tabelDaftarBuku.getModel();
    model2.removeRow(modelIndex);
}

try {
    PreparedStatement pst=koneksi.prepareStatement(sql);
    pst.setString(1, jTKode1.getText());
    pst.execute();
    JOptionPane.showMessageDialog(null, "Deleted");
} catch(Exception e) {
    JOptionPane.showMessageDialog(null, e.getMessage());
}

The row is deleted when i check in the database but the java table stays the same and does not update unless i re-open it. Been trying to try to solve this but still has no idea, please help...

edited Dec 18 '17 at 08:02

Marcel

1,443
2
14
24

asked Dec 18 '17 at 07:46

DrunkLobster

try calling `model2.fireTableDataChanged()` after the call to `removeRow`. See https://stackoverflow.com/questions/3179136/jtable-how-to-refresh-table-model-after-insert-delete-or-update-the-data – Arnaud Dec 18 '17 at 07:52
tried it, still not updating the table – DrunkLobster Dec 18 '17 at 08:01
try to call `validate()` on the table's container. – Touniouk Dec 18 '17 at 08:08
either `viewIndex == -1` or the `convertRowIndexToModel` method doesn't return the correct index. – Maurice Perry Dec 18 '17 at 09:39
BTW: what is jTKode1? – Maurice Perry Dec 18 '17 at 09:42
@MauricePerry it was jText something, changed the variable name to something similar to my native language so it's easy to remember. – DrunkLobster Dec 18 '17 at 11:12

Removing row from java (netbeans) connected to database

0 Answers0