SpringData jparepository和/或运算符

Question

我需要使用JParePository执行以下操作：

select * from table
where
(
  propertyTwo like '%something%'
  or propertyThree like '%something%'
  or propertyFour like  '%something%'
)
and propertyOne in (a,b);

我目前这样做：

findByPropertyOneInAndPropertyTwoContainingOrPropertyThreeContainingOrPropertyFourContaining(List param1, String param2, String param3, String param4)

select * from table
where
  propertyTwo like '%something%'
  or propertyThree like '%something%'
  or propertyFour like  '%something%'
  and propertyOne in (a,b);

Answer 1

就像斯拉瓦说的，你应该做：

@Query("from table t where t.propertyOne in :param1 and (t.propertyTwo like :param2 or t.propertyThree like :param3 or t.propertyFour like :param4)")
List<Table> findByParams(@Param("param1") List<String> param1, @Param("param2") String param2, @Param("param3") String param3, @Param("param4") String param4);