Programming Articles.: Android

This article explains Sqlite database connectivity in Android.We will see basic operations in a database.
Step 1 : How to create a database

---------------------------------------------

first import the Sqlite databse class

import android.database.sqlite.SQLiteDatabase;
SQLiteDatabase db;
                try
        {
            db = openOrCreateDatabase("Data", SQLiteDatabase.CREATE_IF_NECESSARY,null);
            db.execSQL("CREATE TABLE Data(Name VARCHAR(20),PhoneNo VARCHAR(20),Address VARCHAR(50),State                                                VARCHAR(20))");
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
    }

next i am adding Data java class that hold the data for insertion.
Data.java

-------------

public class Data {
   private String _name;
    private String _phoneNo;
    private String _address;
    private String _state;
    public String get_name() {
        return _name;
    }
    public void set_name(String _name) {
        this._name = _name;
    }
    public String get_phoneNo() {
        return _phoneNo;
    }
    public void set_phoneNo(String _phoneNo) {
        this._phoneNo = _phoneNo;
    }
    public String get_address() {
        return _address;
    }
    public void set_address(String _address) {
        this._address = _address;
    }
    public String get_state() {
        return _state;
    }
    public void set_state(String _state) {
        this._state = _state;
    }
}

Step 2: Insert records into database

-------------------------------------------

I am getting data’s from text view and assigning that value to data class entity.

                TextView name;
                TextView phoneNo;
                TextView address;
                TextView state;
                name=(TextView)(findViewById(R.id.NameEditText));
                phoneNo=(TextView)(findViewById(R.id.PhoneNoEditText));
                address=(TextView)(findViewById(R.id.AddressEditText));
                state=(TextView)(findViewById(R.id.StateEditText));

             Data dataEntity=new Data();
            dataEntity.set_name(name.getText().toString().trim());
           dataEntity.set_phoneNo(phoneNo.getText().toString().trim());
            dataEntity.set_address(address.getText().toString().trim());
            dataEntity.set_state(state.getText().toString().trim());
            ContentValues values=new ContentValues();
            values.put("Name",dataEntity.get_name());
            values.put("PhoneNo",dataEntity.get_phoneNo());
            values.put("Address",dataEntity.get_address());
            values.put("State",dataEntity.get_state());
            if(db.insert("Data",null,values)!=-1)
            {
                Toast.makeText(getApplicationContext(), "Inserted Data", Toast.LENGTH_SHORT).show();
                     }
            else
            {
                Toast.makeText(getApplicationContext(),"Not Inserted Data",Toast.LENGTH_LONG).show();
            }

Step 3: select the data from database

----------------------------------------------

ArrayList<Data> mDataArrayList=new ArrayList<Data>();
                try
        {
            db = openOrCreateDatabase("Data", SQLiteDatabase.CREATE_IF_NECESSARY,null);
            Cursor c=db.rawQuery("SELECT * FROM Data",null);
            c.moveToFirst();
            while (!c.isAfterLast())
            {
                Data dataEntity=new Data();
                dataEntity.set_name(c.getString(1));
                dataEntity.set_phoneNo(c.getString(2));
                dataEntity.set_address(c.getString(3));
                dataEntity.set_state(c.getString(4));
                mDataArrayList.add(dataEntity);
                c.moveToNext();
            }
            c.close();
            db.close();
                }
                catch (Exception ex)
        {
            ex.printStackTrace();
        }

here mDataArrayList will return the all datas in table.

Programming Articles.

Friday, 28 June 2013

Basic Databse Operations in SqLite using in Android.