I'm using this example to produce the database directly into amy android application.

But here you go not considering that how you can fetch the information in the database.

My fields are just like:

_id

title

address

type

now i wish to show the all available title in the database.

I understand that i must use Choose query. but where i must utilize it which i have no idea. So please can anybudy help e for your.

Thanks.

Write your method in DataBaseHelper that'll be such as this

public ArrayList<User> getUsersList() {

        ArrayList<User> userList = null;
        Cursor cursor = null;

        try {

            String queryString = "SELECT _id , name, address, type FROM User";

            cursor =  myDataBase.rawQuery(queryString, null);

            if (cursor != null && cursor.moveToFirst()) {
                userList = new ArrayList<User>();
                do {
                    User nextUser = new User(cursor.getInt(0),
                            cursor.getString(1), cursor.getString(2) , cursor.getString(3));
                    userList.add(nextUser);
                } while (cursor.moveToNext());
            }
        } catch (Exception e) {
            e.printStackTrace();
            userList = null;
        } finally {
            if (cursor != null && !cursor.isClosed()) {
                cursor.deactivate();
                cursor.close();
                cursor = null;
            }
            if(myDataBase != null){
                myDataBase.close();
            }
        }
        return userList;
    }

you are able to download one sample example from the computer. This really is link. It will likely be readily available for today only. I'm also providing you with its code as below.

package com.collabera.labs.sai.db;

import java.util.ArrayList;

import android.app.ListActivity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.util.Log;
import android.widget.ArrayAdapter;

public class CRUDonDB extends ListActivity {

    private final String SAMPLE_DB_NAME = "myFriendsDb";
    private final String SAMPLE_TABLE_NAME = "friends";

    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);


        ArrayList<String> results = new ArrayList<String>();
        SQLiteDatabase sampleDB = null;

        try {
            sampleDB =  this.openOrCreateDatabase(SAMPLE_DB_NAME, MODE_PRIVATE, null);

            sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +
                    SAMPLE_TABLE_NAME +
                    " (LastName VARCHAR, FirstName VARCHAR," +
                    " Country VARCHAR, Age INT(3));");

            sampleDB.execSQL("INSERT INTO " +
                    SAMPLE_TABLE_NAME +
                    " Values ('Makam','Sai Geetha','India',25);");
            sampleDB.execSQL("INSERT INTO " +
                    SAMPLE_TABLE_NAME +
                    " Values ('Chittur','Raman','India',25);");
            sampleDB.execSQL("INSERT INTO " +
                    SAMPLE_TABLE_NAME +
                    " Values ('Solutions','Collabera','India',20);");

            Cursor c = sampleDB.rawQuery("SELECT FirstName, Age FROM " +
                    SAMPLE_TABLE_NAME +
                    " where Age > 10 LIMIT 5", null);

            if (c != null ) {
                if  (c.moveToFirst()) {
                    do {
                        String firstName = c.getString(c.getColumnIndex("FirstName"));
                        int age = c.getInt(c.getColumnIndex("Age"));
                        results.add("" + firstName + ",Age: " + age);
                    }while (c.moveToNext());
                } 
            }

            this.setListAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1,results));

        } catch (SQLiteException se ) {
            Log.e(getClass().getSimpleName(), "Could not create or Open the database");
        } finally {
            if (sampleDB != null) 
                sampleDB.execSQL("DELETE FROM " + SAMPLE_TABLE_NAME);
                sampleDB.close();
        }
    }
}

Here's brilliant tutorial about android data.The tutorial covers all of the facets of database.