美好的一天 .
所以我有映射@Id @GeneratedValue(strategy = GenerationType.SEQUENCE,generator =“discount_fares_id_sequence”)@SequenceGenerator(name =“discount_fares_id_sequence”,sequenceName =“discount_fares_id_seq”,allocationSize = 1)private Long id;
@Column
private Long discount;
@Column(name = "fare_code", length = 255)
private String fareCode;
@ManyToOne
@JoinColumn(name = "aircompany_id", foreignKey = @ForeignKey(name = "fk_discfares_ref_aircompany_id"))
private AircompanyRB aircompanyId;
我如何使用投影仅提取
discountFare id discount fareCode和aircompany_id(AircompanyRB的关键)
基本上所有DiscountFares的字段加上只有AircompanyRB的密钥?
我试过了
DetachedCriteria criteria = DetachedCriteria.forClass(DiscountFares.class)
.createCriteria("aircompanyId")
.setProjection(Projections.projectionList()
.add(Projections.property("id"))
.add(Projections.property("discount"))
.add(Projections.property("fareCode")));
List<DiscountFares> result = criteria.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
但它抛出异常,说AircompanyRB没有字段“折扣”(是的,它没有 - DiscountFares有)
非常感谢你!任何帮助都非常感谢
1 回答
首先,通过使用Criteria查询而不是简单的简单HQL查询,您将使您的生活变得困难:
现在,如果您真的想使用Criteria,只需翻译上面的查询: