A8DiL2h3

1package id.co.imastudio.kakilima.database;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6import android.util.Log;
7
8/**
9 * Created by imastudio on 10/21/15.
10 */
11public class DBHelper extends SQLiteOpenHelper {
12    /** deklarasi konstanta-konstanta yang digunakan pada database, seperti nama tabel,
13     nama-nama kolom, nama database, dan versi dari database **/
14    public static final String TABLE_NAME = "transaksi";
15    public static final String COLUMN_ID = "_id";
16//    public static final String COLUMN_ID_WILAYAH = "id_wilayah";
17//    public static final String COLUMN_ID_KATEGORI = "id_kategori_produk";
18//    public static final String COLUMN_ID_MERK = "id_merk";
19    public static final String COLUMN_ID_USER = "id_user";
20    public static final String COLUMN_ID_PRODUK = "id_produk";
21    public static final String COLUMN_NM_PRODUK = "produk_name";
22    public static final String COLUMN_DES_PRODUK = "desc_produk";
23//    public static final String COLUMN_HRG_PRODUK = "price1";
24    public static final String COLUMN_HRG_PRODUK = "price1";
25    public static final String COLUMN_GAMABR = "gambar1";
26    public static final String COLUMN_JMLH = "jmlh_menu";
27    public static final String COLUMN_TOTAL = "total_menu";
28//    public static final String COLUMN_WILAYAH = "transaksi_total";
29//    public static final String COLUMN_ID_JUMHARGA = "name_wilayah";
30
31    private static final String db_name ="kakilimaDB.db";
32    private static final int db_version=1;
33
34    // Perintah SQL untuk membuat tabel database baru
35    private static final String db_create = "create table "
36            + TABLE_NAME + "("
37            + COLUMN_ID +" integer primary key autoincrement, "
38            + COLUMN_ID_USER+ " varchar(12) not null, "
39            + COLUMN_ID_PRODUK+ " varchar(12) not null, "
40            + COLUMN_NM_PRODUK+ " varchar(50) not null, "
41            + COLUMN_DES_PRODUK+ " varchar(500) not null, "
42            + COLUMN_HRG_PRODUK+ " double not null, "
43            + COLUMN_GAMABR+ " varchar (50) not null, "
44            + COLUMN_JMLH+ " integer not null, "
45            + COLUMN_TOTAL+ " double not null);";
46
47
48    public DBHelper(Context context) {
49        super(context, db_name, null, db_version);
50        // Auto generated
51    }
52
53    //mengeksekusi perintah SQL di atas untuk membuat tabel database baru
54    @Override
55    public void onCreate(SQLiteDatabase db) {
56        db.execSQL(db_create);
57    }
58
59    // dijalankan apabila ingin mengupgrade database
60    @Override
61    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
62        Log.w(DBHelper.class.getName(), "Upgrading database from version " + oldVersion + " to "
63                + newVersion + ", which will destroy all old data");
64        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
65        onCreate(db);
66
67    }
68}