U1xpE4q0

1package com.reihanalavi.mypreloaddata;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7import static android.provider.BaseColumns._ID;
8import static com.reihanalavi.mypreloaddata.DatabaseContract.MahasiswaColumns.NAMA;
9import static com.reihanalavi.mypreloaddata.DatabaseContract.MahasiswaColumns.NIM;
10import static com.reihanalavi.mypreloaddata.DatabaseContract.TABLE_NAME;
11
12/**
13 * Created by rehan on 2/22/2018.
14 */
15
16public class DatabaseHelper extends SQLiteOpenHelper {
17
18    private static String DATABASE_NAME = "dbmahasiswa";
19
20    private static final int DATABASE_VERSION = 1;
21
22    public static String CREATE_TABLE_MAHASISWA = "create table "+TABLE_NAME+" ("+_ID+" integer primary key autoincrement, "+
23            NAMA+" text not null, "+
24            NIM+" text not null);";
25
26    public DatabaseHelper(Context context) {
27        super(context, DATABASE_NAME, null, DATABASE_VERSION);
28    }
29
30    @Override
31    public void onCreate(SQLiteDatabase sqLiteDatabase) {
32        sqLiteDatabase.execSQL(CREATE_TABLE_MAHASISWA);
33    }
34
35    @Override
36    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
37        sqLiteDatabase.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
38        onCreate(sqLiteDatabase);
39    }
40}