Text

Sunday, 10 May 2015

MyDBHelper (untuk latihan penyimpanan di android)

package data.com.latihan06;

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

public class MyDBHelper extends SQLiteOpenHelper{
    private static final String BUAT_TABEL="create table "+
            Constants.NAMA_TABEL+"("+
            Constants.KEY_ID +" integer primary key autoincrement, "+
            Constants.NIM    +" text not null, "+
            Constants.NAMA   +" text not null, "+
            Constants.ALAMAT +" text not null); ";

    public MyDBHelper(Context context, String name, CursorFactory factory, int version){
        super(context, name, factory, version);
    }

    public void onCreate(SQLiteDatabase db){
        try{
            db.execSQL(BUAT_TABEL);
        }catch(Exception e){
            Log.v("Error : ", e.getMessage());
        }
    }

    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
        db.execSQL("drop table if exists "+Constants.NAMA_TABEL);
        onCreate(db);
    }
}

No comments:

Post a Comment