Advertisement
Guest User

Untitled

a guest
Sep 18th, 2016
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.95 KB | None | 0 0
  1. @Override
  2. public void onClick(View v) {
  3.  
  4. dbhelper = new DatabaseHelper(MainActivity.this);
  5. dbhelper = dbhelper.open();
  6.  
  7. String emailId = edtEmailid.getText().toString();
  8. String Password = edtPassword.getText().toString();
  9.  
  10. String StoredPass = dbhelper.getSinlgeEntry(emailId);
  11. //Log.d("MSG",StoredPass);
  12. String name = dbhelper.getSinlgeEntryName(emailId);
  13.  
  14. if (Password.equals(StoredPass)) {
  15.  
  16. sharedPrefs = getApplicationContext().getSharedPreferences(
  17. PRIVATE_PREF, Context.MODE_PRIVATE);
  18. editor = sharedPrefs.edit();
  19. editor.putString("Uname", edtEmailid.getText().toString());
  20. // editor.putString("Name", name);
  21. editor.commit();
  22. Toast.makeText(getApplication(), "Sign In Successfully", Toast.LENGTH_SHORT).show();
  23. Log.d("Email", name);
  24. Log.d("Email", Password);
  25.  
  26. } else {
  27.  
  28. private static final String DATABASE_NAME = "Register.db";
  29.  
  30. private static final int DATABASE_VERSION = 1;
  31. public static final int NAME_COLUMN = 1;
  32. SQLiteDatabase db;
  33.  
  34. public DatabaseHelper(Context context) {
  35. super(context, DATABASE_NAME, null, DATABASE_VERSION);
  36. }
  37. @Override
  38. public void onCreate(SQLiteDatabase _db) {
  39. _db.execSQL( "create table LOGIN " +
  40. "(id integer primary key, USERNAME text,EMAILID text,PASSWORD text)" );
  41.  
  42. }
  43.  
  44. @Override
  45. public void onUpgrade(SQLiteDatabase _db, int oldVersion, int newVersion) {
  46.  
  47. _db.execSQL("DROP TABLE IF EXIST LOGIN");
  48. onCreate(_db);
  49. }
  50.  
  51. public DatabaseHelper open() {
  52. db = this.getWritableDatabase();
  53. return this;
  54. }
  55.  
  56. public void close() {
  57. db.close();
  58. }
  59.  
  60. public SQLiteDatabase getDatabaseInstance() {
  61. return db;
  62. }
  63.  
  64. public void insertEntry(String UserName,String emailId,String Password){
  65.  
  66. SQLiteDatabase db = this.getWritableDatabase();
  67.  
  68. ContentValues values = new ContentValues();
  69. values.put("USERNAME",UserName);
  70. values.put("EMAILID",emailId);
  71. values.put("PASSWORD",Password);
  72.  
  73. db.insert("LOGIN",null,values);
  74. db.close();
  75.  
  76. }
  77. public String getSinlgeEntry(String emailId) {
  78.  
  79. // SQLiteDatabase db = this.getReadableDatabase();
  80.  
  81. Cursor cursor = db.query("LOGIN",null, "USERNAME=?",new String[]{emailId},null,null,null);
  82.  
  83. if (cursor.getCount() < 1) // UserName Not Exist
  84. {
  85. cursor.close();
  86. return "NOT EXIST";
  87. }
  88. cursor.moveToFirst();
  89. String Password = cursor.getString(cursor.getColumnIndex("PASSWORD"));
  90. cursor.close();
  91. return Password;
  92. }
  93.  
  94. public String getSinlgeEntryName(String emailId) {
  95. Cursor c = db.query("LOGIN",null, "USERNAME=?",new String[] {emailId},null,null,null);
  96.  
  97. if (c.getCount() < 1) // UserName Not Exist
  98. {
  99. c.close();
  100. return "NOT EXIST";
  101. }
  102. c.moveToFirst();
  103. String UserName = c.getString(c.getColumnIndex("USERNAME"));
  104. c.close();
  105. return UserName;
  106. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement