Advertisement
Guest User

Untitled

a guest
Apr 2nd, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. boolean loginFlag = false;
  2.  
  3. Connection con;
  4. Statement st;
  5. ResultSet rs;
  6.  
  7. try{
  8. Class.forName("com.mysql.jdbc.Driver");
  9. con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", ""); //Establishing connection //3306 - code for mac
  10. st = con.createStatement();
  11.  
  12. String query = "select * from users";
  13. rs = st.executeQuery(query);
  14.  
  15. while(rs.next()) {
  16. if(catchUsername.equals(rs.getString("username")) && catchPassword.equals(rs.getString("password"))) {
  17. loginFlag = true;
  18. }
  19. }
  20. } catch (Exception e) {
  21. e.printStackTrace();
  22. }
  23.  
  24. return loginFlag;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement