Login and Registration using Sqlite Database with Forget Password

Introduction 

     In my previous article SQLiteManager plugin for eclipse i explained about how to view inserted sqlite database values in eclipse,now i am going to explain how to insert datas into sqlite database and how to check inserted sqlite database values.

demo

                                                                     Main Screen

           
                                                              
                                                                Registration Screen

                                                             Forget Password Screen

Using the code

activity_main.xml:

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="#D8D8D8"

tools:context=".MainActivity" >

<RelativeLayout

android:id="@+id/rel1"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_marginLeft="30dp"

android:layout_marginRight="30dp"

android:layout_marginTop="60dp" >

<TextView

android:id="@+id/textView1"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="@string/password" />

<EditText

android:id="@+id/password_edt"

android:layout_width="match_parent"

android:layout_height="40dp"

android:layout_alignParentRight="true"

android:layout_marginTop="30dp"

android:background="@drawable/background_round_corner_edittext"

android:ems="10"

android:inputType="textPassword"

android:padding="5dp" >

<requestFocus />

</EditText>

</RelativeLayout>

<RelativeLayout

android:id="@+id/rel2"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_below="@+id/rel1"

android:layout_marginLeft="30dp"

android:layout_marginRight="30dp"

android:layout_marginTop="15dp" >

<Button

android:id="@+id/login_btn"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:background="@drawable/background_round_corner_button"

android:paddingLeft="20dp"

android:paddingRight="20dp"

android:text="@string/Login" />

<Button

android:id="@+id/register_btn"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignParentRight="true"

android:layout_alignParentTop="true"

android:background="@drawable/background_round_corner_button"

android:paddingLeft="20dp"

android:paddingRight="20dp"

android:text="@string/register" />

</RelativeLayout>

<RelativeLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_below="@+id/rel2"

android:layout_marginLeft="30dp"

android:layout_marginRight="30dp"

android:layout_marginTop="15dp" >

<TextView

android:id="@+id/textView2"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="@string/forgetpassword" />

</RelativeLayout>

</RelativeLayout>

registration.xml:

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="#D8D8D8"

android:orientation="vertical" >

<ScrollView

android:id="@+id/scrollView1"

android:layout_width="match_parent"

android:layout_height="wrap_content" >

<RelativeLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:orientation="vertical" >

<LinearLayout

android:id="@+id/rel1"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_marginLeft="10dp"

android:layout_marginRight="10dp"

android:layout_marginTop="20dp"

android:orientation="vertical" >

<TextView

android:id="@+id/textView1"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="@string/password" />

<EditText

android:id="@+id/password_edt"

android:layout_width="match_parent"

android:layout_height="40dp"

android:layout_marginTop="10dp"

android:background="@drawable/background_round_corner_edittext"

android:ems="10"

android:inputType="textPassword"

android:maxLength="9"

android:padding="5dp" >

</EditText>

<CheckBox

android:id="@+id/checkBox1"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginTop="10dp"

android:text="@string/showpassword"

android:textColor="#1C1C1C" />

<TextView

android:id="@+id/textView2"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginTop="10dp"

android:text="@string/repassword" />

<EditText

android:id="@+id/repassword_edt"

android:layout_width="match_parent"

android:layout_height="40dp"

android:layout_marginTop="10dp"

android:background="@drawable/background_round_corner_edittext"

android:ems="10"

android:inputType="textPassword"

android:padding="5dp" />

<TextView

android:id="@+id/textView3"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginTop="10dp"

android:text="@string/securityhint" />

<EditText

android:id="@+id/securityhint_edt"

android:layout_width="match_parent"

android:layout_height="40dp"

android:layout_marginTop="10dp"

android:background="@drawable/background_round_corner_edittext"

android:ems="10"

android:padding="5dp" >

</EditText>

</LinearLayout>

<RelativeLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_below="@+id/rel1"

android:layout_marginLeft="10dp"

android:layout_marginRight="10dp"

android:layout_marginTop="20dp" >

<Button

android:id="@+id/register_btn"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginBottom="15dp"

android:background="@drawable/background_round_corner_button"

android:paddingLeft="20dp"

android:paddingRight="20dp"

android:text="@string/register" />

<Button

android:id="@+id/cancel_btn"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignParentRight="true"

android:layout_alignParentTop="true"

android:layout_marginBottom="15dp"

android:background="@drawable/background_round_corner_button"

android:paddingLeft="20dp"

android:paddingRight="20dp"

android:text="@string/cancel" />

</RelativeLayout>

</RelativeLayout>

</ScrollView>

</RelativeLayout>

home.xml:

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="#D8D8D8" >

