Hibernate HQL查询的一点小结

HQL动态查询

    public List<PlayList> testDynamicQuery(Integer flag ,String tags) {
            StringBuilder queryCondition = new StringBuilder("");
            if(flag != null){
                queryCondition.append(" and p.flag = "+ flag);
            }
            if(tags != null && tags.length() > 0){
                queryCondition.append(" and p.tags =" +"'"+tags+"'");//String类型特殊处理
            }
            String hql = "select p from PlayList p , VedioRecommend v 
                                    where  p.filmId = v.id"+ queryCondition;
            Query query = getSession().createQuery(hql);
            return query.list();
        }

Object[] 数组接收部分参数

    public List<Object[]> testObject() {
        String hql = "select p.filmName,p.season from PlayList p";
        Query query = getSession().createQuery(hql);
        return query.list();
    }

Map接收部分参数

    public List<Map<String, Object>> testMap() {
        String hql = "select new map(p.filmName as name,p.season as season) from PlayList p";
        Query query = getSession().createQuery(hql);
        return query.list();
    }

    注：Map 必须用小写 map，key 默认为"0","1","2"... 但是用as给出的别名将作为key;

DTO对象接收部分参数

    @PersistenceContext
    private EntityManager em;
    @Override
    public List<UserInfoVo> findUserInfoVo() {
        String hql = "select new com.demo.provideruser.dto.UserInfoVo(u.id ,u.name ,u.age )  from User u order by u.id";
        Query query = em.createQuery(hql);
        return query.getResultList();
    }