from Item item
join item.bids bid
where item.description like '%gc%'
and bid.amount > 100
這樣得出來的是兩個對象
item 和bid
通過這樣進行查詢
Query q = session.createQuery("from Item item join item.bids bid");
Iterator pairs = q.list().iterator();
Joining associations 263
while ( pairs.hasNext() ) {
Object[] pair = (Object[]) pairs.next();
Item item = (Item) pair[0];
Bid bid = (Bid) pair[1];
}
如果是
select item
from Item item
join item.bids bid
where item.description like '%gc%'
and bid.amount > 100
那么只得出的是一個對象