Hibernate-用HQL写复杂语句

Question

select code,name from (select code ,userid,doctorid from expert where userid=?)a,(select doctorid ,userid,code from expertflow where code in (select code from user where userid=?))b where b.userid=a.doctorid

Answer 1

1.hibernate 操作的是对象，对于复杂的sql可以通过在库表中建立视图，然后就跟正常的表一样操作了。
2.通过jdbctemplate 操作sql