How to delete row from bound JTable?

Question

I have a JTable bound to MySQL. I already have done code to insert data.

But i don't know how to delete.

I have this sample delete method that works in other simple projects.

public String deleteItem(String name) {

    String answer = "";
    try {
        Connection con = Connect.getConnection();
        String sql = "Delete FROM item where name = ?";
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setString(1, name);

        ps.executeUpdate();

        ps.close();
        con.close();

        answer = "OK";
    } catch (Exception e) {
        answer = e.toString();
    }

    return answer;
}

Even when I worked with an unbound table I have done this remove row from jtable that did well for me.

But now its a table bound to MySQL and I can't find a way to delete row... already searched on the internet. Found nothing.

PS: i'm using netbeans. i right-clicked jtable > bind > elements , to bind table.

yes, this is my code, but i don't know how can i use it in this case. — Slaled, Oct 02 '18 at 23:58
i want to delete a row in jtable without writing an id or name in a textfield, only from button. — Slaled, Oct 02 '18 at 23:59
MadProgrammer , in netbeans i right-clicked jtable > bind > elements > choose database and table — Slaled, Oct 03 '18 at 00:04
`i right-clicked jtable > bind > elements > choose database and table` - so then the IDE must generate some code to do the deletion, or maybe it is only bound for the query and you need to write the delete code yourself. If you need to write the code yourself then you need to override the `removeRow(...)` method of your TableModel to add the code to manually delete the row from the database. — camickr, Oct 03 '18 at 00:15
Possible duplicate [remove row from jtable](https://stackoverflow.com/questions/27425476/remove-row-from-jtable) — MadProgrammer, Oct 03 '18 at 00:35
The key is to understand (and share with us) how did Netbeans bind the `JTable` to the database. — c0der, Oct 03 '18 at 06:00
Can you show your table code, that way we can be able to help. — Kebab Programmer, Oct 03 '18 at 11:30
thanks for help buddies, I found an way to do it, I posted a answer. — Slaled, Oct 03 '18 at 15:11

score 0 · Accepted Answer · edited Jun 20 '20 at 09:12

Oh, I found a way!

First, I changed my deleteItem method, to delete by id

ItemDAO.java

public String deleteItem(int ID_item) {
    
    String answer = "";
    try {
        Connection con = Connect.getConnection();
        String sql = "Delete FROM item where ID_Item = ?";
        PreparedStatement ps = con.prepareStatement(sql);
        ps.setInt(1, ID_item);

        ps.executeUpdate();
        
        ps.close();
        con.close();

        answer = "OK";
    } catch (Exception e) {
        answer = e.toString();
    }

    return answer;
}

Then the action in delete button goes like this.

Form.java

private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {                                           
     int column = 0;    // get the first column which is ID_Item
     int row = tableItem.getSelectedRow();  //get row selected by user
     int value = (int) tableItem.getModel().getValueAt(row, column); // store ID_Item value
     String answer = new ItemDAO().deleteItem(value);  // call up deleteItem method
             
     if(answer.equals("OK")) {
         System.out.println("OK"); // just for test
         itemList.clear();    // this is needed to update the bound table after Insert/Delete/Update etc
         itemList.addAll(itemQuery.getResultList()); // same as above comment
     }else{
         System.out.println("ERROR"); // just for test.
     }

Maybe isn't the most beautiful way to do it, but it works.

How to delete row from bound JTable?

1 Answers1

ItemDAO.java

Form.java