Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(String.valueOf(loginCount).equals("2")) {
- File dbfile = new File(Global.StaticDB + "/Users" );
- SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(dbfile, null);
- String loginQueryCheck=(String)DatabaseUtils.stringForQuery(db,"SELECT UserID from Users where Username like '" + txtUsername.getText().toString() + "' AND Password like '" + txtPassword.getText().toString() + "'",null);
- Log.e("Login Query:", loginQueryCheck);
- db.close();
- if(loginQueryCheck.length() > 1) {
- Context context = getApplicationContext();
- CharSequence text = "Logged In";
- int duration = Toast.LENGTH_SHORT;
- Toast toast = Toast.makeText(context, text, duration);
- toast.show();
- Intent ShowMainPage = new Intent(view.getContext(), MainPage.class);
- startActivityForResult(ShowMainPage, 0);
- } else {
- Context context = getApplicationContext();
- CharSequence text = "Login Failed";
- int duration = Toast.LENGTH_SHORT;
- Toast toast = Toast.makeText(context, text, duration);
- toast.show();
- }
- }
- if(loginQueryCheck != null && !loginQueryCheck.equals("") && loginQueryCheck.length() > 0)
- int loginQueryCheck=(int)DatabaseUtils.stringForQuery(db,
- "SELECT COUNT(DISTINCT UserID) FROM Users WHERE Username like '" +
- txtUsername.getText().toString() + "' AND Password like '" +
- txtPassword.getText().toString() + "'",null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement