Part 8: programming in NetBeans how to delete data into MYSQLdata base
Connection con; try { con=DriverManager.getConnection("jdbc:mysql://localhost/APP1", "root", ""); Statement st; st = con.createStatement(); String di=String.valueOf(jTable1.getValueAt(jTable1.getSelectedRow(), 0)); String query; query ="DELETE FROM `produit` WHERE `ID` = "+di; st.executeUpdate(query); // LISTPRODUIT(); } catch (SQLException ex) { Logger.getLogger(ADMIN.class.getName()).log(Level.SEVERE, null, ex); }