Parameter Binding

Mina Park·2022년 10월 4일
0

1. 종류

  • 이름 기반
  • 위치 기반(미사용 권장)
select m from Member m where m.username = :name //이름 기반
select m from Member m where m.username = ?0 //위치 기반

2. 예시


	//객체 파라미터 바인딩
	@Query("select m from Member m where m.username = :name")
	Member findMembers(@Param("name") String username);

	//컬렉션 파라미터 바인딩 => collection 타입으로 in절 지원
	@Query("select m from Member m where m.username in :names")
    List<Member> findByNames(@Param("names") List<String> names);
select
        member0_.member_id as member_i1_0_,
        member0_.age as age2_0_,
        member0_.team_id as team_id4_0_,
        member0_.username as username3_0_ 
    from
        member member0_ 
    where
        member0_.username in (
            ? , ?
        )

0개의 댓글