Advertisement
Guest User

Untitled

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