Android Tutorials for Beginners: Content Values

Showing posts with label Content Values. Show all posts

Tuesday, March 12, 2013

Creating User Sign in Dialog In Android

Android Tutorials for Beginners

In this post we will develop an app in which a user can perform following task
1: User Can Create Account
2: User Can log in

we will use and learn following this in this Post

Customized Dialog: Here we have used Customized Dialog for User Login.
Creating DataBase: Here we have created database for Storing UserName and Password.
Writing functions for Inserting, Deleting, Updating and querying a Datbase.

we have create a Table with following Fields :

USERNAME : to store the user name.
PASSWORD: to store the password of User

Table Name is LOGIN

The Code is well commented , just go through , you will understand easily.

Some More Good Android Topics
Customizing Toast In Android
Showing Toast for Longer Time
Customizing Checkboxes In Android
Customizing Progress Bar

List of XMLs Used.

main.xml : main screen
signup.xml : to create a new account
login.xml : to login

main.xml

signup.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    android:gravity="center_vertical" >

    <EditText
        android:id="@+id/editTextUserName"
        android:hint="User Name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        >

        <requestFocus />
    </EditText>

    <EditText
        android:id="@+id/editTextPassword"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
         android:hint="Password"
        android:inputType="textPassword" />

    <EditText
        android:id="@+id/editTextConfirmPassword"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:hint="Confirm Password"
        android:inputType="textPassword" />

    <Button
        android:id="@+id/buttonCreateAccount"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Create Account"
        android:layout_marginBottom="60dp" />

</LinearLayout>

login.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    <EditText
        android:id="@+id/editTextUserNameToLogin"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="User Name"
        android:ems="10" >

        <requestFocus />
    </EditText>

    <EditText
        android:id="@+id/editTextPasswordToLogin"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:ems="10"
        android:inputType="textPassword"
        android:hint="Password" />

    <Button
        android:id="@+id/buttonSignIn"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Sign In" />

</LinearLayout>

Activities:

1: HomeActivity.java

public class HomeActivity extends Activity
{

    Button btnSignIn,btnSignUp;
    LoginDataBaseAdapter loginDataBaseAdapter;

    @Override
    protected void onCreate(Bundle savedInstanceState)
    {
             super.onCreate(savedInstanceState);
             setContentView(R.layout.main);

             // create the instance of Databse
             loginDataBaseAdapter=new LoginDataBaseAdapter(this);
             loginDataBaseAdapter=loginDataBaseAdapter.open();

             // Get The Refference Of Buttons
             btnSignIn=(Button)findViewById(R.id.buttonSignIN);
             btnSignUp=(Button)findViewById(R.id.buttonSignUP);



            // Set OnClick Listener on SignUp button
             btnSignUp.setOnClickListener(new View.OnClickListener() {

                    public void onClick(View v) {
                        // TODO Auto-generated method stub

                        /// Create Intent for SignUpActivity abd Start The Activity
                        Intent intentSignUP=new Intent(getApplicationContext(),SignUPActivity.class);
                        startActivity(intentSignUP);
                    }
                });
    }


    // Methos to handleClick Event of Sign In Button
    public void signIn(View V)
       {

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

                dialog.setContentView(R.layout.login);
                dialog.setTitle("Login");

                // get the Refferences of views
                final EditText editTextUserName=(EditText)dialog.findViewById(R.id.editTextUserNameToLogin);
                final EditText editTextPassword=(EditText)dialog.findViewById(R.id.editTextPasswordToLogin);

                Button btnSignIn=(Button)dialog.findViewById(R.id.buttonSignIn);

                // Set On ClickListener
                btnSignIn.setOnClickListener(new View.OnClickListener() {

                    public void onClick(View v) {
                        // TODO Auto-generated method stub

                        // get The User name and Password
                        String userName=editTextUserName.getText().toString();
                        String password=editTextPassword.getText().toString();

                        // fetch the Password form database for respective user name
                        String storedPassword=loginDataBaseAdapter.getSinlgeEntry(userName);

                        // check if the Stored password matches with Password entered by user
                        if(password.equals(storedPassword))
                        {
                            Toast.makeText(HomeActivity.this, "Login Successfull", Toast.LENGTH_LONG).show();
                            dialog.dismiss();
                        }
                        else
                        {

                            Toast.makeText(HomeActivity.this, "User Name and Does Not Matches", Toast.LENGTH_LONG).show();
                        }

                    }
                });


                dialog.show();



    }

