Source Code Dbhelper Di Sqlite Database Di Android

package com.example.contohentridatabase;

//Author :midasoft.blogspot.com

import java.util.List;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;

public class DBHelperMob extends SQLiteOpenHelper {

/** deklarasi konstanta-konstanta yang dipakai pada database, menyerupai nama tabel,

          ma-nama kolom, nama database, dan versi dari database **/

          public static final String TABLE_NAME = "appl_inventori";

          public static final String COLUMN_ID = "_id";

          public static final String COLUMN_NAME = "nama_barang";

          public static final String COLUMN_MERK = "merk_barang";

          public static final String COLUMN_HARGA = "harga_barang";

          private static final String db_name ="inventori.db";

          private static final int db_version=1;

       

// Perintah SQL untuk menciptakan tabel database baru      

      private static final String db_create = "create table "

                + TABLE_NAME + "("

                + COLUMN_ID +" integer primary key autoincrement, "

                + COLUMN_NAME+ " varchar(30) not null, "

                + COLUMN_MERK+ " varchar(30) not null, "

                + COLUMN_HARGA+ " varchar(30) not null);";

       

          public DBHelperMob(Context context) {

          super(context, db_name, null, db_version);

              // Auto generated   

              }

       

         //mengeksekusi perintah SQL di atas untuk menciptakan tabel database baru 

         @Override

          public void onCreate(SQLiteDatabase db) {

              db.execSQL(db_create);

          }

       

         // dijalankan apabila ingin mengupgrade database  

        @Override

          public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

              Log.w(DBHelperMob.class.getName(),"Upgrading database from version " + oldVersion + " to "

                      + newVersion + ", which will destroy all old data");

              db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);

              onCreate(db);

       

          }

      public void add(Barang barang) {

            // TODO Auto-generated method stub

           

      }

      public List<Barang> getAllBarang() {

            // TODO Auto-generated method stub

            return null;

      }

      public void addBarang(Barang barang) {

            // TODO Auto-generated method stub

           

      }

}