Hibernate中多表查询的分页

Session s=HibernateUtil.currentSession();
Transaction t=s.beginTransaction();

Query q=s.createQuery( "from Trade t,Aclrole r where t.trade_id=1 and r.rolename='lyorole'" );
q.setFirstResult(0);
q.setMaxResults(10);
List list=q.list();

int i=0;
for(i=0;i
Object[] o=(Object[])list.get(i);
for( int j=0;j
Object oo=o[j];
if(oo instanceof Trade){
Trade tt=(Trade)oo;
out.println( "get trade:" +tt.getTrade_id()+ "" );
}else if(oo instanceof Aclrole){
Aclrole r=(Aclrole)oo;
out.println( "get Role:" +r.getRoleid()+ "" );
}

}
}
out.println( "I is: " +i);

t.commit();
HibernateUtil.closeSession();
request.setAttribute( "tradeList" ,list);