Hibernate中过滤器的使用

我们有一个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()