请教hibernate的排序问题!!
我现在用query对象执行hql语句进行查询,为什么我的hql语句order by不能跟问号?我想实现按我所传参数进行排序应该怎么写,本人新手,请多多指教!!
String hql = "select o from OriginalDataResultModel o where " +
"o.collecttimeObject between ? and ? and o.stid in(:stid) order by ? ?";
Query q = s.createQuery(hql);
q.setParameter(0,startDate);
q.setParameter(1,endDate);
q.setParameterList("stid",stidlist);
if(dir!=null){
q.setParameter(4, dir);
}
if(sort!=null){
q.setParameter(3, "o."+sort);
}