Part 7: programming in NetBeans how to insert data into MYSQLdata base
كود الاضافة
if ( id.getText().equals("")|| nam.getText().equals("") || prix.getText().equals("")|| stock.getText().equals("")) { JOptionPane.showMessageDialog(this, "SVP entrer les informations complete"); } else { String query="INSERT INTO `produit`(id,`nam`,prix,`stock`) VALUES("+id.getText()+",'"+nam.getText()+"',"+prix.getText()+",'"+stock.getText()+"');"; Connection con; Statement st; try{ con=DriverManager.getConnection("jdbc:mysql://localhost/APP1", "root", ""); st = con.createStatement(); st.executeUpdate(query); JOptionPane.showMessageDialog(this, "OK "); LISTPRODUIT(); } catch(Exception e) { JOptionPane.showMessageDialog(null ,e); } }