<TextView

android:id="@+id/textView1"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignParentTop="true"

android:layout_centerHorizontal="true"

android:layout_marginTop="139dp"

android:text="Welcome"

android:textAppearance="?android:attr/textAppearanceLarge" />

</RelativeLayout> 

forget_search.xml: 

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:background="#D8D8D8"

android:orientation="vertical" >

<RelativeLayout

android:layout_width="wrap_content"

android:layout_height="wrap_content" >

<RelativeLayout

android:id="@+id/relativeLayout1"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_marginLeft="10dp"

android:layout_marginRight="10dp"

android:layout_marginTop="10dp" >

<TextView

android:id="@+id/textView1"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="@string/entersecurityhint" />

<EditText

android:id="@+id/securityhint_edt"

android:layout_width="match_parent"

android:layout_height="40dp"

android:layout_marginTop="25dp"

android:background="@drawable/background_round_corner_edittext"

android:ems="10"

android:padding="5dp" >

</EditText>

<TextView

android:id="@+id/textView2"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_below="@+id/securityhint_edt"

android:layout_marginTop="15dp"

android:text="@string/yourpassword" />

<TextView

android:id="@+id/textView3"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_below="@+id/textView2"

android:layout_marginTop="15dp"

android:textAppearance="?android:attr/textAppearanceMedium" />

</RelativeLayout>

<RelativeLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_below="@+id/relativeLayout1"

android:layout_marginTop="15dp"

android:paddingBottom="10dp" >

<Button

android:id="@+id/getpassword_btn"

android:layout_width="wrap_content"

android:layout_height="40dp"

android:background="@drawable/background_round_corner_button"

android:paddingLeft="20dp"

android:paddingRight="20dp"

android:text="@string/getpassword" />

<Button

android:id="@+id/cancel_btn"

android:layout_width="wrap_content"

android:layout_height="40dp"

android:layout_alignParentRight="true"

android:layout_alignParentTop="true"

android:background="@drawable/background_round_corner_button"

android:paddingLeft="20dp"

android:paddingRight="20dp"

android:text="@string/cancel" />

</RelativeLayout>

</RelativeLayout>

</RelativeLayout>

Java Codes:

MainActivity.java

package com.example.loginregisterwithsqlite;

import android.util.Log;

import android.view.View;

import android.view.Window;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.EditText;

import android.widget.TextView;

import android.widget.Toast;

import android.app.Activity;

import android.app.Dialog;

import android.content.Intent;

import android.os.Bundle;

public class MainActivity extends Activity {

LoginDataBaseAdapter loginDataBaseAdapter;

Button login;

Button registerr;

EditText enterpassword;

TextView forgetpass;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

login=(Button)findViewById(R.id.login_btn);

registerr=(Button)findViewById(R.id.register_btn);

enterpassword=(EditText)findViewById(R.id.password_edt);

forgetpass=(TextView)findViewById(R.id.textView2);

loginDataBaseAdapter = new LoginDataBaseAdapter(getApplicationContext());

loginDataBaseAdapter.open();

registerr.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

Intent i=new Intent(MainActivity.this,Registration.class);

startActivity(i);

}

});

login.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String Password=enterpassword.getText().toString();

String storedPassword=loginDataBaseAdapter.getSinlgeEntry(Password);

if(Password.equals(storedPassword))

{

Toast.makeText(MainActivity.this, "Congrats: Login Successfully", Toast.LENGTH_LONG).show();

Intent ii=new Intent(MainActivity.this,Home.class);

startActivity(ii);

}

else

if(Password.equals("")){

Toast.makeText(MainActivity.this, "Please Enter Your Password", Toast.LENGTH_LONG).show();

}

else

{

Toast.makeText(MainActivity.this, "Password Incorrect", Toast.LENGTH_LONG).show();

}

}

});

forgetpass.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

final Dialog dialog = new Dialog(MainActivity.this);

dialog.getWindow();

dialog.requestWindowFeature(Window.FEATURE_NO_TITLE);

dialog.setContentView(R.layout.forget_search);

dialog.show();

final EditText security=(EditText)dialog.findViewById(R.id.securityhint_edt);

final TextView getpass=(TextView)dialog.findViewById(R.id.textView3);

Button ok=(Button)dialog.findViewById(R.id.getpassword_btn);

Button cancel=(Button)dialog.findViewById(R.id.cancel_btn);

