Hibernate HQL基础 HQL中的连接 右..
时间:2010-10-10 来源:juxiangwu
使用right outer join子句可以实现右外连接,使用右外连接可以返回对应的内连接的所有记录及right outer join子句右边持久化类的未关联对象的记录。如:
public void testUseRightOuterJoin(){
Session session = null;
session = HibernateUtils.getCurrentSession();
String hql = "from Category c right outer join c.products";
Query query = session.createQuery(hql);
List<Object[]> list = query.list();
HibernateUtils.closeSession(session);
for(Object[] objs : list){
for(Object obj :objs){
System.out.println(obj.toString());
}
}
}
public void testUseRightOuterJoin(){
Session session = null;
session = HibernateUtils.getCurrentSession();
String hql = "from Category c right outer join c.products";
Query query = session.createQuery(hql);
List<Object[]> list = query.list();
HibernateUtils.closeSession(session);
for(Object[] objs : list){
for(Object obj :objs){
System.out.println(obj.toString());
}
}
}
相关阅读 更多 +