Dynamics of Android: SQLite CURD Operation

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"/>

<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"/>

<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"?>

<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>

</intent-filter>

</activity>

</application>

</manifest>

Dynamics of Android

Page

Tuesday, October 8, 2013

SQLite CURD Operation

No comments:

Post a Comment