Cara Membuat SQLite Database Percobaan 1

buatlah project baru dengan nama percobaan1
kemudian jika project sudah dibuat tambahkan 1 file java pada folder src dan berinama DBAdapter.java nanti gambaran file akan seperti ini :
Ubahlah isi file atau kita modifikasi coding yang ada pada file activity_main.xml menj berikadi seperti berikut :
<RelativeLayout xmlns:android=”http://schemas.android.com/apk/res/android”
xmlns:tools=”http://schemas.android.com/tools”
android:layout_width=”match_parent”
android:layout_height=”match_parent”
android:paddingBottom=”@dimen/activity_vertical_margin”
android:paddingLeft=”@dimen/activity_horizontal_margin”
android:paddingRight=”@dimen/activity_horizontal_margin”
android:paddingTop=”@dimen/activity_vertical_margin”
tools:context=”.MainActivity” >
<TextView
android:id=”@+id/textView1″
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:text=”@string/hello_world” />
</RelativeLayout>
Hasil Layout dari langkah diatas seperti berikut :
Kemudian kita memodifikasi file MainActivity.java menjadi seperti coding dibawah ini :
package com.databaseadapter;
import android.app.Activity;
import android.os.Bundle;
public class MainActivity extends Activity {
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
DBAdapter db = new DBAdapter(this);
//—add 3 titles—
db.open();
long id;
id = db.insertTitle(“1234512345″,”Android Programmer’s Reference”,”Washington Press”);
id = db.insertTitle(“5432112345″,”Linux Programming”,”Bandung Press”);
id = db.insertTitle(“0987654321″,”Android Devlopment Life Cycle”,”Hongkong Press”);
db.close();
}
}
Perhatikan di Source code berikut data inilah yang akan ditampilkan pada database
Kemudian ubahlah file DBAdapter.java sehingga source codenya menjadi seperti berikut :
package com.databaseadapter;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class DBAdapter {
public static final String KEY_ROWID = “_id”;
public static final String KEY_ISBN = “isbn”;
public static final String KEY_TITLE = “title”;
public static final String KEY_PUBLISHER = “publisher”;
public static final String TAG = “DBAdapter”;
private static final String DATABASE_NAME = “books”;
private static final String DATABASE_TABLE = “titles”;
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_CREATE = “create table titles(_id integer primary key autoincrement, ” + “isbn text not null, title text not null, “+”publisher text not null);”;
private final Context context;
private static DatabaseHelper DBHelper;
private static SQLiteDatabase db;
public DBAdapter(Context ctx){
this.context = ctx;
DBHelper = new DatabaseHelper(context);
}
private static class DatabaseHelper extends SQLiteOpenHelper {
DatabaseHelper(Context context){
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db){
db.execSQL(DATABASE_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
Log.w(TAG, “Upgrading database from version ” + oldVersion +” To “+ newVersion +” , wich will destroy all old data”);
db.execSQL(“DROP TABLE IF EXISTS titles”);
onCreate(db);
}
}
public DBAdapter open() throws SQLException {
db = DBHelper.getWritableDatabase();
return this;
}
public void close(){
DBHelper.close();
}
public long insertTitle(String isbn, String title, String publisher){
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_ISBN, isbn);
initialValues.put(KEY_TITLE, title);
initialValues.put(KEY_PUBLISHER, publisher);
return db.insert(DATABASE_TABLE, null, initialValues);
}
public boolean deleteTitle(long rowId){
return db.delete(DATABASE_TABLE, KEY_ROWID + “=” + rowId, null) > 0;
}
public Cursor getAllTitles(){
return db.query(DATABASE_TABLE, new String[] {
KEY_ROWID,
KEY_ISBN,
KEY_TITLE,
KEY_PUBLISHER
}, null, null, null, null, null);
}
public Cursor getTitle(long rowId) throws SQLException{
Cursor mCursor = db.query(true, DATABASE_TABLE, new String[]{
KEY_ROWID,
KEY_ISBN,
KEY_TITLE,
KEY_PUBLISHER
}, null, null, null, null, null, null);
if(mCursor != null){
mCursor.moveToFirst();
}
return mCursor;
}
public boolean updateTitle(long rowId, String isbn, String title, String publisher){
ContentValues args = new ContentValues();
args.put(KEY_ISBN, isbn);
args.put(KEY_TITLE, title);
args.put(KEY_PUBLISHER, publisher);
return db.update(DATABASE_TABLE, args, KEY_ROWID + “=” + rowId, null) > 0;
}
}
Jika sudah runninglah project yang telah dibuat dan lihatlah datanya pada database
hasil running project :
untuk melihat data pada database silahkan ke menubar > windows > show view > other > kemudian klik file explorer
bukalah file explorer untuk melihat database