ok.setOnClickListener(new View.OnClickListener() {

public void onClick(View v) {

String userName=security.getText().toString();

if(userName.equals(""))

{

Toast.makeText(getApplicationContext(), "Please enter your securityhint", Toast.LENGTH_SHORT).show();

}

else

{

String storedPassword=loginDataBaseAdapter.getAllTags(userName);

if(storedPassword==null)

{

Toast.makeText(getApplicationContext(), "Please enter correct securityhint", Toast.LENGTH_SHORT).show();

}else{

Log.d("GET PASSWORD",storedPassword);

getpass.setText(storedPassword);

}

}

}

});

cancel.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

dialog.dismiss();

}

});

dialog.show();

}

});

}

@Override

protected void onDestroy() {

super.onDestroy();

// Close The Database

loginDataBaseAdapter.close();

}

}

Registration.java

package com.example.loginregisterwithsqlite;

import android.app.Activity;

import android.content.Intent;

import android.os.Bundle;

import android.text.method.HideReturnsTransformationMethod;

import android.text.method.PasswordTransformationMethod;

import android.util.Log;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.CheckBox;

import android.widget.CompoundButton;

import android.widget.EditText;

import android.widget.Toast;

import android.widget.CompoundButton.OnCheckedChangeListener;

public class Registration extends Activity{

LoginDataBaseAdapter loginDataBaseAdapter;

EditText password,repassword,securityhint;

Button register,cancel,reg_btn;

CheckBox check;

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

setContentView(R.layout.registration);

loginDataBaseAdapter = new LoginDataBaseAdapter(this);

loginDataBaseAdapter=loginDataBaseAdapter.open();

password=(EditText)findViewById(R.id.password_edt);

repassword=(EditText)findViewById(R.id.repassword_edt);

securityhint=(EditText)findViewById(R.id.securityhint_edt);

register=(Button)findViewById(R.id.register_btn);

cancel=(Button)findViewById(R.id.cancel_btn);

check=(CheckBox)findViewById(R.id.checkBox1);

check.setOnCheckedChangeListener(new OnCheckedChangeListener() {

@Override

public void onCheckedChanged(CompoundButton buttonView, boolean isChecked) {

// TODO Auto-generated method stub

if(!isChecked)

{

password.setTransformationMethod(PasswordTransformationMethod.getInstance());

}

else

{

password.setTransformationMethod(HideReturnsTransformationMethod.getInstance());

}

}

});

register.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String Pass=password.getText().toString();

String Secu=securityhint.getText().toString();

String Repass=repassword.getText().toString();

if(Pass.equals("")||Repass.equals("")||Secu.equals(""))

{

Toast.makeText(getApplicationContext(), "Fill All Fields", Toast.LENGTH_LONG).show();

return;

}

if(!Pass.equals(Repass))

{

Toast.makeText(getApplicationContext(), "Password does not match", Toast.LENGTH_LONG).show();

return;

}

else

{

// Save the Data in Database

loginDataBaseAdapter.insertEntry(Pass, Repass,Secu);

// reg_btn.setVisibility(View.GONE);

Toast.makeText(getApplicationContext(), "Account Successfully Created ", Toast.LENGTH_LONG).show();

Log.d("PASSWORD",Pass);

Log.d("RE PASSWORD",Repass);

Log.d("SECURITY HINT",Secu);

Intent i=new Intent(Registration.this,MainActivity.class);

startActivity(i);

}

}

});

cancel.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

Intent ii=new Intent(Registration.this,MainActivity.class);

startActivity(ii);

}

});

}

}

DataBaseHelper.java

package com.example.loginregisterwithsqlite;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.util.Log;

public class DataBaseHelper extends SQLiteOpenHelper

{

public DataBaseHelper(Context context, String name,CursorFactory factory, int version)

{

super(context, name, factory, version);

}

@Override

public void onCreate(SQLiteDatabase _db)

{

_db.execSQL(LoginDataBaseAdapter.DATABASE_CREATE);

}

@Override

public void onUpgrade(SQLiteDatabase _db, int _oldVersion, int _newVersion)

{

// Log the version upgrade.

Log.w("TaskDBAdapter", "Upgrading from version " +_oldVersion + " to " +_newVersion + ", which will destroy all old data");

_db.execSQL("DROP TABLE IF EXISTS " + "TEMPLATE");

onCreate(_db);

}

}

LoginDataBaseAdapter.java

package com.example.loginregisterwithsqlite;

import java.util.HashMap;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.SQLException;

import android.database.sqlite.SQLiteDatabase;

public class LoginDataBaseAdapter {

static final String DATABASE_NAME = "login.db";

static final int DATABASE_VERSION = 1;

public static final int NAME_COLUMN = 3;

static final String DATABASE_CREATE = "create table "+"LOGIN"+

"( " +"ID integer primary key autoincrement,"+ "PASSWORD text,"+"REPASSWORD text,"+ "SECURITYHINT text) ";

public SQLiteDatabase db;

private final Context context;

private DataBaseHelper dbHelper;

public LoginDataBaseAdapter(Context _context)

{

context = _context;

dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);

}

