Monday, 15 October 2012

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:




6 comments:

  1. I tried this. It allows to only store and display one row entry in every run of the app. When I try to insert the 2nd entry , the application force closes..

    ReplyDelete
    Replies
    1. Ok. Can You post the error details?? So It will be help full .

      Delete
    2. Its Number Formate Exception After putting .trim() it solve.

      like following ( just add .trim() to solve )

      String ename = name.getText().toString().trim();
      String eloc = location.getText().toString().trim();
      Integer esal = Integer.parseInt(salary.getText().toString().trim());

      Delete
  2. Just Copy This Code and execute this in your system.

    ReplyDelete