sql语句转换成hql语句

[cuilei911]

String sql="select * from project where projectId not in(select projectId from LaborLicence) and companyId='"+companyId+"'";
谁能帮我将上述sql语句转换成hql---------------------------谢谢大家了
持久化后的java类和xml有
project.java project.xml
LaborLicence.java LaborLicence.xml

[zuguanqun]

from project as a where a.projectId not in(select b.projectId from LaborLicence as b) and a.companyId='"+companyId+"'";

[gougou851129]

楼上是对的 其实hql很简单的 只要把表转化为hibernate的类 然后写的时候as一个实例九可以了

[gongyali2005]

用CRITERIA吧.