List View Example With Storing into the Database(SQLite) in Android

List View Example With Storing into the Database(SQLite) in Android

ListViews are Views which allow to display a list of elements. ListActivities  are specialized Activities which make the usage of ListViews easier. To work with databases and ListViews you can use the SimpleCursorAdapter. The SimpleCursorAdapter allows to set a layout for each row of the ListViews. You also define an array which contains the column names and another array which contains the IDs ofViews which should be filled with the data. The SimpleCursorAdapter class will map the columns to the Views based on the Cursor passed to it.

In this example, Store the data into the database and the stored data you can see in the list view. Here I used SQLite Database. The data will store into the SQLite database and after inserting the data you can see the value in list view.

Before going to program, I need to explain about the program. In this program , You can store a person’s name, location and his/her salary. After inserting the details, you can see the details in list view. The design of main.xml will look like this:

main.xml

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:layout_width="fill_parent"

    android:layout_height="fill_parent"

    android:orientation="vertical" >

    <TextView

        android:layout_width="fill_parent"

        android:layout_height="wrap_content"

        android:text="Database Example" />

    <EditText

        android:id="@+id/editText1"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:hint="Name">

        <requestFocus />

    </EditText>

    <EditText

        android:id="@+id/editText2"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:hint="location" />

    <EditText

        android:id="@+id/editText3"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:hint="Salary"/>

    <Button

        android:id="@+id/button1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="Insert" />

    <ListView

        android:id="@+id/listView1"

        android:layout_width="match_parent"

        android:layout_height="wrap_content" >

    </ListView>

</LinearLayout>

Database File :  MyDatabase.java

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;

public class MyDatabase

{

            public static final String MY_DB2 = "testdb3";

            MyHelper mh;

            Context myCon;

            SQLiteDatabase sdb;

            public MyDatabase(Context c)

            {

                        myCon = c;

                        mh = new MyHelper(myCon, MY_DB2, null, 1);

            }

            public void open()

            {

                        sdb = mh.getWritableDatabase();

            }

            public class MyHelper extends SQLiteOpenHelper

            {

                        public MyHelper(Context context, String name, CursorFactory factory,

                                                int version) {

                                    super(context, name, factory, version);

                                    // TODO Auto-generated constructor stub

                        }

                        @Override

                        public void onCreate(SQLiteDatabase db)

                        {

                                    db.execSQL("create table emp(_id integer primary key, ename text,elocation text,esal integer);");

                                    Log.d("1", "Table Created");

                        }

                        @Override

                        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

                                    // TODO Auto-generated method stub

                                   

                        }

                       

            }

            public void empInsert(ContentValues cv)

            {

                        sdb.insert("emp", null, cv);

            }

            public Cursor getEmp()

            {

                        Cursor c = sdb.query("emp", null, null, null, null, null, null);

                        return c;

            }

}

Home.java

import android.app.Activity;

import android.content.ContentValues;

import android.database.Cursor;

import android.os.Bundle;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.EditText;

import android.widget.ListView;

import android.widget.SimpleCursorAdapter;

public class Home extends Activity

{

            MyDatabase mdb = new MyDatabase(this);

            Cursor c;

            public void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.main);

       

        final ListView lv = (ListView)findViewById(R.id.listView1);

       

        final SimpleCursorAdapter sca;

        Button btn1 = (Button)findViewById(R.id.button1);

       

        final EditText name = (EditText)findViewById(R.id.editText1);

        final EditText location = (EditText)findViewById(R.id.editText2);

        final EditText salary = (EditText)findViewById(R.id.editText3);

        mdb.open();

        btn1.setOnClickListener(new OnClickListener()

        {

                                   

                                    public void onClick(View v)

                                    {

                                                String ename = name.getText().toString();

                                                String eloc = location.getText().toString();

                                                Integer esal = Integer.parseInt(salary.getText().toString());

                                                ContentValues cv = new ContentValues();

                                                cv.put("ename", ename);

                                                cv.put("elocation", eloc);

                                                cv.put("esal", esal);

                                                mdb.empInsert(cv);

                                                name.setText(" ");

                                                location.setText(" ");

                                                salary.setText(" ");

                                                c.requery(); 

                                    }

                        });

       

                        c = mdb.getEmp();

                        String []from = {"ename","elocation","esal"};

                        int []to = {R.id.textView1,R.id.textView3,R.id.textView2};

                        sca = new SimpleCursorAdapter(this, R.layout.row, c, from, to);

                        lv.setAdapter(sca);

                        sca.notifyDataSetChanged();

                        c.requery();             

                       

    }

}

Row.xml

<?xml version="1.0" encoding="UTF-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:layout_width="fill_parent"

    android:layout_height="fill_parent"

    android:orientation="vertical" >

    <RelativeLayout

        android:id="@+id/relativeLayout1"

        android:layout_width="match_parent"

        android:layout_height="wrap_content" >

        <TextView

            android:id="@+id/textView1"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_alignParentLeft="true"

            android:layout_alignParentTop="true"

            android:layout_marginLeft="20dp"

            android:text="TextView" />

        <TextView

            android:id="@+id/textView2"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_alignParentRight="true"

            android:layout_alignParentTop="true"

            android:layout_marginRight="54dp"

            android:text="TextView" />

        <TextView

            android:id="@+id/textView3"

            android:layout_width="wrap_content"

            android:layout_height="wrap_content"

            android:layout_alignParentTop="true"

            android:layout_marginRight="36dp"

            android:layout_toLeftOf="@+id/textView2"

            android:text="TextView" />

    </RelativeLayout>

   

</LinearLayout>

OutPut: