Spring加入标准构建器

Question

我有两个具有OneToOne关系的实体

我的问题是，我想添加一个if来查询实体运河中的codiCanal作为参数。

实体

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "solicitud_seq")
@SequenceGenerator(sequenceName = "solicitud_sequence", allocationSize = 1, name = "solicitud_seq")
@Column(nullable = false, updatable = false, name = "id_solicitud")
private Integer idSolicitud;
@OneToOne
@JoinColumn(name="codiCanal")
private Canal canal;
private Date dataInici;
private Date dataActualizacio;
private String idFactura;
private String estatSolicitud;

运河实体：

@Id
private String codiCanal;
private String nom;
private Integer idBanc;

这是我的标准生成器函数

@Override
public List<Solicitud> getSoliWithobject(Solicitud object, Pageable pageable) {
    List<Solicitud> solicitudes = soliRepo.findAll((Specification<Solicitud>) (root, cq, cb) -> {
        Predicate p = cb.conjunction();
        if (!StringUtils.isEmpty(object.getIdFactura())) {
            p = cb.and(p, cb.equal(root.get("idFactura"), object.getIdFactura()));
        }

        if (!StringUtils.isEmpty(object.getDataInici()) ) {
            p = cb.and(p, cb.between(root.get("dataInici"), object.getDataInici(),currentDate));
        }

        if (!StringUtils.isEmpty(object.getEstatSolicitud())) {
            p = cb.and(p, cb.equal(root.get("estatSolicitud"), object.getEstatSolicitud()));
        }´
return p;
    }, pageable).getContent();
    return solicitudes;
}

Answer 1

这个条件解决了我的问题：

if (!StringUtils.isEmpty(object.getCanal())) {
    p = cb.and(p, cb.equal(root.join("canal").get("codiCanal"), object.getCanal().getCodiCanal()));
}