Blog

Dalam mengembangkan aplikasi di Android, terkadang kita membutuhkan database sebagai media penyimpanan data. Berikut adalah sedikit tutorial tentang bagaimana menggunakan SQLite di Android.

Pertama kita harus membuat class yang meng-extend class SQLiteOpenHelper.

[sourcecode language="java"]
public class OpenHelper extends SQLiteOpenHelper {
…
}
[/sourcecode]

Kemudian kita buat constructornya lalu overwrite method onCreate dan onUpdate

[sourcecode language="java"]
public OpenHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME + "
(id INTEGER PRIMARY KEY, name TEXT)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.w("Example", "Upgrading database, this will drop tables and recreate.");
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
[/sourcecode]

Kemudian untuk melakukan insert dan select

[sourcecode language="java"]
…
// open database
OpenHelper helper = new OpenHelper(context);
SQLiteDatabase db = helper.getReadableDatabase();

// insert record
ContentValues cv = new ContentValues();
cv.put("id", 1);
cv.put("name", "john");
db.insert(TABLE_NAME, null, cv);

// select record
Cursor c = db.query(TABLE_NAME, new String[]{"id","name"}, null, null, null, null, null);
while(c.moveToNext()) {
System.out.println("id="+c.getInt(0));
System.out.println("name="+c.getString(1));
}

// close database
c.close();
db.close();
…
[/sourcecode]