Question

sql语句怎么转成java的持久层框架heibernate里的hql？

"select fbf.*,fbb.bankname name,mf.firmType firmType,ff.bankcode mainBank " +
",case when mf.firmtype<>'C' then fbf.firmid else (select nvl(memberno,'') from m_customerinfo mc where mc.customerno=fbf.firmid) end belevemember,cms.opentype " +
" from f_b_firmidandaccount fbf,f_b_banks fbb,m_firm mf,F_FirmFunds ff,v_customerrelateorganization mc,cms_m_customerinfo cms " +
" where fbf.bankid=fbb.bankid(+) and fbf.firmid=mf.firmid(+) and fbf.firmid=ff.firmid(+) and mc.customerno=fbf.firmid and fbf.firmid = cms.customerno(+) " + filter;

最后的filter是个变量 传入的。

Answer 1

表名换成类名，字段名换成类里面的属性名。按照hibernate的xml配置文件一一对应就可以了。其他的不用改

Answer 2

sql不能转化为hql 只能自己重新写了