Android SQLite Tutorial

 => Just like iOS android have in build sqlite database. In this tutorial, you learn how SQLite databases are designed and manipulated.

 => SQLite is a lightweight relational database engine. Instead of the heavyweight server-based databases, each SQLite database is stored within a single file on disk.

  => Android applications can choose to store private application data in a SQLite database.

  => In SQLite data are stored in table format. A table has columns with different data types. Each row in a table represents a data record.  
        
  => Lets take one example, Let’s say we have a product database with a table called Products.


  =>The Products  table might have 3 typed columns:

                          1) ProductID (number)
                          2) ProductName (string)
                          3) Pproductprice (string)

    => We could then add a record to the data base for an Product named computer.
    => We can do following operation on Products table :

                          1) ADD (INSERT query)
                          2) MODIFIED (UPDATE query)
                          3) DELETE (DELETE query)      

     => Now we perform create, modify and delete operation with Products table.
      

       (1) Create table

                                             
                    CREATE TABLE Products (id INTEGER PRIMARY KEY AUTOINCREMENT,                        
 Productname TEXT NOT NULL, Productprice TEXT NOT NULL );



       (2) INSERT into table       

                                
                     INSERT into Products(Productname, Productprice)
                       VALUES('Computer', '50000'); 

       (3) UPDATE table


           SQLiteDatabase db;
           db.update("Products", values, whereClause, whereArgs);



  Now we explain with example. We have to achieve following.

- create new android project AndroidAdvanceSqlite.


  - create class AndroidAdvanceSqliteActivity.java, this class describe two options add record and view record from sqlite database. For this we have to create main.xml like following.


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:layout_marginBottom="15dp"
        android:layout_marginTop="10dp"
        android:gravity="center"
        android:text="Android Advance SQLite Tutorial"
        android:textSize="18dp"
        android:text />

    <Button
        android:id="@+id/btn_add"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:text="Add Products"
        android:text />

    <Button
        android:id="@+id/btn_view"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:text="View Products"
        android:text />

 <Button
        android:id="@+id/btn_contact"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:onClick="contactMe"
        android:text="Contact me for query"
        android:textStyle="bold" />

</LinearLayout>




  - We have to create two buttons for database operation.

AndroidAdvanceSqliteActivity.java


public class AndroidAdvanceSqliteActivity extends Activity implements
        OnClickListener {

    private Button btn_add, btn_view, btn_search;

    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        btn_add = (Button) findViewById(R.id.btn_add);
        btn_view = (Button) findViewById(R.id.btn_view);
         btn_search = (Button) findViewById(R.id.btn_search);
        btn_search.setOnClickListener(this);
        btn_add.setOnClickListener(this);
        btn_view.setOnClickListener(this);

    }

    @Override
    public void onClick(View v) {
        // TODO Auto-generated method stub
        switch (v.getId()) {
        case R.id.btn_add:
            Intent addintent = new Intent(AndroidAdvanceSqliteActivity.this,
                    AddRecord.class);
            startActivity(addintent);
            break;

        case R.id.btn_view:
            Intent viewintent = new Intent(AndroidAdvanceSqliteActivity.this,
                    ViewRecord.class);
            startActivity(viewintent);
            break;

            case R.id.btn_search:
            Intent searchintent = new Intent(AndroidAdvanceSqliteActivity.this,
                    SearchProduct.class);
            startActivity(searchintent);
            break;
        default:
            break;
        }

    }

       public void contactMe(View v) {

        final Intent emailIntent = new Intent(
                android.content.Intent.ACTION_SEND);
        emailIntent.setType("plain/text");
        emailIntent.putExtra(android.content.Intent.EXTRA_EMAIL,
                new String[] { "androiddevelopmentworld@gmail.com" });
        emailIntent.putExtra(android.content.Intent.EXTRA_SUBJECT,
                "Android sqlite tutorial");
        emailIntent.putExtra(android.content.Intent.EXTRA_TEXT,
                "Android sqlite tutorial contact Me");
        startActivity(Intent.createChooser(emailIntent, "Send mail..."));

    }
}



