Note :
- private
+ public
# protect
Anggap udah ada 2 file java.
1. Buku.java --> model
package model;
public class Buku {
//variabel :
private int id;
private String judul, pengarang;
//method :
// constructor :
public Buku() {}
public Buku (String judul, String pengarang) {
this.judul = judul ;
this.pengarang = pengarang ;
}
//method setter dan getter
public void setId (int id)
{
this.id = id;
}
public void setJudul (String judul)
{
this.judul = judul;
}
public void setPengarang (String pengarang)
{
this.pengarang = pengarang;
}
public int getId()
{
return this.id;
}
public String getJudul()
{
return this.judul;
}
public String getPengarang()
{
return this.pengarang;
}
@Override
public String toString()
{
return "Data Buku [nomor=" + id + ", judulnya "+judul + ", pengarangnya " +pengarang+"].";
}
}
2. BasisDataSQL -->com.example.database
package com.example.database;
import java.util.LinkedList;
import java.util.List;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.util.Log;
import android.widget.Toast;
import model.Buku; //tambahanBalu
public class BasisDataSQL extends SQLiteOpenHelper {
//Database Version
private static final int DATABASE_VERSION = 1;
//Database Name
private static final String DATABASE_NAME = "dbBuku";
public BasisDataSQL(Context konteks) {
super (konteks, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String query ="create table tblBuku(id INTEGER PRIMARY KEY AUTOINCREMENT,judulBuku TEXT,pengarangBuku TEXT)";
db.execSQL (query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
db.execSQL ("dROP TABLE IF EXIST tblBuku");
this.onCreate(db);
}
/**
* CRUD operations (create "add", read "get", update, delete) book + get all books + delete all books
*/
// Books table name
private static final String
NAMA_TABEL = "tblBuku";
// Books Table Columns names
private static final String KEY_ID = "id";
private static final String KEY_JUDUL = "judulBuku";
private static final String KEY_PENGARANG = "pengarangBuku";
private static final String[]
COLUMNS = { KEY_ID,KEY_JUDUL,KEY_PENGARANG };
public void addBook(Buku book){
Log.
d("tambahBuku", book.toString());
// 1. get reference to writable DB
SQLiteDatabase db =
this.getWritableDatabase();
// 2. create ContentValues to add key "column"/value
ContentValues values = new ContentValues();
values.put(KEY_JUDUL, book.getJudul()); // get title
values.put(KEY_PENGARANG, book.getPengarang()); // get author
// 3. insert
db.insert( NAMA_TABEL, // table
null, //nullColumnHack
values); // key/value-> keys = column names/ values = column values
// 4. close
db.close();
}
public Buku getBook(int id){
// 1. get reference to readable DB
SQLiteDatabase db =
this.getReadableDatabase();
// 2. build query
Cursor cursor =
db.query(
NAMA_TABEL, // a. table
COLUMNS, // b. column names
" id = ?", // c. selections
new String[] { String.
valueOf(id) }, // d. selections args
null, // e. group by
null, // f. having
null, // g. order by
null); // h. limit 15
// 3. if we got results get the first one
if (cursor != null)
cursor.moveToFirst();
// 4. build book object
Buku book =
new Buku();
book.setId(Integer.parseInt(cursor.getString(0)));
book.setJudul(cursor.getString(1));
book.setPengarang(cursor.getString(2));
Log.d("getBook("+id+")", book.toString());
// 5. return book
return book;
}
// Get All Books
public List getAllBooks() {
List books =
new LinkedList();
// 1. build the query
String query = "SELECT * FROM " + NAMA_TABEL ;
// 2. get reference to writable DB
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(query,null);
// 3. go over each row, build book and add it to list
Buku book = null;
if (cursor.moveToFirst()) {
do {
book =new Buku();
book.setId(Integer.parseInt(cursor.getString(0)));
book.setJudul(cursor.getString(1));
book.setPengarang(cursor.getString(2));
// Add book to books
books.add(book);
}
while (cursor.moveToNext());
}
Log.d("getAllBooks()", books.toString());
// return books
return books;
}
// Updating single book
public int updateBook(Buku book) {
// 1. get reference to writable DB
SQLiteDatabase db = this.getWritableDatabase();
// 2. create ContentValues to add key "column"/value
ContentValues values = new ContentValues();
values.put("title", book.getJudul());
// get title
values.put("author",book.getPengarang());
// get author
// 3. updating row
int i = db.update(NAMA_TABEL, //table
values, // column/value
KEY_ID+" = ?", // selections
new String[] { String.valueOf(book.getId()) });
//selection args
// 4. close
db.close();
return i;
}
// Deleting single book
public void deleteBook(Buku book) {
// 1. get reference to writable DB
SQLiteDatabase db = this.getWritableDatabase();
// 2. delete
db.delete(NAMA_TABEL,KEY_ID+" = ?",
new String[] { String.valueOf(book.getId()) });
// 3. close
db.close();
Log.d("deleteBook", book.toString());
}
public class MainActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.
activity_main);
BasisDataSQL db =new BasisDataSQL(this);
/**
* CRUD Operations
* */
// add Books
db.addBook(new Buku("Android Application Development Cookbook", "Wei Meng Lee"));
db.addBook(new Buku("Android Programming: The Big Nerd Ranch Guide", "Bill Phillips and Brian Hardy"));
db.addBook(new Buku("Learn Android App Development", "Wallace Jackson"));
// add Books
db.addBook(new Buku("Android Application Development Cookbook", "Wei Meng Lee"));
db.addBook(new Buku("Android Programming: The Big Nerd Ranch Guide", "Bill Phillips and Brian Hardy"));
db.addBook(new Buku("Learn Android App Development", "Wallace Jackson"));
// get all books
List list = db.getAllBooks();
// delete one book
db.deleteBook(list.get(0));
// get all books
db.getAllBooks();
Toast.makeText(getApplicationContext(), db.getAllBooks().toString(), Toast.LENGTH_LONG).show();
}
}
}
Klik disini untuk melanjutkan »»
