Guest User

Untitled

a guest
Nov 14th, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. String user=new String(tf1.getText());
  2. String pass=new String(pf1.getPassword());
  3. String mb=new String(tf2.getText());
  4. String email=new String(tf3.getText());
  5. String query="INSERT into user_info (username,password,email_id,mobile number) VALUES('"+user+"','"+pass+"','"+email+"','"+mb+"')";
  6. try {
  7. Connection myConn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaproject","root","noor1032");
  8. System.out.println("databse connected");
  9. PreparedStatement myStat=myConn.prepareStatement(query);
  10. System.out.println("statement prepapred");
  11. myStat.setString(1, user);
  12. myStat.setString(2, pass);
  13. myStat.setString(3, email);
  14. myStat.setString(4, mb);
  15. myStat.executeUpdate();
  16. System.out.println("query executed");
  17. myConn.close();
  18. JOptionPane.showMessageDialog(null, "saved");
  19. }
  20. catch(Exception f)
  21. {
  22. System.err.println("Got an exception!");
  23. System.err.println(f.getMessage());
  24. }
  25.  
  26. myStat.setString(1, user);
  27. myStat.setString(2, pass);
  28. myStat.setString(3, email);
  29. myStat.setString(4, mb);
  30.  
  31. String query="INSERT into user_info (username,password,email_id,mobile number) VALUES(?,?,?,?)";
Add Comment
Please, Sign In to add comment