class DBHelper extends SQLiteOpenHelper

res\layout\activity_main.xml

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:id="@+id/LinearLayout1"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    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.skex.listsqllite.MainActivity" >

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/hello_world" />

    <EditText
        android:id="@+id/tv_name"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="user_name" />

    <EditText
        android:id="@+id/tv_address"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="user_address" />

    <Button
        android:id="@+id/btnInsert"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Insert" />
    
    <Button
        android:id="@+id/btnDelete"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Delete" />

</LinearLayout>

package com.skex.listsqllite;

import java.util.ArrayList;

import android.support.v7.app.ActionBarActivity;
import android.content.Intent;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

public class MainActivity extends ActionBarActivity  implements OnClickListener{

    private EditText tv_name;
    private EditText tv_address;
    private Button btnInsert;
    private Button btnDelete;


    private DBHelper dbHelper;
    
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        tv_name = (EditText) findViewById(R.id.tv_name);
        tv_address = (EditText) findViewById(R.id.tv_address);
        btnInsert = (Button) findViewById(R.id.btnInsert);
        btnInsert.setOnClickListener(this);
        btnDelete = (Button) findViewById(R.id.btnDelete);
        btnDelete.setOnClickListener(this);
        
        dbHelper=new DBHelper(this,"user_address_db");
        
        
        
    }
    
    @Override
    public void onClick(View view) {

        switch(view.getId())
        {
            case R.id.btnInsert:
                dbHelper.insert(tv_name.getText().toString(),tv_address.getText().toString());
                Toast.makeText(this, 
                        tv_name.getText().toString()+","+tv_address.getText().toString(), 
                        Toast.LENGTH_LONG).show();
                break;
            case R.id.btnDelete:
                dbHelper.deleteAll();
                Toast.makeText(this, 
                        "dalete all data", 
                        Toast.LENGTH_LONG).show();
                break;
            default:
                break;
        }
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();
        if (id == R.id.action_settings) {
            Intent intent=new Intent(this,ShowListActivity.class);
            ArrayList<String> userNameList=new ArrayList<String>();
            ArrayList<String> userAddressList=new ArrayList<String>();
            dbHelper.queryAllUserInfo(userNameList,userAddressList);
            Bundle bundle=new Bundle();
            bundle.putStringArrayList("user_name_array", userNameList);
            bundle.putStringArrayList("user_address_array", userAddressList);
            intent.putExtra("data", bundle);
            startActivity(intent);
            return true;
        }
        return super.onOptionsItemSelected(item);
    }
}

package com.skex.listsqllite;

import java.util.ArrayList;

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;

public class DBHelper extends SQLiteOpenHelper{

    private static final int VERSION=1;
    public DBHelper(Context context, String db_name,
            CursorFactory factory,
            int version) {
        // TODO Auto-generated constructor stub
        super(context,db_name,factory,version);
    }
    
    public DBHelper(Context context, String db_name,int version) {
        // TODO Auto-generated constructor stub
        this(context,db_name,null,version);
    }
    
    public DBHelper(Context context, String db_name) {
        // TODO Auto-generated constructor stub
        this(context,db_name,VERSION);
    }
    


    public void insert(String user_name, String user_address) {
        // TODO Auto-generated method stub
        SQLiteDatabase db=this.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put("user_name", user_name);
        values.put("user_address", user_address);
        db.insert("user_info",null,values);
        
    }

    public void queryAllUserInfo(ArrayList<String> userNameList,
            ArrayList<String> userAddressList) {
        // TODO Auto-generated method stub
        SQLiteDatabase db=this.getReadableDatabase();
        Cursor cursor = db.query("user_info",new String[]{"user_name","user_address"}, null, null, null, null, null);
        while(cursor.moveToNext()){            
            userNameList.add(cursor.getString(0));            
            userAddressList.add(cursor.getString(1));
        }
        
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("create table user_info(user_name varchar(20),user_address varchar(20))");
    }

    @Override
    public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
        // TODO Auto-generated method stub
        
    }

    public void deleteAll() {
        // TODO Auto-generated method stub
        SQLiteDatabase db=this.getWritableDatabase();
        db.execSQL("delete from user_info");
    }

}