Thursday, August 6, 2009

Sorting using Native SQL on Hibernate..

Sorting...** from Issue Tracking Web App...

static
public java.util.List getListData2(
Class classBean, String strKey, Object value)
{
java.util.List result = new java.util.ArrayList();

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();

Criteria criteria =
session.createCriteria(classBean);
criteria.addOrder(Order.asc("name"));
if (strKey != null) {
criteria.add(Restrictions.like(strKey, value));
}
result = criteria.list();

tx.commit();
session.close();
return result;
}

No comments:

Post a Comment