亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

休眠從子表中選擇查詢

休眠從子表中選擇查詢

慕無忌1623718 2021-04-02 09:40:45
我很冬眠。我有兩個表具有一對多的關系。兩張表是:public class Pashmina implements Serializable {    @Id    @GeneratedValue(strategy = GenerationType.AUTO, generator = "sq_pashmina_id")    @SequenceGenerator(name = "sq_pashmina_id", sequenceName = "sq_pashmina_id")    @Column(name = "PASHMINA_ID")    private int pashminaId;    @Column(name = "PASHMINA_NAME")    private String pashminaName;    @Column(name = "PRICE")    private double price;    @Column(name = "ADDED_AT", insertable = false)    @Temporal(TemporalType.TIMESTAMP)    private Date addedAt;    @Column(name = "CATEGORY")    private String category;    @Column(name = "ENABLED", insertable = false)    private Character enabled;    @OneToMany(mappedBy = "colourId", fetch = FetchType.EAGER)    private Set<PashminaColour> pashminaColor  = new HashSet<PashminaColour>();    @OneToMany(mappedBy = "imageId", fetch = FetchType.EAGER)    private Set<Image> images  = new HashSet<Image>();    @OneToMany(mappedBy = "descriptionId", fetch = FetchType.EAGER)    private Set<Description> descriptions  = new HashSet<Description>();    //getter and setter method這是一個父類,它與Image表具有一對多關系public class Image implements Serializable {    @Id    @Column(name = "IMAGE_ID")    private int imageId;    @Column(name = "IMAGE_NAME")    private String imageName;    @JoinColumn(name = "PASHMINA_ID", referencedColumnName = "PASHMINA_ID")    @ManyToOne    private Pashmina pashmina;現在,我要使用其父類的ID(即pashminaId)imagenames從Image類中選擇一個例如:從TBL_IMAGE中選擇IMAGE_NAME,其中PASHMINA_ID ='some_digit';我如何在圖像類中傳遞pashminaId,因為沒有pashminaId它只有Parent類的Object創建Pashmina。那么,我該如何在休眠狀態下實現呢?
查看完整描述

1 回答

?
哈士奇WWW

TA貢獻1799條經驗 獲得超6個贊

當Hibernate對待對象而不是SQL表時,您可以簡單地pashmina從您的image對象訪問該對象,并且在查詢中您將對待Java對象/ POJO,因此可以通過對其進行訪問Image.pashmina.pashminaId。


因此,您可以編寫以下查詢:


String hql = "select I.imageName FROM Image I WHERE I.pashmina.pashminaId = 10";

Query query = session.createQuery(hql);

List results = query.list(); 


查看完整回答
反對 回復 2021-04-28
  • 1 回答
  • 0 關注
  • 165 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號