求解!java环境利用hibernate操作数据库求库存,有nvl函数,可是hibernate不支持nvl函数该怎么解决?
查出产品库存=入库-出库+退货数量select r.pronum,sum(r.num)-nvl(sum(f.num),0)+nvl(sum(t.num),0) as num
from (select pronum,SUM(num) as num from Ruku group by pronum) r
left join (select pronum,SUM(num) as num from Fahuo group by pronum)f on r.pronum=f.pronum
left join (select pronum,SUM(num) as num from Tuihuo group by pronum)t on r.pronum=t.pronum
group by r.pronum
我要用hibernate把它查询出来,返回个List
this.getSession.createQuery(String hql)
把sql 带进hql,可是hibernate不支持nvl这个函数,所以报错。我改怎么做才能 --------------------编程问答-------------------- 用 native sql 写吧 --------------------编程问答-------------------- 我不会啊
补充:Java , Java EE