请问 Criteria 对 Collection 查询的语法

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

public class Header {
... private String segment1;
  @OneToMany(mappedBy="header") private List<Line> line;
...
}
 
public class Line {
... private String segment1;
  @ManyToOne @JoinColumn(name="HEADER_ID", referencedColumnName="HEADER_ID") private Header header;
...
}

1
2
3
4
5

select * from glt_inv_alltrans_line_v line, glt_inv_alltrans_header_v header where line.header_id = header.header_id and (header.segment1 = 'A' or line.segment1 = 'A');

1
2
3

SELECT distinct Header FROM Header inner join Header.line as Line WHERE Header.segment1 = 'A' or Line.segment1 = 'A'