public void forSQLMutiTable()//native sql 多表
{
Session session = HibernateSessionFactory.getSession();
Transaction tran = session.beginTransaction();
List list = session.createSQLQuery("select ui.*,dt.* from deptment dt,userinfo ui where ui.deptid = dt.deptid").list();
tran.commit();
HibernateSessionFactory.closeSession();
for(int i = 0;i<list.size();i++)
{
Object[] ob= (Object[])list.get(i);//list 中存放的是OBJECT数组
System.out.println(ob[0]);
}
}