如何检索与字段关联的对象列表到实体类中?
问题内容:
当我按客户的任何字段对客户进行罚款时,一切顺利,我得到了返回了全局对象的JSON。
我正在编写代码以按 客户 的 lastName 罚款。客户实体具有和对象,其中声明了 lastName
字段。所以我希望我的端点像第一种情况一样返回客户全局对象。
我已经进入邮递员状态200正常,但是身体空着。有什么办法吗?谢谢
这是一个样本。 在prefBillAddressUid和prefShipAddressUid对象中都声明了lastName字段
@Entity
@Table(name = "tcustomer")
public class Customer implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@SequenceGenerator(name = "pk_sequence",sequenceName = "sequence_tcustomer",initialValue = 1000, allocationSize = 100)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "pk_sequence")
private Long uidpk;
@Column(name = "user_id", nullable=false)
private String userId;
@OneToOne(cascade = CascadeType.ALL)
@JoinColumn(name = "pref_bill_address_uid")
private CustomerAddress prefBillAddressUid;
@OneToOne(cascade = CascadeType.ALL)
@JoinColumn(name = "pref_ship_address_uid")
private CustomerAddress prefShipAddressUid;
...
//getters and setters
//constructors
}
我的资料库
@Query(value = "SELECT c FROM CustomerAddress c WHERE c.lastName = :lastName")
CustomerAddress findByLastName( @Param("lastName") String lastName);
实施服务
@Override
public CustomerAddressDto findByLastName(String lastName) {
CustomerAddress result = customerRepository.findByLastName(lastName);
return customerAddressMapper.customerAddressToCustomerAddressDto(result);
}
这是我的资源
@GetMapping(SEARCH_CUSTOMER_LAST_NAME_ENDPOINT)
@ResponseStatus(value = HttpStatus.OK)
@ApiResponses(value = {
@ApiResponse(code = 200, message = "OK", response = CustomerAddressDto.class),
@ApiResponse(code = 500, message = "Unexpected error", response = CustomerAddressDto.class)
})
@Timed
public ResponseEntity getCustomerByLastName ( @PathVariable String lastName) throws URISyntaxException {
if (log.isDebugEnabled()){
log.debug("[CustomerResource] GET {} : Retrieving Customer ({})", SEARCH_CUSTOMER_LAST_NAME_ENDPOINT, lastName);
}
CustomerAddressDto customerAddressDto = customerService.findByLastName(lastName);
return Optional.ofNullable(customerAddressDto)
.map(result->{
if (log.isDebugEnabled()){
log.debug("[CustomerResource] Customer ({}) retrieved", result.getLastName());
}
return new ResponseEntity<>(HttpStatus.OK);
})
.orElse(new ResponseEntity(new ResponseError(HttpStatus.NOT_FOUND.getReasonPhrase(),
"The Customer with lastName " + lastName + " does not exists"), null,HttpStatus.NOT_FOUND)
);
}
customerAddress类
@Entity
@Table(name="taddress")
public class CustomerAddress implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@SequenceGenerator(name = "pk_sequence",sequenceName = "sequence_taddress",initialValue = 1000, allocationSize = 100)
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "pk_sequence")
private Long uidpk;
@Column(name = "last_name")
private String lastName;
@Column(name = "first_name")
private String firstName;
@Column(name = "phone_number")
private String phoneNumber;
@Column(name= "fax_number")
private String faxNumber;
@Column(name = "street_1")
private String street1;
@Column(name= "street_2")
private String street2;
@Column(name= "city")
private String city;
@Column(name= "sub_country")
private String subCountry;
@Column(name= "zip_postal_code")
private String zipPostalCode;
@Column(name= "country")
private String country;
@Column(name = "commercial")
private Boolean commercial;
@Column(name = "guid", nullable=false)
private String guid;
@Column(name = "customer_uid")
private Long customerUid;
@Column(name= "type")
private String type;
@Column(name = "organization")
private String organization;
...
//getters ans setters
}
问题答案:
首先,您不能从CustomerRepository返回CustomerAddress。
一些替代方案是
- 要根据中的姓氏检索CustomerAddress
CustomerRepository
,您可以执行以下操作
Customer findByPrefBillAddressUid_LastName(String lastName);
spring-
data将制定查询,您不需要@Query
。但是请注意,如果Customer
不是,则返回类型CustomerAddress
。因此,您将获得具有正确的customerAddress的客户对象。
- 如果要返回CustomerAddress,则需要创建CustomerAddressRepository并编写这样的方法
CustomerAddress findByLastName(String lastName);
- 使用投影 创建这样的界面
interface CustomerShort { CustomerAddress getPrefBillAddressUid();
}
然后您的CustomerRepository需要使用这样的方法
interface CustomerRepository extends CRUDRepository<Customer, UUID> {
Collection<CustomerShort> findByPrefBillAddressUid_LastName(String lastName);
}