JPA:通过给定列的值列表获取实体列表

@Entity
@Table(name = "my_table")
public class MyEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String column1;
    private String column2;
    // 其他属性...

    // 查询方法
    @Query("SELECT e FROM MyEntity e WHERE e.column1 IN :values")
    List<MyEntity> findByColumn1Values(@Param("values") List<String> values);
}

// 在应用程序中执行查询
@Repository
public interface MyEntityRepository extends JpaRepository<MyEntity, Long> {
    List<MyEntity> findByColumn1Values(List<String> values);
}

// 调用查询方法
@Autowired
private MyEntityRepository repository;

List<String> column1Values = Arrays.asList("value1", "value2", "value3");
List<MyEntity> entities = repository.findByColumn1Values(column1Values);