hibernate中Criteria查询

SessionFactory sessionFactory = new Configuration().configure()
	        .buildSessionFactory();
	Session session = sessionFactory.openSession();
	//创建Criteria对象
	Criteria criteria = session.createCriteria(User.class);
	//使用Criteria 的list()方法获得数据，list()方法返回List 实例
	List result = criteria.list();
	Iterator it = result.iterator();
	while (it.hasNext()) {
		User user = (User) it.next();
		System.out.println("用户名：" + user.getName());
	}
	session.close();
	sessionFactory.close();

 SessionFactory sessionFactory = 
            new Configuration().configure() .buildSessionFactory();
    Session session = sessionFactory.openSession();
    Criteria criteria = session.createCriteria(User.class);
	//使用add()添加查询条件
	//查询条件：name='admin'
	//返回条件实例
    criteria.add(Restrictions.eq("name", "bob"));
    List result = criteria.list();
    Iterator it = result.iterator();
    while (it.hasNext()) {
        User user = (User) it.next();
        System.out.println("用户名：" + user.getName());
    }
    session.close();
    sessionFactory.close();

SessionFactory sessionFactory = 
        new Configuration().configure().buildSessionFactory();
    Session session = sessionFactory.openSession();
    Criteria criteria = session.createCriteria(House.class);
    criteria.add(Restrictions.or(
            Restrictions.eq("price", new Double(2300)),
            Restrictions.like("title", "%地铁%")));
    List result = criteria.list();
    Iterator it = result.iterator();
    while (it.hasNext()) {
        House house = (House) it.next();
        System.out.println("标题：" + house.getTitle());
    }
    session.close();
    sessionFactory.close();

House house = new House();
house.setPrice(new Double(2000));
house.setFloorage(new Integer(40));
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria criteria = session.createCriteria(House.class);
criteria.add(Example.create(house));
List results = criteria.list();
Iterator it = results.iterator();
while(it.hasNext()){
    House h= (House)it.next();
    System.out.println("标题："+h.getTitle()+"  价格"+h.getPrice());
}
session.close();
sessionFactory.close();

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
Session session = sessionFactory.openSession();
Criteria criteria = session.createCriteria(House.class);
criteria.setFirstResult(3);
criteria.setMaxResults(2);
List results = criteria.list();
Iterator it = results.iterator();
while(it.hasNext()){
	House h = (House)it.next();
	System.out.println("标题："+h.getTitle()+ "  价格："+h.getPrice());			
}
session.close(); 
sessionFactory.close();

Hibernate: select * from ( select row_.*, rownum rownum_ from ( select this_.id as id4_3_, 
this_.user_id as user2_4_3_, this_.type_id as type3_4_3_, this_.street_id as street4_4_3_, 
this_.title as title4_3_, this_.price as price4_3_, this_.pubdate as pubdate4_3_, this_.floorage as
 floorage4_3_, this_.contact as contact4_3_, user2_.id as id0_0_, user2_.name as name0_0_, 
user2_.password as password0_0_, user2_.telephone as telephone0_0_, user2_.username as 
username0_0_, user2_.isadmin as isadmin0_0_, type3_.id as id3_1_, type3_.type_name as type2_3_1_, 
street4_.id as id2_2_, street4_.street_name as street2_2_2_, street4_.district_id as district3_2_2_
 from jbit.house this_ inner join jbit.users user2_ on this_.user_id=user2_.id inner join housetype 
type3_ on this_.type_id=type3_.id inner join street street4_ on this_.street_id=street4_.id ) row_ 
where rownum <= ?) where rownum_ > ?