public void update(View view) { SQLiteDatabase database = dbHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("price", 9.9); database.update( MyDatabaseHelper.TABLE_BOOK, values, "name = ?", new String[] {"Learn Android From 0"}); database.close(); }
public void retrieve(View view) { SQLiteDatabase database = dbHelper.getReadableDatabase(); Cursor cursor = database.query(MyDatabaseHelper.TABLE_BOOK, null, null, null, null, null, null); int count = 0; while (cursor.moveToNext()) { count++; } cursor.close(); database.close(); Toast.makeText(AtyUseDatabase.this, "total: " + count, Toast.LENGTH_SHORT).show(); }
public void add(View view) { SQLiteDatabase database = dbHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("author", "lovexiaov"); values.put("price", 99.0); values.put("page", 399); values.put("name", "Learn Android From 0"); database.insert(MyDatabaseHelper.TABLE_BOOK, null, values); Toast.makeText(AtyUseDatabase.this, "add data", Toast.LENGTH_SHORT).show(); database.close(); }
public void useTransaction(View view) { SQLiteDatabase database = dbHelper.getReadableDatabase(); database.beginTransaction(); try { database.delete(MyDatabaseHelper.TABLE_BOOK, null, null); if (false) { throw new RuntimeException(); } ContentValues values = new ContentValues(); values.put(MyDatabaseHelper.BOOK_NAME, "WTF"); values.put(MyDatabaseHelper.BOOK_AUTHOR, "lovexiaov"); database.insert(MyDatabaseHelper.TABLE_BOOK, null, values); database.setTransactionSuccessful(); } catch (RuntimeException e) { e.printStackTrace(); } finally { database.endTransaction(); database.close(); } }
public void delete(View view) { SQLiteDatabase database = dbHelper.getWritableDatabase(); database.delete(MyDatabaseHelper.TABLE_BOOK, "name = ?", new String[] {"Learn Android From 0"}); database.close(); }