学步园

	@Test
	public void testLoadSelect2() {
		Transaction tx = session.beginTransaction();
		SQLQuery query  = session.createSQLQuery("select {s.*},{c.*} from student s,class c where s.cls_id = c.id");
		query.addEntity("s", Student.class)
			 .addEntity("c", ClassNo.class);
//		query.setParameter(0, 22);
//		query.setParameter(1, 23);
		List<Object[]> objs = query.list();					//输出的每一行都是一个包括Student和ClassNo两个对象的数组
		System.out.println(objs.getClass());
		System.out.println(objs);
		for(Object[] stu : objs){
			System.out.println(stu[0].getClass());			//输出：Student.class
			System.out.println(stu[1].getClass());			//输出：ClassNo.class
		}
		tx.commit();
	}