hai master - master yg budiman,
yg kgk budiman hai juga.. .

ane mw tanya nih.. .
ane khan bikin project android yg pke database sqlite.. .
nah ane dah ngikutin caranya dri tutorial" di mbah GOOGLE.. .
tpii selalu hasilnya

"FORCE CLOSE" mulu,
itupun saat project akan melakukan kontak dengan sqlite.. .
ane

ini script konek dbnya gan.. .

package com.ichiru.databaseandroid1.db;



import java.security.PublicKey;

import java.util.ArrayList;



import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;



public class DatabaseManajer {



 private static final String ROW_ID = "_id";

 private static final String ROW_NAMA = "nama";

 private static final String ROW_HOBI = "hobi";



 private static final String NAMA_DB = "DatabaseAndroidSatu";

 private static final String NAMA_TABEL = "hobiku";

 private static final int DB_VERSION = 1;



 private static final String CREATE_TABLE = "create table " + ""

 + NAMA_TABEL + "(" + ROW_ID

 + " integer PRIMARY KEY autoincrement, " + ROW_NAMA + " text,"

 + ROW_HOBI + " text)";



 private final Context context;

 private SQLiteDatabase db;

 private SQLiteOpenHelper dbHelper;

 

 public DatabaseManajer(Context ctx){

 this.context = ctx;

 dbHelper = new SQLiteOpenHelper(context, NAMA_DB, null, DB_VERSION) {

 

 @Override

 public void onUpgrade(SQLiteDatabase db, int oldVer, int newVer) {

 // TODO Auto-generated method stub

 db.execSQL("DROP TABLE IF EXIST "+NAMA_DB);

 onCreate(db);

 }

 

 @Override

 public void onCreate(SQLiteDatabase db) {

 // TODO Auto-generated method stub

 db.execSQL(CREATE_TABLE);

 }

 

 public void close(){

 dbHelper.close();

 }

 };

 

 db = dbHelper.getWritableDatabase();

 

 }

 public void addRow(String nama, String hobi){

 ContentValues values = new ContentValues();

 values.put(ROW_NAMA, nama);

 values.put(ROW_HOBI, hobi);

 try {

 db.insert(NAMA_TABEL, null, values);

 } catch (Exception e) {

 // TODO: handle exception

 Log.e("DB ERROR", e.toString());

 e.printStackTrace();

 }

 }

 

 public ArrayList<ArrayList<Object>> ambilSemuaBaris(){

 ArrayList<ArrayList<Object>> dataArray = new ArrayList<ArrayList<Object>>();

 Cursor cur;

 try {

 cur = db.query(NAMA_TABEL, new String[]{ROW_ID,ROW_NAMA,ROW_HOBI},null,null,null,null,null);

 cur.moveToFirst();

 if (!cur.isAfterLast()) {

 do {

 ArrayList<Object> dataList = new ArrayList<Object>();

 dataList.add(cur.getLong(0));

 dataList.add(cur.getLong(1));

 dataList.add(cur.getLong(2));

 dataArray.add(dataList);

 } while (cur.moveToNext());

 }

 } catch (Exception e) {

 // TODO: handle exception

 e.printStackTrace();

 Log.e("DEBE ERROR", e.toString());

 }

 return dataArray;

 }

 

 

}