Tutorial CRUD SQLite Android (I) : Membuat Database SQLite

package com.onlineticketing;

	
	//deklarasi import package
		import android.content.Context;
		import android.database.sqlite.SQLiteDatabase;
		import android.database.sqlite.SQLiteOpenHelper;
		import android.util.Log;
		 
		public class DBHelper extends SQLiteOpenHelper{
		        /** deklarasi konstanta-konstanta yang digunakan pada database, seperti nama tabel,
		        nama-nama kolom, nama database, dan versi dari database **/
		    public static final String TABLE_BUS = "data_bus";
		    public static final String COLUMN_ID_BUS = "id_bus";
		    public static final String COLUMN_NAMA_BUS = "nama_bus";
		    public static final String COLUMN_TIPE_BUS = "tipe_bus";
		    public static final String COLUMN_HARGA_BUS = "harga_ticket";
		    
		    public static final String TABLE_CLIENT = "data_client";
		    public static final String COLUMN_ID_CLIENT = "id_client";
		    public static final String COLUMN_NAMA_CLIENT = "nama_client";
		    public static final String COLUMN_TELP_CLIENT = "tipe_client";
		    public static final String COLUMN_ALAMAT_CLIENT = "alamat_client";
		    
		    public static final String TABLE_TRS_TICKET_HDR = "data_trs";
		    public static final String COLUMN_ID_TRS = "id_trs";
		    public static final String COLUMN_TGL_TRS = "tgl_trs";
		    public static final String COLUMN_JM_TRS = "jm_trs";
		    public static final String COLUMN_ID_BUS_TRS = "id_bus";
		    public static final String COLUMN_ID_CL_TRS = "id_client";
		    public static final String COLUMN_QTY = "qty_trs";
		    public static final String COLUMN_HARGA_TICKET = "harga_ticket";
		    public static final String COLUMN_SUBTOTAL = "subtotal_trs";
		    
		    private static final String db_name ="Ticketing.db";
		    private static final int db_version=1;
		 
		    // Perintah SQL untuk membuat tabel database baru
		      private static final String db_create_bus = "create table"
		          + TABLE_BUS + "("
		          + COLUMN_ID_BUS +" integer primary key autoincrement, "
		          + COLUMN_NAMA_BUS+ " varchar(50) not null, "
		          + COLUMN_TIPE_BUS+ " varchar(50) not null, "
		          + COLUMN_HARGA_BUS+ " varchar(50) not null);";
		 
		      private static final String db_create_client = "create table"
			      + TABLE_CLIENT + "("
			      + COLUMN_ID_CLIENT +" integer primary key autoincrement, "
			      + COLUMN_NAMA_CLIENT+ " varchar(50) not null, "
			      + COLUMN_TELP_CLIENT+ " varchar(50) not null, "
			      + COLUMN_ALAMAT_CLIENT+ " varchar(50) not null);";
			 
		      private static final String db_create_trs = "create table"
			      + TABLE_TRS_TICKET_HDR + "("
			      + COLUMN_ID_TRS +" integer primary key autoincrement, "
			      + COLUMN_TGL_TRS+ " varchar(50) not null, "
			      + COLUMN_JM_TRS+ " varchar(50) not null, "
			      + COLUMN_ID_BUS_TRS+ " varchar(50) not null), "
			      + COLUMN_ID_CL_TRS+ "varchar(50) not null), " 
			      + COLUMN_QTY+ " varchar(50) not null, "
			      + COLUMN_HARGA_TICKET+ " varchar(50) not null), "
			      + COLUMN_SUBTOTAL+ "varchar(50) not null),;";
			 
		    public DBHelper(Context context) {
		        super(context, db_name, null, db_version);
		        // Auto generated
		    }
		 
		        //mengeksekusi perintah SQL di atas untuk membuat tabel database baru
		    @Override
		    public void onCreate(SQLiteDatabase db) {
		        db.execSQL(db_create_bus);
		        db.execSQL(db_create_client);
		        db.execSQL(db_create_trs);
		    }
		 
		        // dijalankan apabila ingin mengupgrade database
		    @Override
		    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		        Log.w(DBHelper.class.getName(),"Upgrading database from version " + oldVersion + " to "
		                + newVersion + ", which will destroy all old data");
		        db.execSQL("DROP TABLE IF EXISTS " + TABLE_BUS);
		        db.execSQL("DROP TABLE IF EXISTS " + TABLE_CLIENT);
		        db.execSQL("DROP TABLE IF EXISTS " + TABLE_TRS_TICKET_HDR);
		        onCreate(db);
		 
		    }
		 



}

begitu kah suhu ? 😀 baru sx ni pegang java 😀 jadi bnyak ga ngeh nya

saya belum paham ttg db helper, itu file’nya kita buat sendiri / udah ada di project’nya??
mohon pencerahan kakak . . 🙂

mas, saya sedang membuat aplikasi kamus, akan tetapi saat aplikasi di compile malah tabel didalam databasenya gak ada lagi, pdhal databasenya sudah ada tabel. dibuat “no such tabel nama tabel”.
kalau errornya “no such table nama tabel” itu knp ya?

Terima kasih atas tutorial pembelajaran SQLite ini.
Saya coba praktekan 🙂

numpang nanya gan…. scrip yg agan buat.. tu di pastekan kmn ya…. .. ane benar newbie gan… ane pakai ubuntu 14.04, tq sebelumnya

Gan mau tanya, bagaimana cara meliat colum pada table sudah terisi atau tidak dengan menggunakan fungsi IF
kasusx jika table sudah terisi maka akan di arahkan ke activity lain
if(table sudah ada isi) {
activity2 muncuk
}else{
activity 1 muncul mohon pencerahan gan
}

mas, saya buat databse multitable seperti contoh comment sebelumnya, tidak ada yng error di listing program, tp saat di running, saya liat ke file manager, databasenya tidak terbuat. itu knpa ya? mohon bantuanya 🙂

mas, saya udah buat sama persis seperti punyanya mas tapi kok eror kayak gini mas “java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.yudha.e_ktp_project/com.example.yudha.e_ktp_project.MainActivity3}: android.database.sqlite.SQLiteException: near “(“: syntax error (code 1): , while compiling: create table ktp( _id integer primary key autoincrement, namavarchar(50) not null,nikvarchar(50) not null,tempatvarchar(50) not null,tglvarchar(50) not null,alamatvarchar(100) not null,kecvarchar(50) not null,kelvarchar(50) not null,sexvarchar(10) not null,jobvarchar(50) not null,agamavarchar(10) not null,kpvarchar(2) not null,statusvarchar(10) not null);” mohon pencerahannya