问题描述
Survey类里的设置:@ManyToMany@JoinTable(name="sur_que",joinColumns={@JoinColumn(name="s_id")},inverseJoinColumns={@JoinColumn(name="q_id")})我想要查询s_id=1的q_id以及Question的所有属性,用SQL语句实现:select * from question where q_id in(select q_id from sur_que sq where sq.s_id=1 ),或者用标的连接也行,关键是HQL语句是面向对象的,怎么处理?
解决方案
class SURQUE include class Survey and Question.HQL: From SURQUE sq where sq.Survey.id=1查询出来的是SURQUE集合,要取Question直接用SURQUE.Question就可以了。即SURQUE中,把s_id换成对象保存
时间: 2024-07-29 05:06:31