hibernate 根据外键作为条件查询

最新推荐文章于 2020-05-27 15:33:03 发布

wzyoung

最新推荐文章于 2020-05-27 15:33:03 发布

阅读量5k

点赞数

分类专栏： hibernate java 文章标签： Java Hibernate 面向对象

本文链接：https://blog.csdn.net/wzyoung/article/details/8868670

版权

java 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

hibernate

3 篇文章 0 订阅

订阅专栏

List rooms = getHibernateTemplate().find("from Room room where room.roomName = '" + room.getRoomName()+ "'" + " and room.house_id = "+ room.getHouse().getId());

设计是：room->house ManyToOne 单向的关系

hibernate会自动在room表中生成house_id外键，所以最开始用的是room.house_id，会报错：

org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: house_id of: com.StringBeans.entity.core.Room [from com.StringBeans.entity.core.Room room where room.roomName = '1232131' and room.house_id = 1]; nested exception is org.hibernate.QueryException: could not resolve property: house_id of: com.StringBeans.entity.core.Room [from com.StringBeans.entity.core.Room room where room.roomName = '1232131' and room.house_id = 1]

应该用面向对象的思想，即room.house.id