Page 90 - 24JAM_Pintar_Pemrograman_Android__1-libre

 24 JAM!! Pintar Pemrograman Android
43: db.execSQL(CREATE_TABLE);
44: }
45:
46: @Override
47: public void onUpgrade(SQLiteDatabase db, int oldVer, int
newVer) {
48: db.execSQL("DROP TABLE IF EXISTS " + NAMA_DB);
49: onCreate(db);
50: }
51: }
52:
53: public void close() {
54: dbHelper.close();
55: }
56:
57: public void addRow(String nama, String hobi) {
58:
59: ContentValues values = new ContentValues();
60: values.put(ROW_NAMA, nama);
61: values.put(ROW_HOBI, hobi);
62:
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
73: ArrayList<ArrayList<Object>>();
74: Cursor cur;
75: try {
76: cur = db.query(NAMA_TABEL, new String[] { ROW_ID, ROW_NAMA,
77: ROW_HOBI }, null, null, null, null, null);
78: cur.moveToFirst();
79: if (!cur.isAfterLast()) {
80: do {
81: ArrayList<Object> dataList = new ArrayList<Object>();
82: dataList.add(cur.getLong(0));
83: dataList.add(cur.getString(1));
84: dataList.add(cur.getString(2));
85: dataArray.add(dataList);
86: } while (cur.moveToNext());
87: }
88: } catch (Exception e) {
89: e.printStackTrace();
90: Log.e("DEBE ERROR", e.toString());
91: Toast.makeText(context, "gagal ambil semua
baris:"+e.toString(),Toast.LENGTH_SHORT).show();
92: }
93: return dataArray;
94: }
95:
96: public ArrayList<Object> ambilBaris(long rowId) {
97:
98: ArrayList<Object> arrbaris = new ArrayList<Object>();
Dapatkan materi terbaru di 90
www.omayib.com