- We are passing intents to AddRecord.java and ViewRecord.java classes for operation. Now first we have to create AddRecord.java class and for that we have to  create xml file as following.


  -create new addrecord.xml file


<?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:layout_marginBottom="15dp"
        android:layout_marginTop="10dp"
        android:gravity="center"
        android:text="ADD Record"
        android:textSize="18dp"
        android:text />

    <TextView
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_marginLeft="5dp"
        android:text="Product ID" />

    <EditText
        android:id="@+id/txtpid"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:hint="product ID" />

    <TextView
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_marginLeft="5dp"
        android:text="Enter Product Name" />

    <EditText
        android:id="@+id/txtpname"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:hint="product name" />

    <TextView
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_marginLeft="5dp"
        android:text="Enter Product Price" />

    <EditText
        android:id="@+id/txtpprice"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:hint="product price" />

    <Button
        android:id="@+id/btn_addrecord"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="center"
        android:text="Save" />

</LinearLayout>


  - Now we have to create AddRecord.java  like following. When user click on save button we need to add that record in our database for that we have to fire query which add record in our database.


public class AddRecord extends Activity implements OnClickListener {

    private Button btn_addrecord;
    private EditText txtpname, txtpprice, txtpid;
    DatabaseHelper db;
    ProductModel pm;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.addrecord);

        txtpname = (EditText) findViewById(R.id.txtpname);
        txtpprice = (EditText) findViewById(R.id.txtpprice);
        btn_addrecord = (Button) findViewById(R.id.btn_addrecord);

        txtpid = (EditText) findViewById(R.id.txtpid);
        btn_addrecord.setOnClickListener(this);

    }

    @Override
    public void onClick(View v) {
        // TODO Auto-generated method stub
        switch (v.getId()) {
        case R.id.btn_addrecord:

            if (txtpname.getText().toString().equals("")
                    || txtpprice.getText().toString().equals("")) {
                Toast.makeText(AddRecord.this, "Please add values..",
                        Toast.LENGTH_LONG).show();
            } else {

                db = new DatabaseHelper(getApplicationContext());
                db.getWritableDatabase();
                pm = new ProductModel();
                pm.idno = (txtpid.getText().toString());
                pm.productname = txtpname.getText().toString();
                pm.productprice = txtpprice.getText().toString();

                Log.i("idno,productname,productprice", "" + pm.idno + ""
                        + pm.productname + "" + pm.productprice);
                   db.addProduct(pm);
                Toast.makeText(AddRecord.this, "Record Added successfully.",
                        Toast.LENGTH_LONG).show();
                finish();
            }
            break;

        default:
            break;
        }

    }
}


- Here we add record using db.addProduct() method. Which we have to create in our DatabaseHelper.java class.

 - our DatabaseHelper.java looks like..


public class DatabaseHelper extends SQLiteOpenHelper {

    public static String DATABASENAME = "androidadvancesqlite";  // our database Name

    public static String PRODUCTTABLE = "products";                    //table name

    private ArrayList<ProductModel> cartList = new ArrayList<ProductModel>();
    Context c;


  //constructor
    public DatabaseHelper(Context context) {
        super(context, DATABASENAME, null, 33);
        c = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE if not exists producttable(id INTEGER PRIMARY KEY AUTOINCREMENT,"
                + "productidno"
                + " TEXT ,"
                + "productname"
                + " TEXT,"
                + "productprice" + " TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS" + PRODUCTTABLE);
        onCreate(db);
    }

