JPQLの作成方法

🖊 JPQL構文

select m from Member m where m.age > 26

TypeQuery, Query

TypedQuery<Member> query = 
	em.createQuery("select m from Member m where m.age > 26", Member.class);

Query query = 
	em.createQuery("select m .age, m.username from Member m where m.age > 26");

クエリ結果API

TypedQuery<Member> query = 
	em.createQuery("select m from Member m where m.age > 26", Member.class);
    
List<Member> members = query.getResultList();

TypedQuery<Member> query = 
	em.createQuery("select m from Member m where m.id = 1", Member.class);
    
Member member = query.getSingleResult();

バインドパラメータ

int userAge = 100;
TypedQuery<Member> query = 
	em.createQuery("select m from Member m where m.age > :age", Member.class)
    	.setParameter("age", userAge);
    
List<Member> members = query.getResultList();

NamedQuery

Entity
@NamedQuery(
	name = "Member.findByUsername",
        query = select m from Member m where m.username = :username")
public class Member {
	...
}