Pengenalan Batabase di JavaAndroid

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();
	}	
	}
}

SEMOGA BERMANFAAT

---