  //Add record
    public void addProduct(ProductModel productitem) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put("productidno", productitem.idno);
        contentValues.put("productname", productitem.productname);
        contentValues.put("productprice", productitem.productprice);
        db.insert("producttable", null, contentValues);
        db.close();
    }

 //update record
    public void updateProduct(ProductModel productList) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put("productname", productList.productname);

        contentValues.put("productprice", productList.productprice);
        db.update("producttable", contentValues, "productidno="
                + productList.idno, null);
        db.close();
    }

  // delete entire data from table
    public void emptyProduct() {
        try {
            SQLiteDatabase db = this.getWritableDatabase();
            db.execSQL("delete from producttable");
            db.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

  // remove specific record from table
    public void removeProduct(String productid, String pname, String pprice) {
        try {
            String[] args = { productid };
            getWritableDatabase().delete("producttable", "productidno=?", args);

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

  // get all products from database
    public ArrayList<ProductModel> getProudcts() {

        cartList.clear();

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery("select * from producttable", null);
        if (cursor.getCount() != 0) {
            if (cursor.moveToFirst()) {
                do {
                    ProductModel item = new ProductModel();

                    item.idno = cursor.getString(cursor
                            .getColumnIndex("productidno"));

                    item.productname = cursor.getString(cursor
                            .getColumnIndex("productname"));

                    item.productprice = cursor.getString(cursor
                            .getColumnIndex("productprice"));

                    cartList.add(item);

                } while (cursor.moveToNext());
            }
        }
        cursor.close();
        db.close();
        return cartList;
    }


   public ArrayList<ProductModel> getProudcts(String record) {

        cartList.clear();

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.query(true, "producttable", new String[] {
                "productidno", "productname", "productprice" }, "productname"
                + "=?", new String[] { record }, null, null, null, null);

        if (cursor.getCount() != 0) {
            if (cursor.moveToFirst()) {
                do {
                    ProductModel item = new ProductModel();

                    item.idno = cursor.getString(cursor
                            .getColumnIndex("productidno"));

                    item.productname = cursor.getString(cursor
                            .getColumnIndex("productname"));

                    item.productprice = cursor.getString(cursor
                            .getColumnIndex("productprice"));

                    cartList.add(item);

                } while (cursor.moveToNext());
            }
        }
        cursor.close();
        db.close();
        return cartList;
    }
}



- Here we have to specify ProductModel class which is our POJO(Plain Old Java Object) which will help us to populate all values.




 - Create new class ProductModel.java which looks like following. It have three variables idno,productname,productprice and also we have to declare   setter and getter methods for that.

 ProductModel.java

public class ProductModel {

   public String idno="", productname="", productprice="";

    public String getProductname() {
        return productname;
    }

    public void setProductname(String productname) {
        this.productname = productname;
    }

    public String getProductprice() {
        return productprice;
    }

    public void setProductprice(String productprice) {
        this.productprice = productprice;
    }

   

    public String getIdno() {
        return idno;
    }

    public void setIdno(String idno) {
        this.idno = idno;
    }

}


- Now for delete,update  and view records from products table we have to create new class ViewRecord.java. Here we desplay all records from database table and delete or update specific record from list.


 - create new viewrecord.xml file. We display all records in a listview.


<?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:layout_marginBottom="15dp"
        android:layout_marginTop="10dp"
        android:gravity="center"
        android:text="View Record"
        android:textSize="18dp"
        android:text />

    <TextView
        android:id="@+id/totalrecords"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_marginBottom="15dp"
        android:layout_marginTop="10dp"
        android:gravity="center"
        android:textSize="18dp"
        android:text />

    <ListView
        android:id="@+id/listview"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content" >
    </ListView>

</LinearLayout>


 - Now for handling events and display data we have to create ViewRecord.java like following.


ViewRecord.java

public class ViewRecord extends Activity {

    private ListView listview;
    TextView totalrecords;
    DatabaseHelper db;
    public ArrayList<ProductModel> _productlist = new ArrayList<ProductModel>();

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.viewrecord);
        totalrecords = (TextView) findViewById(R.id.totalrecords);
        listview = (ListView) findViewById(R.id.listview);
    }

    @Override
    protected void onResume() {
        // TODO Auto-generated method stub
        super.onResume();

        _productlist.clear();

        db = new DatabaseHelper(getApplicationContext());
        db.getWritableDatabase();
        ArrayList<ProductModel> product_list = db.getProudcts();

        for (int i = 0; i < product_list.size(); i++) {

            String tidno = product_list.get(i).getIdno();

            String tname = product_list.get(i).getProductname();
            String tprice = product_list.get(i).getProductprice();

            ProductModel _ProductModel = new ProductModel();

            _ProductModel.setIdno(tidno);
            _ProductModel.setProductname(tname);
            _ProductModel.setProductprice(tprice);

            _productlist.add(_ProductModel);
        }
        totalrecords.setText("Total Records :-" + _productlist.size());
        listview.setAdapter(new ListAdapter(this));
        db.close();

    }

    private class ListAdapter extends BaseAdapter {
        LayoutInflater inflater;
        ViewHolder viewHolder;

        public ListAdapter(Context context) {
            // TODO Auto-generated constructor stub
            inflater = LayoutInflater.from(context);
        }

        @Override
        public int getCount() {
            // TODO Auto-generated method stub
            return _productlist.size();
        }

        @Override
        public Object getItem(int position) {
            // TODO Auto-generated method stub
            return position;
        }

        @Override
        public long getItemId(int position) {
            // TODO Auto-generated method stub
            return position;
        }

        @Override
        public View getView(int position, View convertView, ViewGroup parent) {
            // TODO Auto-generated method stub
            if (convertView == null) {

                convertView = inflater.inflate(R.layout.listview_row, null);
                viewHolder = new ViewHolder();

                viewHolder.txt_pname = (TextView) convertView
                        .findViewById(R.id.txtdisplaypname);
                viewHolder.txt_pprice = (TextView) convertView
                        .findViewById(R.id.txtdisplaypprice);

                viewHolder.txtidno = (TextView) convertView
                        .findViewById(R.id.txtdisplaypid);
                convertView.setTag(viewHolder);

            } else {
                viewHolder = (ViewHolder) convertView.getTag();
            }

            viewHolder.txt_pname.setText(_productlist.get(position)
                    .getProductname().trim());
            viewHolder.txt_pprice.setText(_productlist.get(position)
                    .getProductprice().trim());

            viewHolder.txtidno.setText(_productlist.get(position).getIdno()
                    .trim());

            final int temp = position;
            (convertView.findViewById(R.id.btn_update))
                    .setOnClickListener(new OnClickListener() {

                        public void onClick(View arg0) {

                            String _productid = String.valueOf(_productlist
                                    .get(temp).getIdno());
                            String _productname = _productlist.get(temp)
                                    .getProductname();
                            String _productprice = _productlist.get(temp)
                                    .getProductprice();

                            Intent intent = new Intent(ViewRecord.this,
                                    AddUpdateValues.class);

                            Bundle bundle = new Bundle();
                            bundle.putString("id", _productid);
                            bundle.putString("name", _productname);
                            bundle.putString("price", _productprice);
                            intent.putExtras(bundle);
                            startActivity(intent);

                        }
                    });



  - for delete record we no need to create class we just call removeProduct() method of DatabaseHelper like following.



            (convertView.findViewById(R.id.btn_delete))
                    .setOnClickListener(new OnClickListener() {

                        public void onClick(View arg0) {

                            AlertDialog.Builder alertbox = new AlertDialog.Builder(
                                    ViewRecord.this);
                            alertbox.setCancelable(true);
                            alertbox.setMessage("Are you sure you want to delete ?");
                            alertbox.setPositiveButton("Yes",
                                    new DialogInterface.OnClickListener() {

                                        public void onClick(
                                                DialogInterface arg0, int arg1) {

                                            db.removeProduct(
                                                    _productlist.get(temp)
                                                            .getIdno().trim(),
                                                    "", "");

                                            ViewRecord.this.onResume();

                                            Toast.makeText(
                                                    getApplicationContext(),
                                                    "Record Deleted...",
                                                    Toast.LENGTH_SHORT).show();

                                        }

                                    });
                            alertbox.setNegativeButton("No",
                                    new DialogInterface.OnClickListener() {
                                        public void onClick(
                                                DialogInterface arg0, int arg1) {

                                        }
                                    });
                            alertbox.show();
                        }
                    });
            return convertView;

        }
    }

    private class ViewHolder {
        TextView txt_pname;
        TextView txt_pprice;
        TextView txtidno;

    }

}


 - Here we have to give two buttons with each record in a list that is update and delete. When user click on Update button we have to pass intent to new activity that is AddUpdateValues.java and we have to also pass id,product name and product price of perticular record using Bundle.



 - For update record we create AddUpdateValues.java class. Which will update your record.


- create new addupdatevalues.xml file.


 <?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:layout_marginLeft="5dp"
        android:text="Enter Product Name" />

    <EditText
        android:id="@+id/txt_udatepname"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:hint="product name" />

    <TextView
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_marginLeft="5dp"
        android:text="Enter Product Price" />

    <EditText
        android:id="@+id/txt_udatepprice"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dp"
        android:hint="product price" />

    <Button
        android:id="@+id/btn_updaterecord"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="center"
        android:text="Save" />

</LinearLayout>

 - Here user enter new values for product name and product price so we declare two edittext.

 - Now create new class AddUpdateValues.java for update records.


public class AddUpdateValues extends Activity implements OnClickListener {
    private Button btn_updaterecord;
    private EditText txtpname, txtpprice;
    DatabaseHelper db;
    ProductModel pm;
    Intent i;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.addupdatevalues);
        i = getIntent();
        txtpname = (EditText) findViewById(R.id.txt_udatepname);
        txtpprice = (EditText) findViewById(R.id.txt_udatepprice);

  - Here we get string from intent and sets it to perticular field.

        txtpname.setText(i.getExtras().getString("name"));
        txtpprice.setText(i.getExtras().getString("price"));
        btn_updaterecord = (Button) findViewById(R.id.btn_updaterecord);
        btn_updaterecord.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
        // TODO Auto-generated method stub
        switch (v.getId()) {
        case R.id.btn_updaterecord:
            if (txtpname.getText().toString().equals("")
                    || txtpprice.getText().toString().equals("")) {
                Toast.makeText(AddUpdateValues.this, "Please add values..",
                        Toast.LENGTH_LONG).show();
            } else {

                db = new DatabaseHelper(getApplicationContext());
                db.getWritableDatabase();
                pm = new ProductModel();
                pm.productname = txtpname.getText().toString();
                pm.productprice = txtpprice.getText().toString();
                pm.idno = i.getExtras().getString("id");
                db.updateProduct(pm);
                Toast.makeText(AddUpdateValues.this,
                        "Record Update successfully.", Toast.LENGTH_LONG)
                        .show();
                db.close();
                super.onResume();
                finish();
            }
            break;
        }
    }
}