    @Override
    protected void onDestroy() {
        // TODO Auto-generated method stub
        super.onDestroy();

        // Close The Database
        loginDataBaseAdapter.close();
    }


}

2: SignUpActivity.java

public class SignUPActivity extends Activity
{

            EditText editTextUserName,editTextPassword,editTextConfirmPassword;
            Button btnCreateAccount;

            LoginDataBaseAdapter loginDataBaseAdapter;
            @Override
            protected void onCreate(Bundle savedInstanceState)
            {
                    super.onCreate(savedInstanceState);
                    setContentView(R.layout.signup);

                    // get Instance of Database Adapter
                    loginDataBaseAdapter=new LoginDataBaseAdapter(this);
                    loginDataBaseAdapter=loginDataBaseAdapter.open();

                    // Get Refferences of Views
                    editTextUserName=(EditText)findViewById(R.id.editTextUserName);
                    editTextPassword=(EditText)findViewById(R.id.editTextPassword);
                    editTextConfirmPassword=(EditText)findViewById(R.id.editTextConfirmPassword);

                    btnCreateAccount=(Button)findViewById(R.id.buttonCreateAccount);


                    btnCreateAccount.setOnClickListener(new View.OnClickListener() {

                        public void onClick(View v) {
                            // TODO Auto-generated method stub

                            String userName=editTextUserName.getText().toString();
                            String password=editTextPassword.getText().toString();
                            String confirmPassword=editTextConfirmPassword.getText().toString();

                            // check if any of the fields are vaccant
                            if(userName.equals("")||password.equals("")||confirmPassword.equals(""))
                            {
                                    Toast.makeText(getApplicationContext(), "Field Vaccant", Toast.LENGTH_LONG).show();
                                    return;
                            }
                            // check if both password matches
                            if(!password.equals(confirmPassword))
                            {
                                Toast.makeText(getApplicationContext(), "Password Does Not Matches", Toast.LENGTH_LONG).show();
                                return;
                            }
                            else
                            {
                                    // Save the Data in Database
                                    loginDataBaseAdapter.insertEntry(userName, password);
                                    Toast.makeText(getApplicationContext(), "Account Successfully Created ", Toast.LENGTH_LONG).show();
                            }


                        }
                    });
            }


            @Override
            protected void onDestroy() {
                // TODO Auto-generated method stub
                super.onDestroy();

                loginDataBaseAdapter.close();
            }

}

3: DataBaseHelper.java

package com.example.login;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DataBaseHelper extends SQLiteOpenHelper
{
    public DataBaseHelper(Context context, String name,CursorFactory factory, int version)
    {
               super(context, name, factory, version);
    }
    // Called when no database exists in disk and the helper class needs
    // to create a new one.
    @Override
    public void onCreate(SQLiteDatabase _db)
    {
            _db.execSQL(LoginDataBaseAdapter.DATABASE_CREATE);

    }
    // Called when there is a database version mismatch meaning that the version
    // of the database on disk needs to be upgraded to the current version.
    @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");


            // Upgrade the existing database to conform to the new version. Multiple
            // previous versions can be handled by comparing _oldVersion and _newVersion
            // values.
            // The simplest case is to drop the old table and create a new one.
            _db.execSQL("DROP TABLE IF EXISTS " + "TEMPLATE");
            // Create a new one.
            onCreate(_db);
    }


}

4: LoginDataBaseAdapter.java

public class LoginDataBaseAdapter
{
           static final String DATABASE_NAME = "login.db";

           static final int DATABASE_VERSION = 1;

           public static final int NAME_COLUMN = 1;
           // TODO: Create public field for each column in your table.
           // SQL Statement to create a new database.
           static final String DATABASE_CREATE = "create table "+"LOGIN"+
                                         "( " +"ID"+" integer primary key autoincrement,"+ "USERNAME text,PASSWORD text); ";

