在hql中多表关联查询返回VO实体类问题

qq363521369 2015-06-02 09:42:46

String hql = "select new com.lzyim.lm.virtualvo.Viorder(tor.id,tor.deliverytime,tor.replacetype,torde.good.id,torde.goodname,torde.price,torde.amount,tor.sendaddress,tor.company,tor.clientname,tor.totalprice,tor.fee,tor.storestaffname,tor.cardid,tor.remark,tor.orderprinttime,tor.orderstatus,torde.id,tor.client.id,torde.goodtype,torde.goodbrand,torde.tradename,tor.ordertype)from TOrder tor left join tor.orderDetailList  torde left join tor.store tors  where tor.chargeoffstatus=0"

报错

could not resolve property: orderDetailList of: com.lzyim.lm.vo.TOrder [select new com.lzyim.lm.virtualvo.Viorder(tor.id,tor.deliverytime,tor.replacetype,torde.good.id,torde.goodname,torde.price,torde.amount,tor.sendaddress,tor.company,tor.clientname,tor.totalprice,tor.fee,tor.storestaffname,tor.cardid,tor.remark,tor.orderprinttime,tor.orderstatus,torde.id,tor.client.id,torde.goodtype,torde.goodbrand,torde.tradename,tor.ordertype)from com.lzyim.lm.vo.TOrder tor left join tor.orderDetailList  torde left join tor.store tors  where tor.chargeoffstatus=0 and tors.id = ?and tor.ordertype=?and tor.orderstatus=? and tor.createtime>?  and tor.createtime< ?]; nested exception is org.hibernate.QueryException: could not resolve property: orderDetailList of: com.lzyim.lm.vo.TOrder [select new com.lzyim.lm.virtualvo.Viorder(tor.id,tor.deliverytime,tor.replacetype,torde.good.id,torde.goodname,torde.price,torde.amount,tor.sendaddress,tor.company,tor.clientname,tor.totalprice,tor.fee,tor.storestaffname,tor.cardid,tor.remark,tor.orderprinttime,tor.orderstatus,torde.id,tor.client.id,torde.goodtype,torde.goodbrand,torde.tradename,tor.ordertype)from com.lzyim.lm.vo.TOrder tor left join tor.orderDetailList  torde left join tor.store tors  where tor.chargeoffstatus=0 and tors.id = ?and tor.ordertype=?and tor.orderstatus=? and tor.createtime>?  and tor.createtime< ?]

好像原因是tor.orderDetailList没找到，orderDetailList和TOrder是实体类，怎么在实体类里面可以调用到另一个实体类啊？

...全文