DatabaseActivity.java

package com.schibsted.spain.barista.sample;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.view.View;
import android.widget.TextView;

public class DatabaseActivity extends Activity {

  private TextView currentValueText;
  private DatabaseOpenHelper databaseOpenHelper;

  @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_database);

    databaseOpenHelper = new DatabaseOpenHelper(this);
    currentValueText = ((TextView) findViewById(R.id.database_current_value));
    findViewById(R.id.database_increment_button).setOnClickListener(new View.OnClickListener() {
      @Override
      public void onClick(View v) {
        incrementValue();
        showCurrentValue();
      }
    });

    showCurrentValue();
  }

  private void showCurrentValue() {
    SQLiteDatabase readableDatabase = databaseOpenHelper.getReadableDatabase();
    Cursor cursor = readableDatabase.query("User", new String[] { "name" }, null, null, null, null, null);

    int currentValue = cursor.getCount();
    currentValueText.setText(String.valueOf(currentValue));

    cursor.close();
    readableDatabase.close();
  }

  private void incrementValue() {
    SQLiteDatabase writableDatabase = databaseOpenHelper.getWritableDatabase();
    ContentValues contentValues = new ContentValues(1);
    contentValues.put("name", "Mr T");
    writableDatabase.insert("User", null, contentValues);
    writableDatabase.close();
  }

  private static class DatabaseOpenHelper extends SQLiteOpenHelper {

    private static final int DB_VERSION = 1;

    DatabaseOpenHelper(Context context) {
      super(context, "mydatabase.db", null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
      db.execSQL("CREATE TABLE User (name TEXT NOT NULL);");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
  }
}