Hibernate命令式SQL查询的两种方式

<query name="getTeacherNotInClasses">
       <![CDATA[from Classes where id not in (select t.classes.id from Teacher t where t.id=:teacherid)]]>
  </query>

  <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>

 

 

测试代码：
List people = sess.getNamedQuery("persons")
    .setString("namePattern", namePattern)
    .setMaxResults(50)
    .list();