Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. if(String.valueOf(loginCount).equals("2")) {
  2.  
  3. File dbfile = new File(Global.StaticDB + "/Users" );
  4. SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(dbfile, null);
  5.  
  6. String loginQueryCheck=(String)DatabaseUtils.stringForQuery(db,"SELECT UserID from Users where Username like '" + txtUsername.getText().toString() + "' AND Password like '" + txtPassword.getText().toString() + "'",null);
  7.  
  8. Log.e("Login Query:", loginQueryCheck);
  9. db.close();
  10.  
  11. if(loginQueryCheck.length() > 1) {
  12. Context context = getApplicationContext();
  13. CharSequence text = "Logged In";
  14. int duration = Toast.LENGTH_SHORT;
  15. Toast toast = Toast.makeText(context, text, duration);
  16. toast.show();
  17. Intent ShowMainPage = new Intent(view.getContext(), MainPage.class);
  18. startActivityForResult(ShowMainPage, 0);
  19. } else {
  20. Context context = getApplicationContext();
  21. CharSequence text = "Login Failed";
  22. int duration = Toast.LENGTH_SHORT;
  23. Toast toast = Toast.makeText(context, text, duration);
  24. toast.show();
  25. }
  26. }
  27.  
  28. if(loginQueryCheck != null && !loginQueryCheck.equals("") && loginQueryCheck.length() > 0)
  29.  
  30. int loginQueryCheck=(int)DatabaseUtils.stringForQuery(db,
  31. "SELECT COUNT(DISTINCT UserID) FROM Users WHERE Username like '" +
  32. txtUsername.getText().toString() + "' AND Password like '" +
  33. txtPassword.getText().toString() + "'",null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement