Guest User

Untitled

a guest
Jan 23rd, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. String name= jTextField1.getText();
  2. String mobile= jTextField2.getText();
  3. String email= jTextField3.getText();
  4. if (name.isEmpty())
  5. JOptionPane.showMessageDialog(null,"Please enter your name");
  6. else if (mobile.isEmpty())
  7. JOptionPane.showMessageDialog(null,"Please enter your mobile");
  8. else if (email.isEmpty())
  9. JOptionPane.showMessageDialog(null,"Please enter your email");
  10. else {
  11. try {
  12. Class.forName("java.sql.DriverManager");
  13. Connection con = (Connection) DriverManager.getConnection ("jdbc:mysql://localhost:3306/practicals", "root", "system");
  14. Statement stmt = (Statement) con.createStatement();
  15. String query="insert into contacts values ('"+name+"','"+mobile+"','"+email+"');";
  16. stmt.executeUpdate(query);
  17. JOptionPane.showMessageDialog(this, "Added Successfully");
  18. } catch (Exception e)
  19. {
  20. JOptionPane.showMessageDialog(null,e.getMessage());
  21. }
  22. }
  23. }
Add Comment
Please, Sign In to add comment