crudrepository findBy方法签名有多个in运算符？ [英] crudrepository findBy method signature with multiple in operators?

问题描述

我有这样的实体类：

@Entity
@Table(name = "EMAIL")
class Email{
    @Id
    @Column(name = "Id")
    Long id;
    @Column(name = "EMAIL_ID")
    String emailId;
    @Column(name = "PIN_CODE")
    String pincode;
}

如何写 findBy 使用crudrepository spring data jpa进行以下查询的方法？

How to write findBy method for the below query using crudrepository spring data jpa?

select email_id,name from email_details where eamil_id in('[e-mail]','[e-mail]') and pin_code in('633677','733877')

我期待如下的spring数据jpa方法但是如何构建它？

I am expecting the spring data jpa method like the below but how to construct it?

List<Email> findBy.....(List<String> emails, List<String> pinCodes);

我想在单个数据库中获取电子邮件列表。

I want to get list of Emails in a single database hit.

推荐答案

以下签名将：

List<Email> findByEmailIdInAndPincodeIn(List<String> emails, List<String> pinCodes);

Spring Data JPA支持大量关键字来构建查询。 IN 和 AND 就在其中。

Spring Data JPA supports a large number of keywords to build a query. IN and AND are among them.

这篇关于crudrepository findBy方法签名有多个in运算符？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！