JPA中 IN 实战

最新推荐文章于 2022-05-03 10:29:17 发布

tian.tian

最新推荐文章于 2022-05-03 10:29:17 发布

阅读量957

点赞数

本文链接：https://blog.csdn.net/li_tiantian/article/details/99290404

版权

本文详细介绍了在Java Persistence API (JPA) 中如何使用IN操作符进行查询。通过示例展示了如何在 Criteria 查询、Repository 方法以及自定义SQL或HQL中应用IN来查询多个条目，帮助开发者更高效地处理数据检索任务。

摘要由CSDN通过智能技术生成

package tf56.payOnlineService.jpa.repository;

import java.util.Collection;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import tf56.payOnlineService.jpa.entity.PaymentApplyDetail;

public interface PaymentApplyDetailRepository extends JpaRepository<PaymentApplyDetail, Long> {

    PaymentApplyDetail findByPaymentApplyDetailCode(String paymentApplyDetailCode);

    Collection<PaymentApplyDetail> findByPaymentApplyDetailCodeIn(Collection<String> paymentApplyDetailCodes);
    
    @Query("from PaymentApplyDetail where paymentApplyDetailCode in ?1")
    Collection<PaymentApplyDetail> findByPaymentApplyDetailCodes(Collection<String> paymentApplyDetailCodes);
    
    Collection<PaymentApplyDetail> findByPaymentApplyDetailCodeInAndPaymentState(Collection<String> collection, Byte b);
    
    @Query("from PaymentApplyDetail where paymentApplyDetailCode in ?1 and paymentState = ?2")
    Collection<PaymentApplyDetail> findByPaymentApplyDetailCodesAndPaymentState(Collection<String> collection, Byte b);
    
}