hW5T3Yda

1package istakprind.sn1.com.sqlite;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6import android.util.Log;
7
8/**
9 * Created by Server on 25/11/2016.
10 */
11public class DBHelper extends SQLiteOpenHelper {
12    public static final String TABLE_NAME = "data_inventori";
13    public static final String COLUMN_ID = "_id";
14    public static final String COLUMN_NAME = "nama_barang";
15    public static final String COLUMN_MERK = "merk_barang";
16    public static final String COLUMN_HARGA = "harga_barang";
17    private static final String db_name ="inventori.db";
18    private static final int db_version=1;
19
20    // Perintah SQL untuk membuat tabel database baru
21    private static final String db_create = "create table "
22            + TABLE_NAME + "("
23            + COLUMN_ID +" integer primary key autoincrement, "
24            + COLUMN_NAME+ " varchar(50) not null, "
25            + COLUMN_MERK+ " varchar(50) not null, "
26            + COLUMN_HARGA+ " varchar(50) not null);";
27
28
29    public DBHelper(Context context) {
30        super(context, db_name, null, db_version);
31        // Auto generated
32    }
33
34    //mengeksekusi perintah SQL di atas untuk membuat tabel database baru
35    @Override
36    public void onCreate(SQLiteDatabase db) {
37        db.execSQL(db_create);
38    }
39
40    // dijalankan apabila ingin mengupgrade database
41    @Override
42    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
43        Log.w(DBHelper.class.getName(), "Upgrading database from version " + oldVersion + " to "
44                + newVersion + ", which will destroy all old data");
45        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
46        onCreate(db);
47
48    }
49
50}