9、连接查询【重要】
* 内连
* 外连接(左连接/右连接)
参见:JoinQueryTest.java
内连---(默认)
//List students = session.createQuery("select c.name, s.name from Student s join s.classes c").list();
List students = session.createQuery("select c.name, s.name from Student s inner join s.classes c").list();
for (Iterator iter=students.iterator(); iter.hasNext();) {
Object[] obj = (Object[])iter.next();
System.out.println(obj[0] + "," + obj[1]);
}
=========================================================
左连
List students = session.createQuery("select c.name, s.name from Classes c left join c.students s").list();
============================================================
右连
List students = session.createQuery("select c.name, s.name from Classes c right join c.students s").list();
HQL连接查询【重要】
最新推荐文章于 2020-03-24 17:04:33 发布