session.createQuery("select courseName from OrderItem oi,Order o, Student s where oi.orderId=o.orderId and o.studentId=?");
大概表关系 Student id number (pk) name varchar2Order id number (pk) studentId number (fk)Item id number (pk) orderId number (fk)检索SQL语句 select i.* from Item i, Order o, Student s where i.orderId=o.id and o.studentId = s.id and xxxx
session.createQuery("select courseName from OrderItem oi,Order o, Student s where oi.orderId=o.orderId and o.studentId=?");
终于查出来了 public List findCourseNameByOrder(Integer id) { List list=ht.find("from Order o left outer join fetch o.items where o.stu.id=?",new Object[]{id}); return list; }
Student
id number (pk)
name varchar2Order
id number (pk)
studentId number (fk)Item
id number (pk)
orderId number (fk)检索SQL语句
select i.* from Item i, Order o, Student s
where i.orderId=o.id and o.studentId = s.id
and xxxx
public List findCourseNameByOrder(Integer id) {
List list=ht.find("from Order o left outer join fetch o.items where o.stu.id=?",new Object[]{id});
return list;
}