select * from Prizewinner p , Treatise t where p.cgId = t.id表Prizewinner id 表Treatise cgid
//hibernate:
Criteria critera = getSession().createCriteria(Prizewinner.class);//这是一个对象(表) Treatise treatise = treatiseRepository.get(tId);//另一张表,根据ID获得这个对象 critera.add(Restrictions.eq("cgId",treatise.getId()));//关联查询 List<Treatise> ts = critera.list();