Beispiel #1
0
  public boolean update(Book book) {
    boolean updated = false;

    try {
      open();

      ContentValues cv = new ContentValues();
      cv.put(DBHelper.KEY_TITLE, book.getTitle());
      cv.put(DBHelper.KEY_AUTHOR, book.getAuthor());

      updated =
          getDB()
                  .update(
                      DBHelper.TABLE_BOOKS,
                      cv,
                      DBHelper.KEY_ID + " = ?",
                      new String[] {String.valueOf(book.getId())})
              > 0;

      close();
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      close();
    }

    return updated;
  }
Beispiel #2
0
  public boolean delete(Book book) {
    boolean deleted = false;

    try {
      open();
      String whereClause = DBHelper.KEY_ID + " = " + book.getId();
      deleted = getDB().delete(DBHelper.TABLE_BOOKS, whereClause, null) > 0;
      close();
    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      close();
    }

    return deleted;
  }