Latest News

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
           
      }


0 Response to "Source Code Dbhelper Di Sqlite Database Di Android"