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"); }