class A{
private String id; public getId...(){...}
public setId...(){...}}class B{ private String id;
private A a; public getId....(){....}
public setId....(){....} public getA....(){.....}
public setA....(){.....}}
问题:查询B的实体集合 hql="from B"
查询条件等A的,所有B集合 hql="from B b where a.id=?" 这样写法是错误的有没有更简便的hql写法解决? jdbc就不用说了
private String id; public getId...(){...}
public setId...(){...}}class B{ private String id;
private A a; public getId....(){....}
public setId....(){....} public getA....(){.....}
public setA....(){.....}}
问题:查询B的实体集合 hql="from B"
查询条件等A的,所有B集合 hql="from B b where a.id=?" 这样写法是错误的有没有更简便的hql写法解决? jdbc就不用说了
hql="from B b where b.a.id=?"
QcBatchAssignEntity entity=(QcBatchAssignEntity)getHibernateTemplate().find(sql).get(0);
hql="from QcRoleAssignEntity qc where qc.qcAssignEntity="+entity;
List<QcRoleAssignEntity> list=getHibernateTemplate().find(hql);现在这样操作也不行,错误提示:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query
class="com.flex.cc.qc.batchassign.entity.QcBatchAssignEntity"
column="ASSIGN_ID" update="false" insert="true"
outer-join="true" lazy="false" >
</many-to-one>这是xml配置,,请朋友们
帮我看看
这种方法查你的hql语句不对,配置也不对