@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();
}