我想通过bedType搜索春季数据jpa。但是,bedType不是字符串。不是String bedType,而是BedType bedType(Object)。这是我的资料库
@Query("select a,b.bedType,b.roomCategory from RoomDetail a left outer join RoomMaster b on a.roomId = b.id where lower(b.bedType) like %:bedType%")
<Page>RoomDetail findByBedType(
@Param("bedType") BedType bedType,
Pageable paging);
FindRoomStatus.Java
public class FindRoomStatus {
private BedType bedType;
public BedType getBedType() {
return bedType;
}
public void setBedType(BedType bedType) {
this.bedType = bedType;
}
在我的控制器中,我遇到了错误
字符串不能转换为BedType
data = roomDetailRepository.findByBedType(findRoomStatus.getBedType().toString(), paging);
这是BedType.Java
public class BedType implements Serializable{
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY, generator = "bed_type_seq")
@SequenceGenerator(name = "bed_type_seq", sequenceName = "bed_type_id_bed_type_seq", allocationSize = 1, initialValue = 1)
private int id;
@Column(name = "bed_type_name", length = 20)
private String bedTypeName;
@JsonIgnore
@Column(name = "status", length = 10)
private String status;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getBedTypeName() {
return bedTypeName;
}
public void setBedTypeName(String bedTypeName) {
this.bedTypeName = bedTypeName;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
列出房间状态,在此列表中,我想按BedType查找
{
"id": 105,
"roomId": 43,
"floor": "1",
"roomNumber": "001",
"description": "Normal",
"status": "Vacant Clean"
},
{
"id": 11,
"bedTypeName": "King size"
},
{
"id": 39,
"categoryName": "President Suite"
}
最佳答案
您在查询中使用LIKE
关键字,但在查询中接受BedType
对象作为参数。您正在从控制器发送String
作为参数。这就是问题。 toString
方法将给出对象的字符串表示形式。
您可以做的是,将参数更改为String
,它接受bedTypeName
,如下所示:
@Query("select a,b.bedType,b.roomCategory from RoomDetail a left outer
join RoomMaster b on a.roomId = b.id where lower(b.bedType.bedTypeName) like
%:bedTypeName%")
<Page>RoomDetail findByBedType(
@Param("bedTypeName") String bedTypeName,
Pageable paging);
从控制器
data = roomDetailRepository.findByBedType(findRoomStatus.getBedType().getBedTypeName(),
paging);