spring jpa data 查询多对一映射

来源:互联网 发布:适用于mac的壁纸 编辑:程序博客网 时间:2024/06/07 12:57
@Servicepublic class CityServiceImpl implements CityService {    @Autowired    CityRepository cityRepository;    public CityRepository getCityRepository() {        return cityRepository;    }    EntityManagerFactory entityManagerFactory;    @PersistenceUnit    public void setEntityManagerFactory(EntityManagerFactory entityManagerFactory) {        this.entityManagerFactory = entityManagerFactory;    }    @Override    public List<SimpleCity> listByProvinceId(int provinceId) {        EntityManager em = entityManagerFactory.createEntityManager();        Query query = em.createQuery("select new com.jiapeng.xfw.server.normalClass.SimpleCity(c.province.id,c.province.name,c.id,c.name) " +                "from City c where c.province.id =?  order by c.id");        query.setParameter(1,provinceId);//传参        List<SimpleCity> list = query.getResultList();        em.close();        return list;    }}
0 0