String?sql="select?{e.*},{d.*}from?EMP?e?join?DEPT?d?on?d.DEPTNO=e.DEPTNO"
+"where?e.JOB=:job";//創(chuàng)建員工表和部門表的原生sql
Query?query=session.createSQLQuery.addEntity("e".Emp.class)
.addJoin("d","e.dept").setString("job","saler");//添加內(nèi)連接
List<Object[]>?list=query.list();//查詢返回list
Emp?emp=null;//實例化實體對象
Dept?dept=null;
for(Object[]?obj:list){//用反射組裝查詢結(jié)果
?emp=(Emp)obj[o];
?dept=(Dept)obj[1];
?system.out.print(emp.getEmpName+","+dept.getDeptName);//輸出內(nèi)容
}

?