Part 9: programming in NetBeans how to modifie data into MYSQLdata base
كود التعديل
Connection con; try { con=DriverManager.getConnection("jdbc:mysql://localhost/APP1", "root", ""); Statement st; st = con.createStatement(); String IDapdate=String.valueOf(jTable1.getValueAt(jTable1.getSelectedRow(), 0)); String query; query ="UPDATE `produit` SET `id`="+id.getText()+",`nam`='"+nam.getText()+"',`prix`="+prix.getText()+",`stock`="+stock.getText()+" WHERE `id`="+IDapdate; st.executeUpdate(query); } catch (SQLException ex) { Logger.getLogger(ADMIN.class.getName()).log(Level.SEVERE, null, ex);} LISTPRODUIT();