public List findAllCompanyByPageno(Integer pageNo,Integer rowNo)throws Exception{
Session session = null;
Transaction tr = null;
List l= null;
try{
session=HibernateUtil.getSession();
tr = session.beginTransaction();
Query q = session.createQuery("from AirCompany as c");
q.setFirstResult(pageNo*rowNo);
q.setMaxResults(rowNo);
l = q.list();
tr.commit();
}catch(Exception e){
e.printStackTrace();
tr.rollback();
throw e;
}finally{
HibernateUtil.close();
}
return l;
}