public LoginDataBaseAdapter open() throws SQLException

{

db = dbHelper.getWritableDatabase();

return this;

}

public void close()

{

db.close();

}

public SQLiteDatabase getDatabaseInstance()

{

return db;

}

public void insertEntry(String password,String repassword,String securityhint)

{

ContentValues newValues = new ContentValues();

newValues.put("PASSWORD", password);

newValues.put("REPASSWORD",repassword);

newValues.put("SECURITYHINT",securityhint);

db.insert("LOGIN", null, newValues);

}

public int deleteEntry(String password)

{

String where="PASSWORD=?";

int numberOFEntriesDeleted= db.delete("LOGIN", where, new String[]{password}) ;

return numberOFEntriesDeleted;

}

public String getSinlgeEntry(String password)

{

Cursor cursor=db.query("LOGIN", null, " PASSWORD=?", new String[]{password}, null, null, null);

if(cursor.getCount()<1) // UserName Not Exist

{

cursor.close();

return "NOT EXIST";

}

cursor.moveToFirst();

String repassword= cursor.getString(cursor.getColumnIndex("REPASSWORD"));

cursor.close();

return repassword;

}

public String getAllTags(String a) {

Cursor c = db.rawQuery("SELECT * FROM " + "LOGIN" + " where SECURITYHINT = '" +a + "'" , null);

String str = null;

if (c.moveToFirst()) {

do {

str = c.getString(c.getColumnIndex("PASSWORD"));

} while (c.moveToNext());

}

return str;

}

public void updateEntry(String password,String repassword)

{

ContentValues updatedValues = new ContentValues();

updatedValues.put("PASSWORD", password);

updatedValues.put("REPASSWORD",repassword);

updatedValues.put("SECURITYHINT",repassword);

String where="USERNAME = ?";

db.update("LOGIN",updatedValues, where, new String[]{password});

}

public HashMap<String, String> getAnimalInfo(String id) {

HashMap<String, String> wordList = new HashMap<String, String>();

String selectQuery = "SELECT * FROM LOGIN where SECURITYHINT='"+id+"'";

Cursor cursor = db.rawQuery(selectQuery, null);

if (cursor.moveToFirst()) {

do {

wordList.put("PASSWORD", cursor.getString(1));

} while (cursor.moveToNext());

}

return wordList;

}

}

Home.java

package com.example.loginregisterwithsqlite;

import android.app.Activity;

import android.os.Bundle;

public class Home extends Activity{

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

setContentView(R.layout.home);

}

}

background_round_corner_button.xml

This xml is stored under drawable folder for button background purpose

<?xml version="1.0" encoding="UTF-8"?>

<shape xmlns:android="http://schemas.android.com/apk/res/android"

android:shape="rectangle" android:padding="40dp">

<!-- you can use any color you want I used here gray color-->

<solid android:color="#01A9DB"/>

<corners

android:bottomRightRadius="20dp"

android:bottomLeftRadius="20dp"

android:topLeftRadius="20dp"

android:topRightRadius="20dp"/>

</shape>

background_round_corner_edittext.xml

This xml is stored under drawable folder for edittext background purpose

<?xml version="1.0" encoding="UTF-8"?>

<shape xmlns:android="http://schemas.android.com/apk/res/android" >

<solid android:color="#EFFBF2" />

<stroke

android:width="1dp"

android:color="#01A9DB"

/>

<corners

android:topLeftRadius="10dp"

android:topRightRadius="10dp"

android:bottomLeftRadius="10dp"

android:bottomRightRadius="10dp"

/>

</shape>

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?>

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

package="com.example.loginregisterwithsqlite"

android:versionCode="1"

android:versionName="1.0" >

<uses-sdk

android:minSdkVersion="8"

android:targetSdkVersion="19" />

<application

android:allowBackup="true"

android:icon="@drawable/ic_launcher"

android:label="@string/app_name"

android:theme="@style/AppTheme" >

<activity

android:name="com.example.loginregisterwithsqlite.MainActivity"

android:label="@string/app_name" >

<intent-filter>

<action android:name="android.intent.action.MAIN" />

<category android:name="android.intent.category.LAUNCHER" />

</intent-filter>

</activity>

<activity android:name=".Home" >

</activity>

<activity android:name=".Registration" >

</activity>

</application>

</manifest>

                                                              

Download Source Code

• Twitter
• Facebook
• Google
• Tumblr
• Pinterest