public Collection<Room> getRoomByCondition(Room room,Integer pageno) {
String hql="FROM Room r WHERE 1=1";
if(StringUtils.isNotBlank(room.getRnumber())){
hql=hql+" AND r.rnumber = '"+room.getRnumber()+"'";
}
if(StringUtils.isNotBlank(room.getIsvacant())){
hql=hql+" AND r.isvacant = '"+room.getIsvacant()+"'";
}
if(StringUtils.isNotBlank(room.getVolum())){
hql=hql+" AND r.volum like "+room.getVolum();
}
Query query=getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(hql);
query.setFirstResult(pageno);
query.setMaxResults(3);
List<Room> result=query.list();
return result;
}