spring jpa连接两个实体

Question

我正在努力使用jpa Crudepository接口连接两个实体模型。我不知道如何映射两个实体模型并在@query注释中编写查询。这些是我的实体类。我想执行这个查询“从taxi\u driver\u映射中选择dppd.payment\u plan\u id，dppd.attribute\u value，dppd.attribute\u id作为tdm加入driver\u payment\u plan\u细节作为dppd on dppd.payment\u plan”

@Getter
@Setter
@Entity
@ToString
@Table(name = "driver_payment_plan_details")
@NoArgsConstructor
public class DriverPaymentPlanDetails
{
@Id
@Column(name = "id")
private int id ;

@Column(name = "payment_plan_id")
private long paymentPlanId;

@Column(name = "attribute_id")
private int attributeId;

@Column(name = "attribute_value")
private float attributeValue;

}

@Getter
@Setter
@ToString
@Table(name = "taxi_driver_mapping")
@Entity
@NoArgsConstructor
public class TaxiDriverMapping
{
@Column(name = "mapping_id")
@Id
private Long mappingId;

@Column(name = "mapping_driverid")
private Long mappingDriverId;

@Column(name = "mapping_taxi_model_id")
private String mappingTaxiModelId;

@Column(name = "mapping_status")
private String mappingStatus;

@Column(name = "mapping_payment_plan_id")
private Long mappingPaymentPlanId;

}

Answer 1

谢谢你们展示了正确的路径，这是我的代码。

@Getter
@Setter
@ToString
@Table(name = "taxi_driver_mapping")
@Entity
@NoArgsConstructor
public class TaxiDriverMapping
{
@Column(name = "mapping_id")
@Id
private Long mappingId;

@Column(name = "mapping_driverid")
private Long mappingDriverId;

@Column(name = "mapping_taxi_model_id")
private String mappingTaxiModelId;

@Column(name = "mapping_status")
private String mappingStatus;

@Column(name = "mapping_payment_plan_id")
private Long mappingPaymentPlanId;

@OneToMany(mappedBy = "taxiDriverMapping")
private List<DriverPaymentPlanDetails> driverPaymentPlanDetails;

}

 @Getter
 @Setter
 @Entity
 @ToString
 @Table(name = "driver_payment_plan_details")
 @NoArgsConstructor
 public class DriverPaymentPlanDetails
 {
@Id
@Column(name = "id")
private int id ;

@Column(name = "payment_plan_id")
private long paymentPlanId;

@Column(name = "attribute_id")
private int attributeId;

@Column(name = "attribute_value")
private float attributeValue;

@ManyToOne()
@JoinColumn(name="payment_plan_id",insertable = false,updatable = false)
private TaxiDriverMapping taxiDriverMapping;

}