public List<ShopDianpu> findbymiaosha(long id, List<Object> list) throws Exception { String hql="from ShopDianpu where dianput.id="+id+" and shop.zhuangtai='1' and LENGTH(huodong)>5 and shop.id not in (:list) order by shop.rexiaoshezhi desc,shop.dianleipaixu asc"; Query createQuery = getSession().createQuery(hql); createQuery.setParameterList("list", list); return createQuery.list(); }