This tutorial is the third part of advance SQLite database example, In this tutorial we would going to execute simple basic operations on SQLite database like Add Data in SQLite database, Showing SQLite database data into custom ListView, Selecting SQLite Data on ListView click, Updating( Edit ) SQLite database data and Delete SQLite data. So here is the complete tutorial for Android SQLite Select Insert Update Delete Display Data Tutorial with Live demo and all the source code you need to learn this tutorial.
Also Read :
- Inserting Data into SQLite Database – SQLite Part 1 .
- Showing SQLite data into Custom Listview – SQLite Part 2 .
Android SQLite Select Insert Update Delete Display Data Project Description :
- Creating SQLite Database.
- Creating Table in SQLite Database.
- Inserting Records in SQLite DB table using EditText.
- Display all the SQLite Database Data in Custom ListView.
- Open any record on ListView click.
- Update(Edit) SQLite database single selected record using EditText.
- Delete Selected record on button click.
Project File Description :
List of Activity in this project:
- MainActivity.java
- DisplaySQLiteDataActivity.java
- ShowSingleRecordActivity.java
- EditSingleRecordActivity.java
List of layout files in this project:
- activity_main.xml
- activity_display_sqlite_data.xml
- activity_show_single_record.xml
- activity_edit_single_record.xml
- items.xml
List of Java Files in this project:
- SQLiteHelper.java
- ListAdapter.java
Watch Live Demo of this tutorial Android SQLite Select Insert Update Delete Display Data Tutorial :
Start Coding :
Code for MainActivity.java file.
package com.androidjson.sqlitepart_3_androidjsoncom; import android.content.Context; import android.content.Intent; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.text.TextUtils; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.Toast; public class MainActivity extends AppCompatActivity { SQLiteDatabase sqLiteDatabaseObj; EditText editTextName, editTextPhoneNumber; String NameHolder, NumberHolder, SQLiteDataBaseQueryHolder; Button EnterData, ButtonDisplayData; Boolean EditTextEmptyHold; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); EnterData = (Button)findViewById(R.id.button); ButtonDisplayData = (Button)findViewById(R.id.button2); editTextName = (EditText)findViewById(R.id.editText); editTextPhoneNumber = (EditText)findViewById(R.id.editText2); EnterData.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { SQLiteDataBaseBuild(); SQLiteTableBuild(); CheckEditTextStatus(); InsertDataIntoSQLiteDatabase(); EmptyEditTextAfterDataInsert(); } }); ButtonDisplayData.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { Intent intent = new Intent(MainActivity.this, DisplaySQLiteDataActivity.class); startActivity(intent); } }); } public void SQLiteDataBaseBuild(){ sqLiteDatabaseObj = openOrCreateDatabase(SQLiteHelper.DATABASE_NAME, Context.MODE_PRIVATE, null); } public void SQLiteTableBuild(){ sqLiteDatabaseObj.execSQL("CREATE TABLE IF NOT EXISTS "+SQLiteHelper.TABLE_NAME+"("+SQLiteHelper.Table_Column_ID+" PRIMARY KEY AUTOINCREMENT NOT NULL, "+SQLiteHelper.Table_Column_1_Name+" VARCHAR, "+SQLiteHelper.Table_Column_2_PhoneNumber+" VARCHAR);"); } public void CheckEditTextStatus(){ NameHolder = editTextName.getText().toString() ; NumberHolder = editTextPhoneNumber.getText().toString(); if(TextUtils.isEmpty(NameHolder) || TextUtils.isEmpty(NumberHolder)){ EditTextEmptyHold = false ; } else { EditTextEmptyHold = true ; } } public void InsertDataIntoSQLiteDatabase(){ if(EditTextEmptyHold == true) { SQLiteDataBaseQueryHolder = "INSERT INTO "+SQLiteHelper.TABLE_NAME+" (name,phone_number) VALUES('"+NameHolder+"', '"+NumberHolder+"');"; sqLiteDatabaseObj.execSQL(SQLiteDataBaseQueryHolder); sqLiteDatabaseObj.close(); Toast.makeText(MainActivity.this,"Data Inserted Successfully", Toast.LENGTH_LONG).show(); } else { Toast.makeText(MainActivity.this,"Please Fill All The Required Fields.", Toast.LENGTH_LONG).show(); } } public void EmptyEditTextAfterDataInsert(){ editTextName.getText().clear(); editTextPhoneNumber.getText().clear(); } }
Code for activity_main.xml layout file.
<?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:id="@+id/activity_main" 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="com.androidjson.sqlitepart_3_androidjsoncom.MainActivity"> <TextView android:text="SQLite Insert Into Database" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignParentTop="true" android:layout_centerHorizontal="true" android:id="@+id/textView" android:gravity="center" android:textSize="20dp" android:textColor="#000000"/> <EditText android:layout_width="fill_parent" android:layout_height="wrap_content" android:inputType="textPersonName" android:hint="Enter Name" android:ems="10" android:layout_marginTop="27dp" android:id="@+id/editText" android:layout_below="@+id/textView" android:layout_centerHorizontal="true" android:gravity="center"/> <EditText android:layout_width="fill_parent" android:layout_height="wrap_content" android:inputType="phone" android:hint="Enter Phone Number" android:gravity="center" android:ems="10" android:layout_below="@+id/editText" android:layout_centerHorizontal="true" android:layout_marginTop="37dp" android:id="@+id/editText2" /> <Button android:text="Insert Into SQLite Database" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_below="@+id/editText2" android:layout_centerHorizontal="true" android:layout_marginTop="46dp" android:id="@+id/button" /> <Button android:text="Display SQLite Database Data into ListView" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@+id/button" android:layout_centerHorizontal="true" android:layout_marginTop="11dp" android:id="@+id/button2" /> </RelativeLayout>
Code for DisplaySQLiteDataActivity.java file.
package com.androidjson.sqlitepart_3_androidjsoncom; import android.content.Intent; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import android.widget.ListView; import android.widget.Toast; import java.util.ArrayList; public class DisplaySQLiteDataActivity extends AppCompatActivity { SQLiteHelper sqLiteHelper; SQLiteDatabase sqLiteDatabase; Cursor cursor; ListAdapter listAdapter ; ListView LISTVIEW; ArrayList<String> ID_Array; ArrayList<String> NAME_Array; ArrayList<String> PHONE_NUMBER_Array; ArrayList<String> ListViewClickItemArray = new ArrayList<String>(); String TempHolder ; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_display_sqlite_data); LISTVIEW = (ListView) findViewById(R.id.listView1); ID_Array = new ArrayList<String>(); NAME_Array = new ArrayList<String>(); PHONE_NUMBER_Array = new ArrayList<String>(); sqLiteHelper = new SQLiteHelper(this); LISTVIEW.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { // TODO Auto-generated method stub Intent intent = new Intent(getApplicationContext(),ShowSingleRecordActivity.class); intent.putExtra("ListViewClickedItemValue", ListViewClickItemArray.get(position).toString()); startActivity(intent); } }); } @Override protected void onResume() { ShowSQLiteDBdata() ; super.onResume(); } private void ShowSQLiteDBdata() { sqLiteDatabase = sqLiteHelper.getWritableDatabase(); cursor = sqLiteDatabase.rawQuery("SELECT * FROM "+SQLiteHelper.TABLE_NAME+"", null); ID_Array.clear(); NAME_Array.clear(); PHONE_NUMBER_Array.clear(); if (cursor.moveToFirst()) { do { ID_Array.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_ID))); //Inserting Column ID into Array to Use at ListView Click Listener Method. ListViewClickItemArray.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_ID))); NAME_Array.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_1_Name))); PHONE_NUMBER_Array.add(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_2_PhoneNumber))); } while (cursor.moveToNext()); } listAdapter = new ListAdapter(DisplaySQLiteDataActivity.this, ID_Array, NAME_Array, PHONE_NUMBER_Array ); LISTVIEW.setAdapter(listAdapter); cursor.close(); } }
Code for activity_display_sqlite_data.xml layout file.
<?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:id="@+id/activity_display_sqlite_data" 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="com.androidjson.sqlitepart_3_androidjsoncom.DisplaySQLiteDataActivity"> <ListView android:id="@+id/listView1" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_alignParentTop="true" android:layout_centerHorizontal="true" > </ListView> </RelativeLayout>
Code for ShowSingleRecordActivity.java file.
package com.androidjson.sqlitepart_3_androidjsoncom; import android.content.Context; import android.content.Intent; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; public class ShowSingleRecordActivity extends AppCompatActivity { String IDholder; TextView id, name, phone_number; SQLiteDatabase sqLiteDatabase; SQLiteHelper sqLiteHelper; Cursor cursor; Button Delete, Edit; SQLiteDatabase sqLiteDatabaseObj; String SQLiteDataBaseQueryHolder ; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_show_single_record); id = (TextView) findViewById(R.id.textViewID); name = (TextView) findViewById(R.id.textViewName); phone_number = (TextView) findViewById(R.id.textViewPhoneNumber); Delete = (Button)findViewById(R.id.buttonDelete); Edit = (Button)findViewById(R.id.buttonEdit); sqLiteHelper = new SQLiteHelper(this); Delete.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { OpenSQLiteDataBase(); SQLiteDataBaseQueryHolder = "DELETE FROM "+SQLiteHelper.TABLE_NAME+" WHERE id = "+IDholder+""; sqLiteDatabase.execSQL(SQLiteDataBaseQueryHolder); sqLiteDatabase.close(); finish(); } }); Edit.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { Intent intent = new Intent(getApplicationContext(),EditSingleRecordActivity.class); intent.putExtra("EditID", IDholder); startActivity(intent); } }); } @Override protected void onResume() { ShowSingleRecordInTextView(); super.onResume(); } public void ShowSingleRecordInTextView() { sqLiteDatabase = sqLiteHelper.getWritableDatabase(); IDholder = getIntent().getStringExtra("ListViewClickedItemValue"); cursor = sqLiteDatabase.rawQuery("SELECT * FROM " + SQLiteHelper.TABLE_NAME + " WHERE id = " + IDholder + "", null); if (cursor.moveToFirst()) { do { id.setText(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_ID))); name.setText(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_1_Name))); phone_number.setText(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_2_PhoneNumber))); } while (cursor.moveToNext()); cursor.close(); } } public void OpenSQLiteDataBase(){ sqLiteDatabaseObj = openOrCreateDatabase(SQLiteHelper.DATABASE_NAME, Context.MODE_PRIVATE, null); } }
Code for activity_show_single_record.xml layout file.
<?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:id="@+id/activity_show_single_record" 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="com.androidjson.sqlitepart_3_androidjsoncom.ShowSingleRecordActivity"> <TextView android:text="ID = " android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignParentTop="true" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" android:id="@+id/textView1" android:textColor="#000000" android:textSize="20dp"/> <TextView android:text="Name = " android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@+id/textView1" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" android:layout_marginTop="40dp" android:id="@+id/textView2" android:textColor="#000000" android:textSize="20dp"/> <TextView android:text="PhoneNumber = " android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@+id/textView2" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" android:layout_marginTop="40dp" android:id="@+id/textView3" android:textColor="#000000" android:textSize="20dp"/> <TextView android:text="Id Show Here" android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/textViewID" android:textColor="#000000" android:textSize="20dp" android:layout_alignParentTop="true" android:layout_toRightOf="@+id/textView3" android:layout_toEndOf="@+id/textView3" /> <TextView android:text="Name Show Here" android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/textViewName" android:textColor="#000000" android:textSize="20dp" android:layout_above="@+id/textView3" android:layout_toRightOf="@+id/textView3" android:layout_toEndOf="@+id/textView3" /> <TextView android:text="Phone Number Here" android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/textViewPhoneNumber" android:textColor="#000000" android:textSize="20dp" android:layout_alignBaseline="@+id/textView3" android:layout_alignBottom="@+id/textView3" android:layout_toRightOf="@+id/textView3" android:layout_toEndOf="@+id/textView3" /> <Button android:text="Click Here To Edit This Record" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_centerVertical="true" android:layout_centerHorizontal="true" android:id="@+id/buttonEdit" /> <Button android:text="Click Here to Delete This Record" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_below="@+id/buttonEdit" android:layout_centerHorizontal="true" android:layout_marginTop="14dp" android:id="@+id/buttonDelete" /> </RelativeLayout>
Code for EditSingleRecordActivity.java file.
package com.androidjson.sqlitepart_3_androidjsoncom; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.Toast; public class EditSingleRecordActivity extends AppCompatActivity { EditText name, phone_number; Button update; SQLiteDatabase sqLiteDatabase; SQLiteHelper sqLiteHelper; Cursor cursor; String IDholder; String SQLiteDataBaseQueryHolder ; SQLiteDatabase sqLiteDatabaseObj; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_edit_single_record); name = (EditText) findViewById(R.id.EditTextName); phone_number = (EditText) findViewById(R.id.editText3); update = (Button) findViewById(R.id.buttonUpdate); sqLiteHelper = new SQLiteHelper(this); update.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View view) { String GetName = name.getText().toString(); String GetPhoneNumber = phone_number.getText().toString(); OpenSQLiteDataBase(); SQLiteDataBaseQueryHolder = "UPDATE " + SQLiteHelper.TABLE_NAME + " SET "+SQLiteHelper.Table_Column_1_Name+" = '"+GetName+"' , "+SQLiteHelper.Table_Column_2_PhoneNumber+" = '"+GetPhoneNumber+"' WHERE id = " + IDholder + ""; sqLiteDatabaseObj.execSQL(SQLiteDataBaseQueryHolder); sqLiteDatabase.close(); Toast.makeText(EditSingleRecordActivity.this,"Data Edit Successfully", Toast.LENGTH_LONG).show(); } }); } @Override protected void onResume() { ShowSRecordInEditText(); super.onResume(); } public void ShowSRecordInEditText() { sqLiteDatabase = sqLiteHelper.getWritableDatabase(); IDholder = getIntent().getStringExtra("EditID"); cursor = sqLiteDatabase.rawQuery("SELECT * FROM " + SQLiteHelper.TABLE_NAME + " WHERE id = " + IDholder + "", null); if (cursor.moveToFirst()) { do { name.setText(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_1_Name))); phone_number.setText(cursor.getString(cursor.getColumnIndex(SQLiteHelper.Table_Column_2_PhoneNumber))); } while (cursor.moveToNext()); cursor.close(); } } public void OpenSQLiteDataBase(){ sqLiteDatabaseObj = openOrCreateDatabase(SQLiteHelper.DATABASE_NAME, Context.MODE_PRIVATE, null); } }
Code for activity_edit_single_record.xml layout file.
<?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:id="@+id/activity_edit_single_record" 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="com.androidjson.sqlitepart_3_androidjsoncom.EditSingleRecordActivity"> <EditText android:layout_width="fill_parent" android:layout_height="wrap_content" android:inputType="textPersonName" android:ems="10" android:layout_alignParentTop="true" android:layout_centerHorizontal="true" android:gravity="center" android:hint="Name Show Here" android:layout_marginTop="50dp" android:id="@+id/EditTextName"/> <Button android:text="Update This Record" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_centerVertical="true" android:layout_centerHorizontal="true" android:id="@+id/buttonUpdate" /> <EditText android:layout_width="fill_parent" android:layout_height="wrap_content" android:inputType="textPersonName" android:ems="10" android:id="@+id/editText3" android:gravity="center" android:hint="PhoneNumber Show Here" android:layout_below="@+id/EditTextName" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" android:layout_marginTop="31dp" /> </RelativeLayout>
Code for items.xml layout file.
<?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"> <TextView android:id="@+id/textView1" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignParentLeft="true" android:layout_alignParentTop="true" android:text="ID = " android:textAppearance="?android:attr/textAppearanceMedium" android:textColor="#050505" /> <TextView android:id="@+id/textViewID" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignBaseline="@+id/textView1" android:layout_alignBottom="@+id/textView1" android:layout_toRightOf="@+id/textView1" android:text="UserID" android:textAppearance="?android:attr/textAppearanceMedium" android:textColor="#050505" /> <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:text="Name = " android:textAppearance="?android:attr/textAppearanceMedium" android:textColor="#050505" /> <TextView android:id="@+id/textViewNAME" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_below="@+id/textViewID" android:layout_toRightOf="@+id/textView2" android:text="Name" android:textAppearance="?android:attr/textAppearanceMedium" android:textColor="#050505" /> <TextView android:id="@+id/textView3" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignParentLeft="true" android:layout_below="@+id/textView2" android:text="Phone Number = " android:textAppearance="?android:attr/textAppearanceMedium" android:textColor="#050505" /> <TextView android:id="@+id/textViewPHONE_NUMBER" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_alignBottom="@+id/textView3" android:layout_toRightOf="@+id/textView3" android:text="phone number" android:textAppearance="?android:attr/textAppearanceMedium" android:textColor="#050505" /> </RelativeLayout>
Code for SQLiteHelper.java file.
package com.androidjson.sqlitepart_3_androidjsoncom; /** * Created by Juned on 1/23/2017. */ import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class SQLiteHelper extends SQLiteOpenHelper { static String DATABASE_NAME="AndroidJSonDataBase"; public static final String TABLE_NAME="AndroidJSonTable"; public static final String Table_Column_ID="id"; public static final String Table_Column_1_Name="name"; public static final String Table_Column_2_PhoneNumber="phone_number"; public SQLiteHelper(Context context) { super(context, DATABASE_NAME, null, 1); } @Override public void onCreate(SQLiteDatabase database) { String CREATE_TABLE="CREATE TABLE IF NOT EXISTS "+TABLE_NAME+" ("+Table_Column_ID+" INTEGER PRIMARY KEY, "+Table_Column_1_Name+" VARCHAR, "+Table_Column_2_PhoneNumber+" VARCHAR)"; database.execSQL(CREATE_TABLE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME); onCreate(db); } }
Code for ListAdapter.java file.
package com.androidjson.sqlitepart_3_androidjsoncom; /** * Created by Juned on 1/23/2017. */ import android.content.Context; import android.view.LayoutInflater; import android.view.View; import android.view.ViewGroup; import android.widget.BaseAdapter; import android.widget.TextView; import java.util.ArrayList; public class ListAdapter extends BaseAdapter { Context context; ArrayList<String> ID; ArrayList<String> Name; ArrayList<String> PhoneNumber; public ListAdapter( Context context2, ArrayList<String> id, ArrayList<String> name, ArrayList<String> phone ) { this.context = context2; this.ID = id; this.Name = name; this.PhoneNumber = phone; } public int getCount() { // TODO Auto-generated method stub return ID.size(); } public Object getItem(int position) { // TODO Auto-generated method stub return null; } public long getItemId(int position) { // TODO Auto-generated method stub return 0; } public View getView(int position, View child, ViewGroup parent) { Holder holder; LayoutInflater layoutInflater; if (child == null) { layoutInflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE); child = layoutInflater.inflate(R.layout.items, null); holder = new Holder(); holder.ID_TextView = (TextView) child.findViewById(R.id.textViewID); holder.Name_TextView = (TextView) child.findViewById(R.id.textViewNAME); holder.PhoneNumberTextView = (TextView) child.findViewById(R.id.textViewPHONE_NUMBER); child.setTag(holder); } else { holder = (Holder) child.getTag(); } holder.ID_TextView.setText(ID.get(position)); holder.Name_TextView.setText(Name.get(position)); holder.PhoneNumberTextView.setText(PhoneNumber.get(position)); return child; } public class Holder { TextView ID_TextView; TextView Name_TextView; TextView PhoneNumberTextView; } }
Screenshots:
Nice Man ! Code is very nice but i dont know how to implement this code
Zaima just create a new project and create new activities like i did and place all the code there.