使用Hibernate Mapping文件中定义的SQL

< query  name ="getNotInClassesTeacher" > <![CDATA[ from Teacher where id not in ( select c.teachers.id from Classes c where c.id=:classesid ) ]]> </ query >

 

 

public  List getNotInClassesTeacher(String classesid)  ... {        Session session=this.getSession();        Query query=session.getNamedQuery("getNotInClassesTeacher");        query.setParameter("classesid", classesid);        return query.list();    }