以下是生成实体：

@Entity
@Table(name = "build")
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
public class Build {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "id")
    private Integer id;

    @ManyToOne(
            fetch = FetchType.EAGER,
            cascade = {CascadeType.MERGE, CascadeType.PERSIST, CascadeType.REFRESH})
    @JoinColumn(name = "job_id", referencedColumnName = "id", nullable = false)
    private Job job;

    @Column(name = "build_url", nullable = false)
    private String buildUrl;

    @Column(name = "status")
    private String status;

    @Column(name = "name", nullable = false)
    private String name;
}

下面是我与db执行事务的存储库：

public interface BuildRepository extends CrudRepository<Build, Integer> {

    List<Build> findByStatus(@Param("status") String status);

    @Transactional
    @Modifying(flushAutomatically = true, clearAutomatically = true)
    @Query(value = "update Build set status = ?2 where id = ?1")
    void updateBuildStatus(int id, String status);
}

如果必须获取特定id的条目，可以在存储库中使用findbyid（）。
现在，我想根据id、job和name从表中获取条目。id、作业和名称中至少有一个不为空。有人能帮我构建一个动态采石场来处理这个场景吗？