<query name="getTeacherNotInClasses">
<![CDATA[from Classes where id not in (select t.classes.id from Teacher t where t.id=:teacherid)]]>
</query>
***************************************************************************************************************
上面一句执行的HQL语句命令
<sql-query "name"="persons">
<return alias="person" "class"="eg.Person"/>
SELECT person.NAME AS {person.name}, person.AGE AS {person.age},person.SEX AS {person.sex}
FROM PERSON person
WHERE person.NAME LIKE :namePattern
</sql-query>//这代表的是执行SQL命令
******************************************************************************************************************************************
注意上面的带应该在hibernate.cfg.xml配置文件里配置
例如:
测试代码:
List people = sess.getNamedQuery("persons")
.setString("namePattern", namePattern)
.setMaxResults(50)
.list();