Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery(
"select a.id,b.title,b.username from A as a,B b"
);
//这里的A,B依然是对象
List list = query.list();
//这里每一行都是一个1维数组
for
(
int
i=
0
;i<list.size();i++)
{
Object []o = (Object[])list.get(i);
//转型为数组
int
id = (Integer)o[
0
];
//和select中顺序的类型相对应,可以是类
String title = (String)o[
1
];
String username = (String)o[
2
];
System.out.println(
"id:"
+id+
" , "
+
"title"
+title+
" , "
+username);
}
HibernateSessionFactory.closeSession();