public void ConsumirItem(int idItemCultural, int idLista) { try { String query = "SELECT id FROM Rel_Lista_Itens WHERE idItemCultural = " + idItemCultural + " and idListaCultural = " + idLista + ""; baseDao = new BaseDao(dh.getConnectionSource(), Rel_Lista_Itens.class); GenericRawResults<Rel_Lista_Itens> raw = baseDao.queryRaw( query, new RawRowMapper<Rel_Lista_Itens>() { @Override public Rel_Lista_Itens mapRow(String[] columnNames, String[] results) throws SQLException { return (Rel_Lista_Itens) baseDao.queryForId(Integer.parseInt(results[0])); } }); for (Rel_Lista_Itens rel_lista_itens : raw) { rel_lista_itens.setConsumido(true); baseDao.update(rel_lista_itens); } } catch (SQLException e) { } }