Question

在hibernate和Spring自动生成的dao中如何根据外键来查询数据

我自己写的

报错 could not resolve property: yxBzj of: cn.com.yx.entity.YxBorad[from cn.com.yx.entity.YxInvition as model where model.yxBorad = ?];nested exception is org.hibernate.QueryException: could not resolve property: yxBzj of: cn.com.yx.entity.YxBorad [from cn.com.yx.entity.YxInvition as model where model.yxBorad = ?]
问题已经结局，在hql语句中我用字符串拼接不用预编译，同时用String queryString = "from YxInvition as model where model.yxBorad.yxBZj ="+ id;问题可以解决！当然这肯定不是最好的办法 嘿嘿！希望有更好的方法

Answer 1

你的级联查询变量使用错误..
String hql = "from YxInvition as model where model.yxBorad.id = ?"
....
queryObject.setParameter(0, yxBorad.id);
....

这样才是级联查询的正确用法.

Answer 2

你配置文件写错了吧，好好检查下字段名