           // Variable to hold the database instance
           public SQLiteDatabase db;
           // Context of the application using the database.
           private final Context context;
           // Database open/upgrade helper
           private DataBaseHelper dbHelper;
           public LoginDataBaseAdapter(Context _context)
           {
                   context = _context;
                   dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
           }

   // Method to openthe Database
           public LoginDataBaseAdapter open() throws SQLException
           {
                   db = dbHelper.getWritableDatabase();
                   return this;
           }

            // Method to close the Database
           public void close()
           {
                   db.close();
           }

   // method returns an Instance of the Database
           public SQLiteDatabase getDatabaseInstance()
           {
                   return db;
           }

        // method to insert a record in Table
           public void insertEntry(String userName,String password)
           {


                       ContentValues newValues = new ContentValues();
                       // Assign values for each column.
                       newValues.put("USERNAME", userName);
                       newValues.put("PASSWORD",password);



                       // Insert the row into your table
                       db.insert("LOGIN", null, newValues);
                        Toast.makeText(context, "User Info Saved", Toast.LENGTH_LONG).show();


           }

           // method to delete a Record of UserName
           public int deleteEntry(String UserName)
           {

               String where="USERNAME=?";
                   int numberOFEntriesDeleted= db.delete("LOGIN", where, new String[]{UserName}) ;
                   Toast.makeText(context, "Number fo Entry Deleted Successfully : "+numberOFEntriesDeleted, Toast.LENGTH_LONG).show();
                return numberOFEntriesDeleted;

           }

       // method to get the password of userName
       public String getSinlgeEntry(String userName)
       {


               Cursor cursor=db.query("LOGIN", null, " USERNAME=?", new String[]{userName}, null, null, null);
                if(cursor.getCount()<1) // UserName Not Exist
                   return "NOT EXIST";
                cursor.moveToFirst();
               String password= cursor.getString(cursor.getColumnIndex("PASSWORD"));
               return password;


       }

   // Method to Update an Existing Record
       public void updateEntry(String userName,String password)
       {
               // create object of ContentValues
               ContentValues updatedValues = new ContentValues();
               // Assign values for each Column.
               updatedValues.put("USERNAME", userName);
               updatedValues.put("PASSWORD",password);

                String where="USERNAME = ?";
                db.update("LOGIN",updatedValues, where, new String[]{userName});

       }


}

Advance Android Topics

                 Customizing Toast In Android
   Showing Toast for Longer Time
   Customizing the Display Time of Toast
                   Using TimePickerDialog and DatePickerDialog In android
   Animating A Button In Android
Populating ListView With DataBase

  Customizing Checkboxes In Android
Increasin Size of Checkboxes
                    Android ProgressBar
  Designing For Different Screen Sizes
                    Handling Keyboard Events

Android : Introduction

Eclipse Setup for Android Development

Configuring Eclipse for Android Development

Begging With Android

Creating Your First Android Project
Understanding Android Manifest File of your android app

Working With Layouts

  Understanding Layouts in Android
  Working with Linear Layout (With Example)
  Nested Linear Layout (With Example)
  Table Layout
  Frame Layout(With Example)
Absolute Layout
Grid Layout

Activity

Activity In Android
Activity Life Cycle
Starting Activity For Result
Sending Data from One Activity to Other in Android
Returning Result from Activity

Working With Views

Using Buttons and EditText in Android
Using CheckBoxes in Android
Using AutoCompleteTextView in Android
Grid View

Toast

               Customizing Toast In Android
                     Customizing the Display Time of Toast
                     Customizing Toast At Runtime
                     Adding Image in Toast
                     Showing Toast for Longer Time

Dialogs In Android

Working With Alert Dialog
   Adding Radio Buttons In Dialog
   Adding Check Boxes In Dialog
   Creating Customized Dialogs in Android
  Adding EditText in Dialog

Creating Dialog To Collect User Input

DatePicker and TimePickerDialog

Using TimePickerDialog and DatePickerDialog In android

Working With SMS

      How to Send SMS in Android
  How To Receive SMS
  Accessing Inbox In Android

ListView:

Populating ListView With DataBase

Menus In Android

Creating Option Menu
Creating Context Menu In Android

TelephonyManager

Using Telephony Manager In Android

Working With Incoming Calls

How To Handle Incoming Calls in Android
How to Forward an Incoming Call In Android
CALL States In Android

