All pastes #407450 Raw Edit

Unnamed

public text v1 · immutable
#407450 ·published 2007-03-24 01:00 UTC
rendered paste body
	public List all(String orderBy,Boolean as) {
		Session sess = getSessionFactory().openSession();
		Query q = sess.createQuery("from Brand order by :orderBy :inOrder");
		q.setParameter("orderBy", orderBy);
		if(as)
			q.setParameter("inOrder", "desc");
		else
			q.setParameter("inOrder", "asc");
		
		return q.list();
//		if(as)
//			return getHibernateTemplate().find("from Brand order by "+orderBy+" asc");
//		else
//			return getHibernateTemplate().find("from Brand order by "+orderBy+" desc");
	}