/** * @param id * @throws Exception */ public static void setDelivered(Long id) throws Exception { IGenericDao dao = null; try { dao = Utility.getDbConnection(); String sql = "UPDATE QUEUE SET DELIVERED = 1 WHERE ID = ?"; dao.executeUpdate(sql, new Object[] {id}); } finally { JdbcUtil.close(dao); dao = null; } }