Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- btnSignin.setOnClickListener(new View.OnClickListener(){
- @Override
- public void onClick(View v) {
- dbhelper = new DatabaseHelper(MainActivity.this);
- dbhelper = dbhelper.open();
- String emailId = edtEmailid.getText().toString();
- String Password = edtPassword.getText().toString();
- String StoredPass = dbhelper.getSinlgeEntry(emailId);
- //Log.d("MSG",StoredPass);
- String name = dbhelper.getSinlgeEntryName(emailId);
- if (Password.equals(StoredPass)) {
- sharedPrefs = getApplicationContext().getSharedPreferences(
- PRIVATE_PREF, Context.MODE_PRIVATE);
- editor = sharedPrefs.edit();
- editor.putString("Uname", edtEmailid.getText().toString());
- // editor.putString("Name", name);
- editor.commit();
- Toast.makeText(getApplication(), "Sign In Successfully", Toast.LENGTH_SHORT).show();
- Log.d("Email", name);
- Log.d("Email", Password);
- } else {
- Toast.makeText(MainActivity.this, "Email Id or Password does not match", Toast.LENGTH_SHORT).show(); }
- public class DatabaseHelper extends SQLiteOpenHelper{
- private static final String DATABASE_NAME = "Register.db";
- private static final int DATABASE_VERSION = 1;
- public static final int NAME_COLUMN = 1;
- SQLiteDatabase db;
- public DatabaseHelper(Context context) {
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
- }
- @Override
- public void onCreate(SQLiteDatabase _db) {
- _db.execSQL( "create table LOGIN " +
- "(id integer primary key, USERNAME text,EMAILID text,PASSWORD text)" );
- }
- @Override
- public void onUpgrade(SQLiteDatabase _db, int oldVersion, int newVersion) {
- _db.execSQL("DROP TABLE IF EXIST LOGIN");
- onCreate(_db);
- }
- public DatabaseHelper open() {
- db = this.getWritableDatabase();
- return this;
- }
- public void close() {
- db.close();
- }
- public SQLiteDatabase getDatabaseInstance() {
- return db;
- }
- public void insertEntry(String UserName,String emailId,String Password){
- SQLiteDatabase db = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put("USERNAME",UserName);
- values.put("EMAILID",emailId);
- values.put("PASSWORD",Password);
- db.insert("LOGIN",null,values);
- db.close();
- }
- public String getSinlgeEntry(String emailId) {
- // SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.query("LOGIN",null, "USERNAME=?",new String[]{emailId},null,null,null);
- if (cursor.getCount() < 1) // UserName Not Exist
- {
- cursor.close();
- return "NOT EXIST";
- }
- cursor.moveToFirst();
- String Password = cursor.getString(cursor.getColumnIndex("PASSWORD"));
- cursor.close();
- return Password;
- }
- public String getSinlgeEntryName(String emailId) {
- Cursor c = db.query("LOGIN",null, "USERNAME=?",new String[] {emailId},null,null,null);
- if (c.getCount() < 1) // UserName Not Exist
- {
- c.close();
- return "NOT EXIST";
- }
- c.moveToFirst();
- String UserName = c.getString(c.getColumnIndex("USERNAME"));
- c.close();
- return UserName;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement