SELECT * FROM customer
WHERE cust_country IN ('JP', 'KR', 'US');jpa의 List(컬렉션)를 넘기고 싶을 때가 있는데 그때는 in을 쓰면 된다.
em.createQuery("select c from customer where c.cust_country IN (:countrys)")
.setParameter("countrys",countrys)
.getResultList();↓
public interface CountryRepository extends JpaRepository<Country, Long> {
List<Country> findByCountryIn(Collection<Country> countrys)
}간단하게 바꿀 수 있다.
자세한 사용법은 아래 주소를 확인 해보자.
https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.query-methods.query-creation
Spring Data JPA - Reference Documentation
Example 109. Using @Transactional at query methods @Transactional(readOnly = true) interface UserRepository extends JpaRepository { List findByLastname(String lastname); @Modifying @Transactional @Query("delete from User u where u.active = false") void del
docs.spring.io