As per many user's request, I have create search functionality in this example.

Create searchproduct.xml file.


<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/searchlinear"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:gravity="center_horizontal"
    android:orientation="vertical" >

    <LinearLayout
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal" >

        <TextView
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:layout_marginBottom="15dp"
            android:layout_marginTop="10dp"
            android:layout_weight="1"
            android:gravity="center"
            android:text="Search Record"
            android:textSize="18dp"
            android:textStyle="bold" />

        <ProgressBar
            android:id="@+id/showprogress"
            style="?android:attr/progressBarStyleSmall"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_marginTop="10dp"
            android:paddingRight="10dp"
            android:visibility="gone" />
    </LinearLayout>

    <EditText
        android:id="@+id/txtsearchproduct"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:hint="search"
        android:lines="1"
        android:paddingLeft="25dp"
        android:visibility="visible" >
    </EditText>

    <AutoCompleteTextView
        android:id="@+id/myautocomplete"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:completionThreshold="1"
        android:hint="search"
        android:lines="1"
        android:visibility="gone" />

    <ListView
        android:id="@+id/searchlistview"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" >
    </ListView>

</LinearLayout>


Now for display searched items, we need to create xml file for display single searched item.

Create product_list.xml for display single searched item.


<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:id="@+id/category_list_id"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:background="@android:color/white"
    android:paddingBottom="1dp" >

    <LinearLayout
        android:id="@+id/ll_place_name_use"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_centerVertical="true"
        android:layout_marginLeft="10dp"
        android:layout_marginTop="10dp"
        android:orientation="vertical"
        android:paddingRight="8dp" >

        <TextView
            android:id="@+id/txt_title_text"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:maxLines="3"
            android:padding="2dp"
            android:text="aaa"
            android:textColor="@android:color/black"
            android:textSize="16sp"
            android:textStyle="bold" >
        </TextView>

        <TextView
            android:id="@+id/txt_price"
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:padding="2dp"
            android:text="1000"
            android:textColor="@android:color/black"
            android:textSize="14sp"
            android:visibility="visible" >
        </TextView>
    </LinearLayout>

