Hibernate (1) 多对多查询

public List queryAllByCateId(long cateId) {
//多對多Hibernate会自动创建第三个关联表,关键词elements,另外去除重复用distinct
String sql=”select distinct t from Type t,Category c ” +
“where t in elements(c.typeList) and c.id=? “;
List typeList=hibernateTemplate.find(sql,cateId);
return typeList;
}