Hibernate SQL自连接技术总结
在PL/SQL中执行SQL一下自连接语句:
select o.fullname_,p.fullname_ from fw_organization_view o left join fw_organization_view p on o.parentid_=p.id_ where o.id_=30004;
可以正常执行得到结果:当前组织全称,父组织全称
但在Hibernate中执行以上脚本
StringBuffer sql=new StringBuffer("select o.fullname_,p.fullname_ from fw_organization_view o left join fw_organization_view p on o.parentid_=p.id_ where o.id_=:id");Query query = this.getSession().createSQLQuery(sql.toString());query.setLong("id", id);List<Object[]> list = query.list();Object[] obj = list.get(0);StringBuffer sql=new StringBuffer("select o.fullname_,p.fullname_ as parentName from fw_organization_view o left join fw_organization_view p on o.parentid_=p.id_ where o.id_=:id");Query query = this.getSession().createSQLQuery(sql.toString());query.setLong("id", id);List<Object[]> list = query.list();Object[] obj = list.get(0);