JPA查关联对象为空、为null的 isNull isEmpty

3 篇文章 0 订阅

CriteriaBuilder

public class Test {
   	    @Autowired
        private ReceiptSourceRepository receiptSourceRepository;
        
        public void test() {
        Specification<ReceiptSource> spec= (Root<ReceiptSource> root, CriteriaQuery<?> query, CriteriaBuilder cb) -> {
            Predicate predicate = cb.conjunction();
            predicate = cb.and(predicate,cb.isNull(root.get("accountsEntity")));
            predicate = cb.and(predicate,cb.isEmpty(root.get("receiptsCostList")));
            query.where(predicate);
            return query.getRestriction();
        };
        List<ReceiptSource> receiptSourceList = receiptSourceRepository.findAll(spec);
        }
}
package com.allqj.finance.business.receipts.repository;

import com.allqj.finance.business.receipts.entity.ReceiptSource;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

@Repository
public interface ReceiptSourceRepository extends JpaRepository<ReceiptSource,String>, JpaSpecificationExecutor<ReceiptSource> {

}
package com.allqj.finance.business.receipts.entity;

import lombok.Getter;
import lombok.Setter;
import lombok.experimental.Accessors;
import org.hibernate.annotations.*;

import javax.persistence.*;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;
import java.util.List;

@Getter
@Setter
@Entity
@Table(name = "f_common_bussiness_receipt_source")
public class ReceiptSource implements Serializable {

    @Id
    @GenericGenerator(name = "guid", strategy = "guid")
    @GeneratedValue(generator = "guid")
    private String receiptSourceId;

    @ManyToOne
    @JoinColumn(name = "accountsId", referencedColumnName = "accountsId", updatable = false, insertable = false)
    private AccountsListEntity accountsEntity;

    @OneToMany(mappedBy = "receiptSource")
    private List<ReceiptsCost> receiptsCostList;
   
    public ReceiptSource() {
    }
}

在这里插入图片描述

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值