@Service
public 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;
}
}
spring jpa data 查询多对一映射
最新推荐文章于 2023-08-18 16:10:36 发布