表classes里的departid做为外键指向depart表的id;
在classes类里有Department类型的depart属性(不是departid)。我想根据这个depart属性查询所有classes。hql语句怎么写呢????????
在classes类里有Department类型的depart属性(不是departid)。我想根据这个depart属性查询所有classes。hql语句怎么写呢????????
得到的list
public List findClassByDepart(int departId) {
Session session = HibernateSessionFactory.getSessionFactory()
.openSession();
Transaction tx = null;
List list = null;
try {
tx = session.beginTransaction();
Query query = session
.createQuery("from Classes as class where class.departid=:departId");
query.setInteger("departId", departId);
list = query.list();
tx.commit();
} catch (HibernateException e) {
if (tx != null) {
tx.rollback();
}
e.printStackTrace();
} finally {
session.close();
}
return list; }