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) {
}
}
