JPQL: how to retrieve a List of data and set a value for each data in that list

So I have a entity Notification, that has a boolean attribute readStatus to determine of a notification has been read or not. When I click a button, I w开发者_Python百科ant to write a JPQL that retrieve the unread notifications (readStaus=false) and set the readStatus of those unread notifications to true

Note: I dont want to write jpql to retrieve the list and manually loop through the list to set the readStatus and merge them back to the database

---

Here is the solution

UPDATE Notification n SET n.readStatus = true WHERE n.readStatus = false

---

List<Notification> notifications = 
    em.createQuery("select n from Notification n where n.readStatus = false")
      .getResultList();
for (Notification n : notifications) {
    n.setReadStatus(true);
}