how can i update a single record in jpa using jpql // Person p = em.find(Person.class, 1); // p.setState_Of_Origin("Plateau"); // em.merge(p); for the above you have to know the user id, which doesn't help much. I used the following methods below
Person update(EntityManager em,String setPerson,String getPerson)
{
TypedQuery<Person> m = em.createQuery("update Person b set b.State_Of_Origin =setPerson
where b.Firstname = ?1 ", Person.class);
m.setParameter(1, getPerson);
}
void Update(EntityManager em, String name)
{
TypedQuery<Person> m = em.createQuery("update Person p set p.State_Of_Origin = 'Plateau' where p.Firstname = ?1 ", Person.class);
int executeUpdate = m.setParameter(1,name).executeUpdate();
System.out.println(executeUpdate);
}