예제 #1
0
  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();
  }
예제 #2
0
 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();
 }
예제 #3
0
  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();
  }
예제 #4
0
  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();
    }
  }
예제 #5
0
 public void delete(View view) {
   SQLiteDatabase database = dbHelper.getWritableDatabase();
   database.delete(MyDatabaseHelper.TABLE_BOOK, "name = ?", new String[] {"Learn Android From 0"});
   database.close();
 }