Guest User

Untitled

a guest
Jan 29th, 2018
30
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. CODING FOR ADD BUTTON
  2. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  3. try
  4. {
  5. Class.forName("com.mysql.jdbc.Driver");
  6. Connection con = (Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/conn", "root", "");
  7. Statement stmt = (Statement)con.createStatement();
  8. int id = Integer.parseInt(jTextField1.getText());
  9. String name = jTextField2.getText();
  10. String pref = (String)jComboBox1.getSelectedItem();
  11. int age = Integer.parseInt(jTextField3.getText());
  12. String query = "Insert into conn values("+ id + ", '" + name + "', '" + pref + "', " + age + ");";
  13. JOptionPane.showMessageDialog(rootPane, "New member added");
  14.  
  15. stmt.executeUpdate(query);
  16. }
  17. catch (Exception e)
  18. {
  19. JOptionPane.showMessageDialog(rootPane, e.getMessage());
  20. }
  21. }
Add Comment
Please, Sign In to add comment