package Collection.Order; import java.io.File; import java.util.Iterator; import java.util.Set; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; publicclass Test ...{ publicstaticvoid main(String[] args) ...{ String filePath=System.getProperty("user.dir")+File.separator+"src/Collection/Order"+File.separator+"hibernate.cfg.xml"; File file=new File(filePath); System.out.println(filePath); SessionFactory sessionFactory=new Configuration().configure(file).buildSessionFactory(); Session session=sessionFactory.openSession(); Transaction t=session.beginTransaction(); Team team=(Team)session.createQuery("from Team t where t.teamname='team1'").uniqueResult(); Set result=team.getStudents(); for (Iterator iterator = result.iterator(); iterator.hasNext();) ...{ Student object = (Student) iterator.next(); System.out.println(object.getName()); } t.commit(); } }
测试结果:
Hibernate: select team0_.id as id1_, team0_.teamname as teamname1_ from teamOrder team0_ where team0_.teamname='team1' Hibernate: select students0_.team_id as team4_1_, students0_.id as id1_, students0_.id as id0_0_, students0_.name as name0_0_, students0_.description as descript3_0_0_, students0_.team_id as team4_0_0_ from studentOrder students0_ where students0_.team_id=? order by students0_.name desc c b a
使用order-by属性,我们可以通过hbm文件执行生成的SQL如何使用order by 查询子句以返回排序后的结果集数据库结构: create table teamOrder (id varchar(32),teamname varchar(32));create table studentOrder (id varchar(32),name varchar(32),descri