Hibernate中HQL写法

条件删
用到query.executeUpdate();

  @Override
    public void deleteBy(Integer invid) {
     Integer count=template.execute(new HibernateCallback<Integer>() {
         @Override
         public Integer doInHibernate(Session session) throws HibernateException {
             String hql="delete from Reply where invid=?1";
             Query<Integer> query=session.createQuery(hql);
             query.setParameter(1,invid);
             Integer count2=query.executeUpdate();
             return count2;
         }
     });
    }

模糊查
query.list();

  @Override
    public List<Invitation> selectByLike(String keywords, Integer page, Integer pageSize) {
        List<Invitation> list=template.execute(new HibernateCallback<List<Invitation>>() {
            @Override
            public List<Invitation> doInHibernate(Session session) throws HibernateException {
                String hql="from Invitation where title like concat('%',?1,'%') ORDER BY createdate DESC";
                Query query=session.createQuery(hql);
                query.setParameter(1,keywords);
                query.setFirstResult(page);
                query.setMaxResults(pageSize);
                List<Invitation> list1=query.list();
                return list1;
            }
        });
        return list;
    }

模糊查次数
query.uniqueResult();

 @Override
    public Long selectCountByLike(String keywords) {
        Long count=template.execute(new HibernateCallback<Long>() {
            @Override
            public Long doInHibernate(Session session) throws HibernateException {
                String hql="select count(*) from Invitation where  title like concat('%',?1,'%')";
                Query<Long> query=session.createQuery(hql);
                query.setParameter(1,keywords);
                Long count2=query.uniqueResult();
                return count2;
            }
        });
        return count;
    }