gethibernatetemplate分页-模糊查询

《gethibernatetemplate分页-模糊查询》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、getHibernateTemplate分页-模糊查询Hibernate对Dao层的处理实例有模糊查询和分页packageinfoweb.dao;importjava.util.List;importjava.util.Iterator;importinfoweb.pojo.Info;importnet.sf.hibernate.HibernateException;importnet.sf.hibernate.Query;importnet.sf.hibernate.Session;importorg.springframework.orm.hi

2、bernate.HibernateCallback;importorg.springframework.orm.hibernate.support.HibernateDaoSupport;pTitleppDescriptionppCopyrightCopyright(c)2004ppCompanyp@author段洪杰@version1.0publicclassInfoDAOImplextendsHibernateDaoSupportimplementsIInfoDAO{构造函数publicInfoDAOImpl(){super();}增加记录@p

3、araminfoInfopublicvoidsetInfo(Infoinfo)throwsException{getHibernateTemplate().save(info);}通过ID取得记录@paramidString@returnInfopublicInfogetInfoById(Stringid)throwsException{Infoinfo=(Info)getHibernateTemplate().load(Info.class,id);returninfo;}修改记录@paramInfoinfopublicvoidmodifyInf

4、o(Infoinfo)throwsException{getHibernateTemplate().update(info);}删除记录@paramInfoinfopublicvoidremoveInfo(Infoinfo)throwsException{getHibernateTemplate().delete(info);}以下部份不带审核功能取记录总数@returnintpublicintgetInfosCount()throwsException{intcount=0;StringqueryString=selectcount()fromI

5、nfo;count=((Integer)getHibernateTemplate().iterate(queryString).next()).intValue();returncount;}取所有记录集合@returnIteratorpublicIteratorgetAllInfos()throwsException{Iteratoriterator=null;StringqueryString=selectinfofromInfoasinfoorderbyinfo.iddesc;Listlist=getHibernateTemplate().f

6、ind(queryString);iterator=list.iterator();returniterator;}取记录集合@returnIterator@paramintposition,intlengthpublicIteratorgetInfos(intposition,intlength)throwsException{Iteratoriterator=null;StringqueryString=selectinfofromInfoasinfoorderbyinfo.iddesc;Queryquery=getHibernateTempl

7、ate().createQuery(getSession(),queryString);设置游标的起始点query.setFirstResult(position);设置游标的长度query.setMaxResults(length);记录生成Listlist=query.list();把查询到的结果放入迭代器iterator=list.iterator();returniterator;}取第一条记录@throwsException@returnStationpublicInfogetFirstInfo()throwsException{Iter

8、atoriterator=null;Infoinfo=null;StringqueryString=selectinfof