Advertisement
Guest User

Untitled

a guest
Jul 7th, 2016
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. "Connection authentication failure occurred. Reason: Userid or password invalid."
  2.  
  3.  
  4.  
  5. public static void CoLogin(String username, String password){
  6. try{
  7. String dbuser = "";
  8. String dbpass = "";
  9. String url = "jdbc:derby://localhost:1527/Java-App";
  10. String user = username;
  11. String pass = password;
  12. Connection con = DriverManager.getConnection(url, "admin", "admin");
  13.  
  14. Statement stmt = con.createStatement();
  15. String SQL = "SELECT * FROM MEMBERS WHERE ID='" + user + "' && PASSWORD='" + pass + "'";
  16. ResultSet rs = stmt.executeQuery(SQL);
  17.  
  18. while(rs.next()){
  19. dbuser= rs.getString("ID");
  20. dbpass = rs.getString("PASSWORD");
  21. }
  22. if(user.equals(dbuser) && pass.equals(dbpass)){
  23. Main x = new Main();
  24. x.setVisible(true);
  25. }
  26. else{
  27. Login x = new Login();
  28. x.setVisible(true);
  29. }
  30.  
  31. //Connection con = DriverManager.getConnection(url, user, pass);
  32.  
  33. }
  34. catch(SQLException error){
  35. System.out.println(error.getMessage());
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement