如何对Postgresql数组进行JPA查询？

@Entity
public class YourEntity {
    @Id
    private Long id;

    @ElementCollection
    private List<String> yourArrayField;

    // Getters and setters
}

@Repository
public interface YourEntityRepository extends JpaRepository<YourEntity, Long> {
    @Query("SELECT e FROM YourEntity e WHERE :value MEMBER OF e.yourArrayField")
    List<YourEntity> findByArrayValue(@Param("value") String value);
}

@Repository
public interface YourEntityRepository extends JpaRepository<YourEntity, Long> {
    @Query(value = "SELECT * FROM your_entity_table WHERE :value = ANY(your_array_field)", nativeQuery = true)
    List<YourEntity> findByArrayValue(@Param("value") String value);
}

@Autowired
private YourEntityRepository repository;

public void yourMethod() {
    List<YourEntity> result = repository.findByArrayValue("yourValue");
    // 处理查询结果
}