</RelativeLayout>


Now last but not least create java file for searching.

Create SearchProduct.java


package com.androidadvance.screen;

import java.util.ArrayList;
import java.util.List;

import com.androidadvance.db.DatabaseHelper;

import android.app.Activity;
import android.content.Context;
import android.graphics.Color;
import android.os.AsyncTask;
import android.os.Bundle;
import android.os.Handler;
import android.text.Editable;
import android.text.TextWatcher;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.AutoCompleteTextView;
import android.widget.BaseAdapter;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.ProgressBar;
import android.widget.RelativeLayout;
import android.widget.TextView;
import android.widget.Toast;

public class SearchProduct extends Activity implements TextWatcher {
    EditText _searchbox;
    private ProgressBar showprogress;
    searchtask dotask;
    private ArrayList<ProductModel> _productList;
    ListView _listview;
    DatabaseHelper db;
    public AutoCompleteTextView myAutoComplete;
    private ArrayList<ProductModel> _productList_Temp;
    String query = "";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.searchproduct);
        _searchbox = (EditText) findViewById(R.id.txtsearchproduct);
        showprogress = (ProgressBar) findViewById(R.id.showprogress);
        _listview = (ListView) findViewById(R.id.searchlistview);
        _searchbox.addTextChangedListener(textwatcher);

    }

    Runnable runn = new Runnable() {

        @Override
        public void run() {
            // TODO Auto-generated method stub
            handlersearch.sendEmptyMessage(0);
        }
    };
    TextWatcher textwatcher = new TextWatcher() {

        public void onTextChanged(CharSequence s, int start, int before,
                int count) {
            Log.i("---onTextChanged ----", "---------onTextChanged ----");

            if (_searchbox.getText().toString().length() > 2) {
                query = _searchbox.getText().toString().replace(" ", "%20");

                handlersearch.removeCallbacks(runn);
                handlersearch.post(runn);

            } else {
                showprogress.setVisibility(View.GONE);

                if (dotask != null) {
                    if (dotask.getStatus().equals(AsyncTask.Status.RUNNING)) {
                        dotask.cancel(true);
                    }
                }

                handlersearch.removeCallbacks(runn);

                _productList = new ArrayList<ProductModel>();
                _productList.clear();
                _listview.setAdapter(new CustomBaseAdapter(SearchProduct.this,
                        _productList));
            }

        }

        public void beforeTextChanged(CharSequence s, int start, int count,
                int after) {
            // TODO Auto-generated method stub

        }

        public void afterTextChanged(Editable s) {
            // TODO Auto-generated method stub

        }
    };

    Handler handlersearch = new Handler() {

        public void handleMessage(android.os.Message msg) {
            dotask = new searchtask();
            dotask.execute();
        };
    };

    private class searchtask extends AsyncTask<Void, Void, Void> {

        protected void onPreExecute() {

            showprogress.setVisibility(View.VISIBLE);
        };

        protected void onPostExecute(Void param) {
            // animation.dismiss();
            showprogress.setVisibility(View.GONE);
            if (_productList == null)
                return;

            ArrayList<String> item = new ArrayList<String>();

            for (int i = 0; i < _productList.size(); i++) {
                item.add(_productList.get(i).productname);
            }

            myAutoComplete = (AutoCompleteTextView) findViewById(R.id.myautocomplete);

            myAutoComplete.addTextChangedListener(SearchProduct.this);

            myAutoComplete.setAdapter(new ArrayAdapter<String>(
                    SearchProduct.this,
                    android.R.layout.simple_dropdown_item_1line, item));

            _productList_Temp = new ArrayList<ProductModel>();

            for (int i = 0; i < _productList.size(); i++) {

                _productList_Temp.add(_productList.get(i));

            }

            _listview.setAdapter(new CustomBaseAdapter(SearchProduct.this,
                    _productList_Temp));

        }

        @Override
        protected Void doInBackground(Void... params) {

            db = new DatabaseHelper(getApplicationContext());
            db.getWritableDatabase();
            ArrayList<ProductModel> product_list = db.getProudcts(query);

            for (int i = 0; i < product_list.size(); i++) {

                String tidno = product_list.get(i).getIdno();

                System.out.println("tidno>>>>>" + tidno);
                String tname = product_list.get(i).getProductname();
                String tprice = product_list.get(i).getProductprice();

                ProductModel _ProductModel = new ProductModel();

                _ProductModel.setIdno(tidno);
                _ProductModel.setProductname(tname);
                _ProductModel.setProductprice(tprice);

                _productList.add(_ProductModel);
            }
            // _productList = _parser.getProductList();

            return null;
        }

    }

    private class CustomBaseAdapter extends BaseAdapter {
        LayoutInflater _inflater;

        List<ProductModel> productList;

        public CustomBaseAdapter(Context context, List<ProductModel> productList) {
            _inflater = LayoutInflater.from(context);
            this.productList = productList;

        }

        public int getCount() {
            // TODO Auto-generated method stub
            return productList.size();
        }

        public Object getItem(int position) {
            // TODO Auto-generated method stub
            return position;
        }

        public long getItemId(int position) {
            // TODO Auto-generated method stub
            return position;
        }

        public View getView(int position, View convertView, ViewGroup parent) {

            ViewHolder _holder;
            if (convertView == null) {

                convertView = _inflater.inflate(R.layout.product_list, null);
                _holder = new ViewHolder();

                _holder.title = (TextView) convertView
                        .findViewById(R.id.txt_title_text);
                _holder.price = (TextView) convertView
                        .findViewById(R.id.txt_price);

                convertView.setTag(_holder);
            } else {
                _holder = (ViewHolder) convertView.getTag();
            }

            _holder.title.setText(productList.get(position).productname.trim());

            _holder.price.setText(productList.get(position).productprice);

            return convertView;
        }

        private class ViewHolder {
            TextView title;
            TextView price;
        }
    }

    @Override
    public void afterTextChanged(Editable arg0) {
        // TODO Auto-generated method stub

    }

    @Override
    public void beforeTextChanged(CharSequence s, int start, int count,
            int after) {
        // TODO Auto-generated method stub

    }

    @Override
    public void onTextChanged(CharSequence s, int start, int before, int count) {
        // TODO Auto-generated method stub

    }

    //
}



Download Source code