StringBuffer hql = new StringBuffer(
"select new com.ulearning.ulms.order.model.OrderQuery" +
"(o.orderId,o.orderNo,o.orderType,o.totalPrice,o.orderStatus,o.paymentType,o.paymentStatus,o.updateTime,o.tradeNo,u.userID,u.name,u.address,o.remark5,oq.eduAddress)" );
hql.append("From Order o,User u,OrganEduAddress oq where o.userId=u.userID and o.Remark5=oq.areacode");
List<OrderQuery> list = super.createQuery(hql.toString()).list();
public Query createQuery(final String hql, final Object... values)
{
Query query = getSession().createQuery(hql);
int j = values.length;
for (int i = 0; i < j; i++)
query.setParameter(i, values[i]);
return query;
}