我们有一个Team实体,一个Student实体,他们之间的关系是1对多,Team中持有一个Student集合,如果我们不想检索出全部的student,而是希望检索符合一定条件的Student集合,可以使用HQL和Filter的方
数据库结构:
create table testStu (id varchar ( 32 ),name varchar ( 32 ),age int ,team_id varchar ( 32 ));
insert into teststu values (" 1 ","tom1", 11 ," 1 ");
insert into teststu values (" 2 ","tom2", 12 ," 2 ");
insert into teststu values (" 3 ","tom3", 13 ," 1 ");
insert into teststu values (" 4 ","tom4", 14 ," 2 ");
insert into teststu values (" 5 ","tom5", 15 ," 1 ");
insert into teststu values (" 6 ","tom6", 16 ," 2 ");
insert into teststu values (" 7 ","tom7", 17 ," 1 ");
insert into teststu values (" 8 ","tom8", 18 ," 2 ");
insert into teststu values (" 9 ","tom9", 19 ," 1 ");
insert into teststu values (" 10 ","tom10", 20 ," 2 ");
create table testteam (id varchar ( 32 ) primary key ,name varchar ( 32 ));
insert into testteam values (" 1 ","team1");
insert into testteam values (" 2 ","team2");
POJO:
package
Search.filter;
public class TestStu ... {
private String id; //标识id
private String name; //学生姓名
private int age; //岁数
private TestTeam team;
public int getAge() ...{
return age;
}
public String getName()
public class TestStu ... {
private String id; //标识id
private String name; //学生姓名
private int age; //岁数
private TestTeam team;
public int getAge() ...{
return age;
}
public String getName()