T8p2hFKJ

1package com.labcoder.teguh.mypreload;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7import static android.provider.MediaStore.Audio.Playlists.Members._ID;
8import static com.labcoder.teguh.mypreload.DatabaseContract.MahasiswaColumns.NAMA;
9import static com.labcoder.teguh.mypreload.DatabaseContract.MahasiswaColumns.NIM;
10import static com.labcoder.teguh.mypreload.DatabaseContract.TABLE_NAME;
11
12public class DatabaseHelper extends SQLiteOpenHelper {
13
14    private static String DATABASE_NAME = "dbmahasiswa";
15    private static final int DATABASE_VERSION = 1;
16
17    public static String CREATE_TABLE_MAHASISWA = "create table "+TABLE_NAME+
18            " ("+_ID+" integer primary key autoincrement, " +
19            NAMA+" text not null, " +
20            NIM+" text not null);";
21
22    public DatabaseHelper(Context context) {
23        super(context, DATABASE_NAME, null, DATABASE_VERSION);
24    }
25
26    @Override
27    public void onCreate(SQLiteDatabase db) {
28        db.execSQL(CREATE_TABLE_MAHASISWA);
29    }
30
31    @Override
32    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
33        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
34        onCreate(db);
35    }
36}