hql查询方式和 criteria 查询

最新推荐文章于 2018-10-24 18:08:09 发布

xpalive

最新推荐文章于 2018-10-24 18:08:09 发布

阅读量550

点赞数

分类专栏： hibernate

本文链接：https://blog.csdn.net/xpalive/article/details/8649414

版权

hibernate 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

    public List<TrainUser> findByTrainPlanRegist(Long planId) {
//       Criteria criteria = this.getSession().createCriteria(TrainUser.class);
//       criteria.createAlias("appUser", "appUser");
//       criteria.createAlias("trainPlan", "trainPlan");
//       criteria.add(Restrictions.eq("trainPlan.id", planId)).add(Restrictions.eq("regist", TrainUser.REGIST));
//       return criteria.list();
       String hql="select tu from TrainUser tu JOIN fetch tu.appUser tuau JOIN fetch tu.trainPlan tutp where tu.trainPlan.id = ? and tu.regist = ?";
       Query query = this.getSession().createQuery(hql);
       query.setParameter(0, planId);
       query.setParameter(1, TrainUser.REGIST);
       List list = query.list();

return list;

join fetch 才可以将对象中的对象属性插入对象