Guest User

Untitled

a guest
Oct 3rd, 2018
633
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. package com.me.doctor.doctor_me;
  2. import android.content.Context;
  3. import android.database.Cursor;
  4. import android.database.DatabaseUtils;
  5. import android.database.sqlite.SQLiteDatabase;
  6. import android.database.sqlite.SQLiteQueryBuilder;
  7.  
  8. import com.readystatesoftware.sqliteasset.SQLiteAssetHelper;
  9.  
  10. public class DatabaseOperation extends SQLiteAssetHelper {
  11.  
  12. public static final int DB_VERSION = 1;
  13. public static final String DB_NAME= "my_doc_db.db";
  14.  
  15. public DatabaseOperation(Context context) {
  16. super(context, DB_NAME,null, DB_VERSION);
  17. }
  18.  
  19. // Verify user Loggin
  20. public boolean loginUser(String email, String password) {
  21. SQLiteDatabase db = this.getReadableDatabase();
  22. SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
  23.  
  24. String sqlTables = "users";
  25. qb.setTables(sqlTables);
  26.  
  27. //Cursor c = qb.query(db,null,"email = ? AND password = ?",new String[]{email,password},null,null,null);
  28. Cursor c = qb.query(db,null,null,null,null,null,null);
  29.  
  30. DatabaseUtils.dumpCursor(c);
  31. System.out.println("count "+c.getCount());
  32. //DatabaseUtils.dumpCursor(c);
  33. if (c.getCount() > 0) {
  34. return true;
  35. } else {
  36. return false;
  37. }
  38. }
  39. }
  40.  
  41. com.me.doctor.doctor_me I/System.out:
  42. Dumping cursor android.database....
  43. 0 {
  44. user_id=1
  45. user_name=test
  46. telephone=0711229266
  47. nic=952444140v
  48. gender=Male
  49. email=test@gmail.com
  50. password=test
  51. }
  52. 10-03 10:30:45.910 3619-3619/com.me.doctor.doctor_me I/System.out:
  53.  
  54. = indexsqlite_autoindex_users_1users
  55.  ÈÁÁÁ B '!+test user two077123456791236129vFemaletest2@gmail.comtest2 + test user three ? )!)t; !!+test20711229266941234566vFemaletest2@gmail.comtest26 !!)test0711229266952444140vMaletest@gmail.comtest
  56. ö üöäää
Add Comment
Please, Sign In to add comment