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;
}
public boolean insert(Book book) {
boolean inserted = false;
try {
open();
ContentValues contentValues = new ContentValues();
contentValues.put(DBHelper.KEY_TITLE, book.getTitle());
contentValues.put(DBHelper.KEY_AUTHOR, book.getAuthor());
long id = getDB().insert(DBHelper.TABLE_BOOKS, null, contentValues);
inserted = -1 != id;
close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close();
}
return inserted;
}