/** Update */
public boolean updateSetting(Setting set) {
if (set != null) {
ContentValues cv = new ContentValues();
cv.put(SQLiteDB.SId, set.getId());
cv.put(SQLiteDB.SItem, set.getItem());
cv.put(SQLiteDB.SValue, set.getValue());
try {
database.update(SQLiteDB.TABLE_SETTING, cv, SQLiteDB.SId + "=" + set.getId(), null);
} catch (Exception ex) {
ex.printStackTrace();
return false;
}
return true;
}
return false;
}
// delete item
public void deleteItem(Setting s) {
long id = s.getId();
System.out.println("Comment deleted with id: " + id);
try {
database.delete(SQLiteDB.TABLE_SETTING, SQLiteDB.SId + " = " + id, null);
} catch (Exception ex) {
ex.printStackTrace();
}
}
/** Get lastest id */
public int getLastId() {
int id = -1;
try {
Cursor cursor =
database.query(SQLiteDB.TABLE_SETTING, allColumns, null, null, null, null, null);
cursor.moveToLast();
Setting s = cursorToSetting(cursor);
id = s.getId();
cursor.close();
} catch (Exception ex) {
ex.printStackTrace();
}
return id;
}