Contact.java
--------------
package com.mangium.databaseoperation;
public class Contact {
 String id;
 String name;
 String phone;
 public Contact() {
  super();
 }
 public Contact(String id, String name, String phone) {
  super();
  this.id = id;
  this.name = name;
  this.phone = phone;
 }
 public String getId() {
  return id;
 }
 public void setId(String id) {
  this.id = id;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getPhone() {
  return phone;
 }
 public void setPhone(String phone) {
  this.phone = phone;
 }
 
}
DatabaseHandler.java
-------------------------
package com.mangium.databaseoperation;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import android.widget.Toast;
public class DatabaseHandler extends SQLiteOpenHelper{
 private static final int DATABASE_VERSION = 1;     
    private static final String DATABASE_NAME = "mydb";   
    static final String TABLE_CONTACTS = "contacts";
    private static final String KEY_ID = "id";
    private static final String KEY_NAME = "name";
    private static final String KEY_PH_NO = "phone";
 public DatabaseHandler(Context context) {
  super(context, DATABASE_NAME, null, DATABASE_VERSION);
  
 }
 @Override
 public void onCreate(SQLiteDatabase db) {
  String STUDENT_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
                + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
                + KEY_PH_NO + " TEXT" + ")";
          db.execSQL(STUDENT_CONTACTS_TABLE);
  
 }
 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);        
        onCreate(db);  
 }
  public void addContact(Contact contact) {
  
         SQLiteDatabase db = this.getWritableDatabase();  
         ContentValues val = new ContentValues();            
   val.put("ID", contact.getId());
   val.put("NAME", contact.getName());
   val.put("PHONE", contact.getPhone());        
         db.insert(TABLE_CONTACTS, null, val);
         db.close();
     }
  public void getContact(String id) {
  
      SQLiteDatabase db = this.getReadableDatabase();        
      Cursor cur = db.query(TABLE_CONTACTS, null, null, null, null, null, null);
      while(cur.moveToNext()){
        try{
         String val=cur.getString(0);
         if(val.equals(id)){
                            
          try{
           
           String name=cur.getString(1);
           String phone=cur.getString(2);
           Show_home.tv1.setText(name);
           Show_home.tv2.setText(phone);
           
          }catch(Exception e){
           e.printStackTrace();
          }
          
          db.close();
         }
        }catch (Exception e){
         e.printStackTrace();
        }
       
      }
      
      cur.close();
  }
  
  public void deleteContact(String id){
   SQLiteDatabase db = this.getWritableDatabase();
   String where=KEY_ID+"=?";
   String[]whereArgs=new String[]{id};
   db.delete(TABLE_CONTACTS, where, whereArgs);
   db.close();
  
  }
  public void updateContact(String id){
   SQLiteDatabase db = this.getWritableDatabase();
   String where=KEY_ID+"=?";
   String[]whereArgs=new String[]{id};
   /*Update.editText1.setText(Show_home.tv1.getText());
   Update.editText2.setText(Show_home.tv2.getText());*/
   ContentValues val=new ContentValues();   
   val.put("NAMe", Update.editText1.getText().toString());
   val.put("PHONE", Update.editText2.getText().toString());
   db.update(TABLE_CONTACTS, val, where, whereArgs);
   
  }
 
}
 
MainActivity.java
-------------------
package com.mangium.databaseoperation;
import android.os.Bundle;
import android.app.Activity;
import android.content.Intent;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class MainActivity extends Activity {
static EditText ed1;
static EditText ed2;
static EditText ed3;
Button insert_btn, show_btn;
String str1,str2,str3;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  ed1=(EditText) findViewById(R.id.editText1);
  ed2=(EditText) findViewById(R.id.editText2);
  ed3=(EditText) findViewById(R.id.editText3);
  insert_btn=(Button) findViewById(R.id.insertbtn);
  show_btn=(Button) findViewById(R.id.showbtn);
  insert_btn.setOnClickListener(new OnClickListener() {
   
  @Override
   public void onClick(View v) {
  
    DatabaseHandler db = new DatabaseHandler(getApplicationContext());
    String id=ed1.getText().toString();
    String nm=ed2.getText().toString();
    String ph=ed3.getText().toString();
    Contact contact=new Contact(id,nm,ph);
    db.addContact(contact);
     ed2.setText(null);
     ed3.setText(null);
     ed1.requestFocus();
     ed1.setSelectAllOnFocus(true);
     Toast.makeText(getApplicationContext(), "Record inserted successfully..", Toast.LENGTH_SHORT).show();
     
   }
  });
  show_btn.setOnClickListener(new OnClickListener() {
   @Override
   public void onClick(View v) {
    Intent i=new Intent(getApplicationContext(),Show_home.class);
    startActivity(i);
   }
  });
  
 }
 @Override
 public boolean onCreateOptionsMenu(Menu menu) {
  // Inflate the menu; this adds items to the action bar if it is present.
  getMenuInflater().inflate(R.menu.main, menu);
  return true;
 }
}
 
