使用left outer join子句可以实现左外连接,使用左外连接可以返回对应内连接的所有对象及left outer join子句左边持久化类的未关联对象。如:
public void testUseLeftOuterJoin(){
Session session = null;
session = HibernateUtils.getCurrentSession();
String hql = "select c from Category c left outer join c.products order by c.id";
Query query = session.createQuery(hql);
List<Category> list = query.list();
HibernateUtils.closeSession(session);
for(Category obj : list){
System.out.println(obj.getAllInfo());
}
}
public void testUseLeftOuterJoin(){
Session session = null;
session = HibernateUtils.getCurrentSession();
String hql = "select c from Category c left outer join c.products order by c.id";
Query query = session.createQuery(hql);
List<Category> list = query.list();
HibernateUtils.closeSession(session);
for(Category obj : list){
System.out.println(obj.getAllInfo());
}
}
转载于:https://blog.51cto.com/wujuxiang/403690