Guest User

Untitled

a guest
Nov 18th, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. public sqlconnection()
  2. {
  3. try
  4. {
  5. Connection myConn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/userlogin","jeddy","admin");
  6. insertIntoDB();
  7. }
  8. catch (Exception e)
  9. {
  10. e.printStackTrace();
  11. }
  12. }
  13.  
  14. public void insertIntoDB() throws SQLException
  15. {
  16. try
  17. {
  18. String driver ="com.mysql.jdbc.Driver";
  19.  
  20. Class.forName(driver);
  21. String inpUsername=console.readLine("Enter username: ");
  22. String inpPassword=console.readLine("Enter password: ");
  23.  
  24. String sql = ("insert into user(username, password) values('"+inpUsername+"', '"+inpPassword+"')");
  25. PreparedStatement pStmt = myConn.prepareStatement(sql);
  26.  
  27. pStmt.executeUpdate();
  28.  
  29. }
  30. catch (Exception e)
  31. {
  32. e.printStackTrace();
  33. }
  34. }
Add Comment
Please, Sign In to add comment