Show_home.java
-------------------
package com.mangium.databaseoperation;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
public class Show_home extends Activity{
 static EditText ed1;
 static TextView tv1,tv2;
 
 Button searchbtn,delbtn,updatebtn;
 String str;
 
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.show_home);
  ed1=(EditText) findViewById(R.id.editText);
  searchbtn=(Button) findViewById(R.id.okbtn);
  tv1=(TextView) findViewById(R.id.nameView);
  tv2=(TextView) findViewById(R.id.phoenView);
  delbtn=(Button) findViewById(R.id.delbutton);
  updatebtn=(Button) findViewById(R.id.updatebutton);
  searchbtn.setOnClickListener(new OnClickListener() {
   
   @Override
   public void onClick(View v) {
    DatabaseHandler db = new DatabaseHandler(getApplicationContext()); 
    
    db.getContact(ed1.getText().toString());
    ed1.requestFocus();
    ed1.setSelectAllOnFocus(true);
    Toast.makeText(getApplicationContext(), "SUCCESS...!!!", Toast.LENGTH_SHORT).show();
   }
  });
  delbtn.setOnClickListener(new OnClickListener() {
   
   @Override
   public void onClick(View v) {
    DatabaseHandler db = new DatabaseHandler(getApplicationContext());
   db.deleteContact(ed1.getText().toString());
   Toast.makeText(getApplicationContext(), "Record Deleted...with ID="+ed1.getText().toString(), Toast.LENGTH_SHORT).show();
   tv1.setText("null");
   tv2.setText("null");
   }
  });
  updatebtn.setOnClickListener(new OnClickListener() {
   
   @Override
   public void onClick(View v) {
    Intent i=new Intent(getApplicationContext(),Update.class);
    startActivity(i);
    
   }
  });
 }
}
 
Update.java
------------------
package com.mangium.databaseoperation;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class Update extends Activity {
 Button updatebutton;
 static EditText editText1,editText2;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.update);
  editText1=(EditText) findViewById(R.id.updatenmText);
  editText2=(EditText) findViewById(R.id.updatephText);
  updatebutton=(Button) findViewById(R.id.updatebutton1);
  editText1.setText(Show_home.tv1.getText());
  editText2.setText(Show_home.tv2.getText());
  updatebutton.setOnClickListener(new OnClickListener() {
   
   @Override
   public void onClick(View v) {
    DatabaseHandler db = new DatabaseHandler(getApplicationContext());
    db.updateContact(Show_home.ed1.getText().toString());    
    Toast.makeText(getApplicationContext(), "Record updated successfully", Toast.LENGTH_SHORT).show();
    Intent intent=new Intent(getApplicationContext(),Show_home.class);
    
    startActivity(intent);
    
   }
  });
 }
}
 
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:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context=".MainActivity" >
    <EditText
        android:id="@+id/editText1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginTop="63dp"
        android:ems="10"
        android:hint="Enter Student id"
        android:selectAllOnFocus="true" 
        android:inputType="number"/>
    <requestFocus />
    <EditText
        android:id="@+id/editText2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/editText1"
        android:layout_below="@+id/editText1"
        android:layout_marginTop="17dp"
        android:ems="10"
        android:hint="Enter Student Name" >
    </EditText>
    <EditText
        android:id="@+id/editText3"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/editText2"
        android:layout_below="@+id/editText2"
        android:layout_marginTop="18dp"
        android:ems="10"
        android:hint="Enter Student Phone" 
        android:inputType="number"/>
    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:gravity="center"
        android:text="@string/head_title"
        android:textSize="18sp" />
    <LinearLayout
        android:id="@+id/LinearLayout1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/editText3"
        android:layout_below="@+id/editText3"
        android:layout_marginTop="88dp"
        android:orientation="horizontal" >
        <Button
            android:id="@+id/showbtn"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Search" />
        <Button
            android:id="@+id/insertbtn"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Insert" />
    </LinearLayout>
