Android SQLite Tutorial

Android SQL Tutorial

...
    
package de.vogella.android.todos.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class TodoDatabaseHelper extends SQLiteOpenHelper {
 private static final String DATABASE_NAME = "applicationdata";

 private static final int DATABASE_VERSION = 1;

 // Database creation sql statement
 private static final String DATABASE_CREATE = "create table todo (_id integer primary key autoincrement, "
   + "category text not null, summary text not null, description text not null);";

 public TodoDatabaseHelper(Context context) {
  super(context, DATABASE_NAME, null, DATABASE_VERSION);
 }

 // Method is called during creation of the database
 @Override
 public void onCreate(SQLiteDatabase database) {
  database.execSQL(DATABASE_CREATE);
 }

 // Method is called during an upgrade of the database, e.g. if you increase
 // the database version
 @Override
 public void onUpgrade(SQLiteDatabase database, int oldVersion,
   int newVersion) {
  Log.w(TodoDatabaseHelper.class.getName(),
    "Upgrading database from version " + oldVersion + " to "
      + newVersion + ", which will destroy all old data");
  database.execSQL("DROP TABLE IF EXISTS todo");
  onCreate(database);
 }
}