两种为hql设置参数的万能方法
?
----------------------------------------------------两种为hql设置参数的万能方法---------------------------------1. ？占位符方式2. publicListgetList(String hql, String[] params) {3. Session session = getSession();4. Queryquery= null;5. try{6. 7. query= session.createQuery(hql);8. if(params!=null)9. {10. for(inti=0;i<params.length;i++) {11. query.setString(i, params[i]);12. }13. }14. Listlist=query.list();15. if(list!=null&&list.size()!=0){16. 17. returnlist;18. 19. }20. 21. } catch(Exception e) {22. e.printStackTrace();23. return null;24. } finally{25. try{26. if(session != null&& session.isOpen()) {27. closeSession();28. }29. } catch(Exception e) {30. e.printStackTrace();31. }32. }33. return null;34. } 二.：参数名方式 publicListqueryList(String strHql, String[] paraName, Object[] paraValue, intpageNum, intnumPerPage) { Session session = null; Transaction tx = null; ListretList = null; try{ session = getSession(); tx = session.beginTransaction(); Query q = session.createQuery(strHql); if(paraValue.length>0 && paraValue.length== paraName.length) { for(inti=0; i<paraValue.length; i++) { if(strHql.indexOf(":"+ paraName[i]) != -1) q.setParameter(paraName[i], paraValue[i]); } } if(pageNum != 0 && numPerPage != 0) { q.setFirstResult((pageNum - 1) * numPerPage); q.setMaxResults(numPerPage); } if(q.list() != null&& q.list().size() != 0) { retList = q.list(); } tx.commit(); q = null; } catch(HibernateException e) { try{ tx.rollback(); } catch(HibernateException e1) { e1.printStackTrace(); } e.printStackTrace(); } finally { try{ closeSession(); } catch(HibernateException e) { e.printStackTrace(); logger.error("Close sf session failed ....by message "+ e.getMessage()); } tx = null; session = null; } returnretList; }