</RelativeLayout>
 
show_home.xml
------------------
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/RelativeLayout1"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >
    <EditText
        android:id="@+id/editText"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginTop="40sp"
        android:ems="10"
        android:hint="Enter Student Id" 
        android:selectAllOnFocus="true"/>
  
 
<requestFocus />
    <TextView
        android:id="@+id/phoenView"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/textView2"
        android:layout_alignBottom="@+id/textView2"
        android:layout_alignLeft="@+id/nameView"
        android:text="null"
        android:textAppearance="?android:attr/textAppearanceMedium" />
    <TextView
        android:id="@+id/textView2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/textView1"
        android:layout_marginTop="22dp"
        android:text="Phone"
        android:textAppearance="?android:attr/textAppearanceMedium" />
    <Button
        android:id="@+id/okbtn"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentRight="true"
        android:layout_below="@+id/editText"
        android:layout_marginTop="16dp"
        android:text="Search" />
    <TextView
        android:id="@+id/textView3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:text="@string/search_info" 
        android:textSize="18sp"/>
    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignRight="@+id/textView2"
        android:layout_below="@+id/okbtn"
        android:layout_marginTop="34dp"
        android:text="Name"
        android:textAppearance="?android:attr/textAppearanceMedium" />
    <Button
        android:id="@+id/updatebutton"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/phoenView"
        android:layout_marginTop="30dp"
        android:text="Update" />
    <TextView
        android:id="@+id/nameView"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/textView2"
        android:layout_marginLeft="22dp"
        android:layout_toRightOf="@+id/textView1"
        android:text="null"
        android:textAppearance="?android:attr/textAppearanceMedium" />
    <Button
        android:id="@+id/delbutton"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/updatebutton"
        android:text="Delete" />
</RelativeLayout>
 
update.xml
--------------
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/RelativeLayout1"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >
    <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="15dp"
        android:text="@string/update_record" 
        android:textSize="18sp"/>
    <EditText
        android:id="@+id/updatenmText"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/textView1"
        android:layout_below="@+id/textView1"
        android:layout_marginTop="22dp"
        android:ems="10"
        android:hint="Enter new Name" />
    <EditText
        android:id="@+id/updatephText"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/updatenmText"
        android:layout_below="@+id/updatenmText"
        android:layout_marginTop="15dp"
        android:ems="10"
        android:hint="Enter new Phone"
        android:inputType="number" />
    <TextView
        android:id="@+id/textView2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/updatenmText"
        android:layout_alignBottom="@+id/updatenmText"
        android:layout_alignParentLeft="true"
        android:text="Name" 
        android:layout_marginLeft="10dp"
        android:textSize="16sp"/>
    <TextView
        android:id="@+id/textView3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/updatephText"
        android:layout_alignBottom="@+id/updatephText"
        android:layout_alignParentLeft="true"
        android:text="Phone" 
        android:layout_marginLeft="10dp"
        android:textSize="16sp"/>
    <Button
        android:id="@+id/updatebutton1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/updatephText"
        android:layout_marginTop="33dp"
        android:text="Update" />
</RelativeLayout>
 
strings.xml
-------------
<?xml version="1.0" encoding="utf-8"?>
<resources>
    <string name="app_name">DatabaseOperation</string>
    <string name="action_settings">Settings</string>
    <string name="hello_world">Hello world!</string>
 <string name="head_title"><u>Student Information</u></string>
 <string name="search_info"><u>Search Results</u></string>
 <string name="update_record"><u>Update Records</u></string>
</resources>
 
AndroidManifest.xml
----------------------
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.mangium.databaseoperation"
    android:versionCode="1"
    android:versionName="1.0" >
    <uses-sdk
        android:minSdkVersion="8"
        android:targetSdkVersion="18" />
    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name="com.mangium.databaseoperation.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="Show_home"></activity>
        <activity android:name="Update"></activity>
    </application>
</manifest>