Miscellaneous

Notifications In Android
How To Vibrate The Android Phone
Sending Email In Android
Opening a webpage In Browser
How to Access PhoneBook In Android
Prompt User Input with an AlertDialog

Storage: Storing Data In Android

Shared Prefferences In Android

SharedPreferences In Android

Files: File Handling In Android

Reading and Writing files to Internal Stoarage
Reading and Writing files to SD Card

DataBase : Working With Database

Working With Database in Android
Creating Table In Android
Inserting, Deleting and Updating Records In Table in Android
How to Create DataBase in Android
Accessing Inbox In Android

Animation In Android:

Animating A Button In Android

Friday, March 8, 2013

Inserting, Deleting and Updating Records In Table in Android

In this Post I will discuss about creating your own database and writing functions for Insertion, Deletion and Updation of Data in Table.

DataBaseHelper:

We will use SQLiteOpenHelper class and extend this class
and overside the methods onCreate, onUpgrade

public class DataBaseHelper extends SQLiteOpenHelper
{
            public DataBaseHelper (Context context, String name,CursorFactory factory, int version)
            {
                       super(context, name, factory, version);
            }
            // Called when no database exists in disk and the helper class needs
            // to create a new one.
            @Override
            public void onCreate(SQLiteDatabase _db)
            {
                     // statement to create the Table
                    _db.execSQL(SMSBlockerDataBaseAdapter.DATABASE_CREATE);

            }
            // Called when there is a database version mismatch meaning that the version
            // of the database on disk needs to be upgraded to the current version.
            @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");


                    // Upgrade the existing database to conform to the new version. Multiple
                    // previous versions can be handled by comparing _oldVersion and _newVersion
                    // values.
                    // The simplest case is to drop the old table and create a new one.
                    _db.execSQL("DROP TABLE IF EXISTS " + "SMSTABLE");
                    // Create a new one.
                    onCreate(_db);
            }

}

SMSBlockerDataBaseAdapter

We create a DataBaseAdpater class and write the functions for following tasks

to Open the database
to close the database
to insert a new Row/Record in Database
to delete one or more Records in Database
to update the database

In the example Code given below I have created a Table to store SMSes with following Columns

Id: Primary Key of the Table
Sender Name: Name of SMS Sender
Sender Number: Phone Number of the Sender
Time: date and time (In Miliseconds) at which SMS is received

Inserting a new Record in table

To Insert a new Record in Table we need to create an Object of ContentValues class and put the Values in this like:

ContentValues newValues = new ContentValues();
                // Assign values for each row.
                newValues.put("COLUMN_NAME1", values);
              newValues.put("COLUMN_NAME2", values);

            and so on
then

// Insert the row into your table
                db.insert("TABLENAME", null, newValues);

Deleting a Record from Table

we can delete a row from the Table with delete method
delete("TABLE ANME",String where, String[] valuesForWhere)

for Ex:
String where="ID=?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{ID}) ;

will delete the Record containing IDs in new String[]{ID} array.

To get All the Record in the Table

public Cursor getAllEntries ()
       {

               return db.query("BLOCKEDSMSTABLE", null,null, null, null, null, "TIME DESC");
       }

TIME DESC    will fetch in descending order of Time , Pass null to fetch in Ascending Order because by Deafault it fetches in ascending Order

To get 1 or more records depending on Some Condition

Task task=new Task();
               Cursor cursor=db.query("BLOCKEDSMSTABLE", null, " ID=?", new String[]{ID}, null, null, null);

"ID=?"       at RunTime ? will be replaced by string in the Array OF String passed as 4th parameter
the above query will fetch all the records containing the IDs in String Array(4th parameter)

Updating The Table

Updating is little similar to Inserting a record in Table
to update the table we need to create an Object of ContentValues and put the new Values in ContentValues object

ContentValues updatedValues = new ContentValues();
                // Assign new values for each row.

                updatedValues.put("TIME", taskToBeUpdated.time);
                updatedValues.put("MESSAGE",taskToBeUpdated.message);
                updatedValues.put("RECIPIENTNUMBER",taskToBeUpdated.recipientNumber);
                updatedValues.put("RECIPIENTNAME", taskToBeUpdated.recipientName);


                String where="ID = ?";
                db.update("SMSTABLE",updatedValues, where, new String[]{ID});

