Spring Data JPA检查对象是否在elementcollecion等于list的位置退出

@Entity
public class YourEntity {
    @ElementCollection
    @OrderColumn
    private List<String> yourList;
    // 其他字段和方法...
}

public interface YourEntityRepository extends JpaRepository<YourEntity, Long> {
    @Query("SELECT CASE WHEN :yourObject IN e.yourList THEN true ELSE false END FROM YourEntity e WHERE e.id = :id")
    boolean checkObjectInList(@Param("id") Long id, @Param("yourObject") String yourObject);
}

@Service
public class YourService {
    @Autowired
    private YourEntityRepository yourEntityRepository;

    public boolean checkObjectInList(Long id, String yourObject) {
        return yourEntityRepository.checkObjectInList(id, yourObject);
    }
}