Simple JPA Queries

// Update record
Query query = XPersistence.getManager().createQuery("FROM Students s WHERE s.id = :id");
query.setParameter("id", id);

Students student = (Students) query.getSingleResult();

student.setName("Juan dela Cruz");
student.setAddress("Philippines");

// Update all record
Query query = XPersistence.getManager().createQuery("FROM Students s");

for (Object record : query.getResultList()) {
    Students student = (Students) record;

    student.setSection("BSIT-4B");
}

// Select record
Query query = XPersistence.getManager().createQuery("FROM Students s WHERE s.id = :id");
query.setParameter("id", id);

Students student = (Students) query.getSingleResult();

String getName = student.getName();
String getAddress = student.getAddress();

// Select all record
Query query = XPersistence.getManager().createQuery("FROM Students s");

Students student = (Students) query.getSingleResult();

for (Object record : query.getResultList()) {
    Students student = (Students) record;

    System.out.println("Name: " + student.getName());
}