Page 82 - 24JAM_Pintar_Pemrograman_Android__1-libre

 24 JAM!! Pintar Pemrograman Android
24: private final Context context;
25: private DatabaseOpenHelper dbHelper;
26: private SQLiteDatabase db;
27:
28: public DatabaseManager(Context ctx) {
29: this.context = ctx;
30: dbHelper = new DatabaseOpenHelper(context);
31: db = dbHelper.getWritableDatabase();
32: }
33:
34: private static class DatabaseOpenHelper extends
SQLiteOpenHelper {
35:
36: public DatabaseOpenHelper(Context context) {
37: super(context, NAMA_DB, null, DB_VERSION);
38: // TODO Auto-generated constructor stub
39: }
40:
41: @Override
42: public void onCreate(SQLiteDatabase db) {
43: // TODO Auto-generated method stub
44: db.execSQL(CREATE_TABLE);
45: }
46:
47: @Override
48: public void onUpgrade(SQLiteDatabase db, int oldVer, int
newVer) {
49: // TODO Auto-generated method stub
50: db.execSQL("DROP TABLE IF EXISTS "+NAMA_DB);
51: onCreate(db);
52:
53: }
54: }
55: public void close() {
56: dbHelper.close();
57: }
58:
59: public void addRow(String nama, String hobi) {
60: ContentValues values = new ContentValues();
61: values.put(ROW_NAMA, nama);
62: values.put(ROW_HOBI, hobi);
63: try {
64: db.insert(NAMA_TABEL, null, values);
65: } catch (Exception e) {
66: Log.e("DB ERROR", e.toString());
67: e.printStackTrace();
68: }
69: }
70:
71: public ArrayList<ArrayList<Object>> ambilSemuaBaris() {
72: ArrayList<ArrayList<Object>> dataArray = new
ArrayList<ArrayList<Object>>();
73: Cursor cur;
74: try {
75: cur = db.query(NAMA_TABEL,
76: new String[] { ROW_ID, ROW_NAMA, ROW_HOBI }, null, null,
77: null, null, null);
78: cur.moveToFirst();
Dapatkan materi terbaru di 82
www.omayib.com