Android Simple Sqlite Program

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 />

</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;

    /** 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_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;
        default:
            break;
        }

    }
}

Click Code Link:

http://androiddevelopmentworld.blogspot.in/2013/04/android-sqlite-tutorial.html