You can Modify the where variable as per your requirement like where "EMP_ID=" etc.

How to use this DataBaseAdapter Class in Activities

Create an Instance of DataBaseAdapter
Open the DataAbse
Call the Functions/Methods

See The Code :

SMSSchedulerDataBaseAdapter smsSchedulerDataBaseAdapter =new SMSSchedulerDataBaseAdapter(this);
smsSchedulerDataBaseAdapter=smsSchedulerDataBaseAdapter.open();
smsSchedulerDataBaseAdapter.insertEntry(yourParameter);
smsSchedulerDataBaseAdapter.getAllEntries();

The Complete Code :

public class SMSBlockerDataBaseAdapter
{
         // Name of the database
        static final String DATABASE_NAME = "SMSBLOCKERDATABASE.db";

// database version if creating first time it should be 1
        static final int DATABASE_VERSION = 1;

        public static final int NAME_COLUMN = 1;
        // TODO: Create public field for each column in your table.
        // SQL Statement to create a new database.
        static final String DATABASE_CREATE = "create table BLOCKEDSMSTABLE " +
                                         "( " +"ID integer primary key autoincrement,MESSAGE text, SENDERNUMBER text, SENDERNAME text, TIME integer ); ";

        // Variable to hold the database instance
        public SQLiteDatabase db;
        // Context of the application using the database.
        private final Context context;
        // Database open/upgrade helper
        private DataBaseHelper dbHelper;

        public SMSBlockerDataBaseAdapter(Context _context)
        {
                context = _context;
                dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

          // Open the Database
        public SMSBlockerDataBaseAdapter open() throws SQLException
        {
                db = dbHelper.getWritableDatabase();
                return this;
        }

   // Close the Database
        public void close()
        {
                db.close();
        }

        public SQLiteDatabase getDatabaseInstance()
        {
                return db;
        }

    // to Insert A record in Table
        public void insertEntry(Task taskToInsert)
        {
                // TODO: Create a new ContentValues to represent the row
                // and insert it into the database.
                ContentValues newValues = new ContentValues();
                // Assign values for each row.
                newValues.put("MESSAGE", taskToInsert.message);
                newValues.put("SENDERNUMBER",taskToInsert.senderNumber);
                newValues.put("SENDERNAME", taskToInsert.senderName);
                newValues.put("TIME",taskToInsert.time);


                // Insert the row into your table
                db.insert("BLOCKEDSMSTABLE", null, newValues);


        }
        public int deleteEntry(String ID)
        {


                String where="ID=?";
                int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{ID}) ;

                return numberOFEntriesDeleted;

        }

        public void deleteOlderEntries()
        {
                  String olderTime=String.valueOf(new GregorianCalendar().getTimeInMillis()-7*24*60*60*1000);
                  String where="TIME < ?";
                  int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{olderTime}) ;
                  Toast.makeText(context, "Number Of Entries Deleted "+numberOFEntriesDeleted, Toast.LENGTH_LONG).show();
        }
        public Cursor getAllEntries ()
        {

                return db.query("BLOCKEDSMSTABLE", null,null, null, null, null, "TIME DESC");
        }

        public Task getSinlgeEntry(String ID)
        {

                Task task=new Task();
                Cursor cursor=db.query("BLOCKEDSMSTABLE", null, " ID=?", new String[]{ID}, null, null, null);
                if(cursor.getCount()==0)
                {

                    return null;
                }
                cursor.moveToFirst();
                task.id= cursor.getString(cursor.getColumnIndex("ID"));
                task.message = cursor.getString(cursor.getColumnIndex("MESSAGE"));
                task.senderNumber = cursor.getString(cursor.getColumnIndex("SENDERNUMBER"));
                task.senderName = cursor.getString(cursor.getColumnIndex("SENDERNAME"));
                task.time = Long.parseLong(cursor.getString(cursor.getColumnIndex("TIME")));
                task.reason=cursor.getString(cursor.getColumnIndex("REASON"));
                //Log.i("getSingle Entry ID: "+"PhoneNumber "+task.senderName+" "+task.message,ID);
                cursor.close();
                return task;
        }
}

Creating Table In Android