SpringJPA。如何使用@Query仅获取ID列表

Question

我试图写这个来获取列表，我必须将ID列表作为参数传递：

@Query(value = "SELECT OutbreakDiagnosticTests FROM OutbreakDiagnosticTests WHERE OutbreakDiagnosticTests.outbreaks  in (:outbreakIds) ")
List<OutbreakDiagnosticTests> getDiagnosticTestsByOutbreaks(@Param("outbreakIds") List<Long> outbreakIds);

我的实体是我用来查询的实体是：

@Entity
@EntityListeners(OutbreakDiagnosticTestManagerImpl.class)
@Table(name = "outbreak_diagnostic_tests")
public class OutbreakDiagnosticTests extends AbstractTemporalWorkingData implements Serializable{
  
/**
   * 
   */
  private static final long serialVersionUID = 636298998880960358L;

  @Id
  @Column(nullable = false, name = "obdt_id")
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private long obdtId;

  @Column(nullable = false, name = "nature", length = 255)
  private String nature;

  @Column(nullable = true, name = "diagnostic_test_req", length = 255)
  private String diagnosticTestReq;

  @OneToMany(mappedBy = "outbreakDiagnosticTests", cascade = CascadeType.ALL, orphanRemoval = true)
  @Filter(name = "workingData")
  private Set<TestsResults> testsResults;

  @ManyToOne
  @JoinColumn(name = "outbreak_id", nullable = false)
  private Outbreaks outbreaks;

  @ManyToOne
  @JoinColumn(name = "diag_test_id", nullable = true)
  private DiagnosticTests diagTests;

  @ManyToOne
  @JoinColumn(name = "lab_id", nullable = true)
  private Laboratories lab;

  @Column(nullable = false, name = "is_field")
  private Boolean isField = false;

但我在运行后遇到了以下异常：

Error creating bean with name 'labTestSummariesDaoImpl': Unsatisfied dependency expressed through field 'obDiagTestRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'outbreakDiagnosticTestRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List com.wahisplus.wcommon.repository.outbreak.OutbreakDiagnosticTestRepository.getDiagnosticTestsByOutbreaks(java.util.List)!

有人能帮我用上面的方法获取列表吗？或者能告诉我我在这方面做错了什么。我不想使用本机，即（nativeQuery=true）使用这个。

Answer 1

由于您已经在使用Spring Data JPA，因此提供了一种方法OOTB：List findAllById（Iterable id）；

这个方法接收一个非空ID列表，并根据这些ID返回记录。既然您没有使用DTO概念，也没有为大量ID获取al列，那么为什么不使用此方法进行处理呢。

Answer 2

使用别名，如OutbreakDiagnosticsts o，对于select id，使用o。id并确保自动连线正确

@Query(value = "SELECT o FROM OutbreakDiagnosticTests o WHERE o.outbreaks.id IN (:outbreakIds) ")
List<OutbreakDiagnosticTests> getDiagnosticTestsByOutbreaks(@Param("outbreakIds") List<Long> outbreakIds);