public List<KnowledgeExpertArticle> findKnowledgeExpertArticleForSearch( String keyName, Object value,final int start,final int limit) { // log.debug("search knowledgeExpertArticle by :"+value); try{ final String hql = "form KnowledgeExpertArticle as model where model.'"+keyName+"' like '%"+value+"%' order by model.expertArticleId DESC"; log.info(hql); List resultList = getHibernateTemplate().executeFind( new HibernateCallback() { public Object doInHibernate(Session arg0) throws HibernateException, SQLException { Query query = arg0.createQuery(hql); query.setFirstResult(start); query.setMaxResults(limit); return query.list(); } }); return resultList; }catch(RuntimeException re){ throw re; } }
Hibernate实现mysql数据库limit查询方法
最新推荐文章于 2021-01-20 12:55:55 发布