Spring中常用的HibernateTemplate中的查询方法

比较白；

用Spring的HibernateTemplate，目前最常用的两个方法：

1.参数具名查询：

String hql = "from WorkTimeCurrency as workTimeCurrency "+ "where workTimeCurrency.orgAcconutID = :orgAcconutID "+ "and workTimeCurrency.year = :year "+ "and workTimeCurrency.isWork = :isWork "+ "order by workTimeCurrency.weekDayName";/* * Map<String, Object> parameterMap = new HashMap<String, Object>(); * parameterMap.put("orgAcconutID", orgAccountID); * parameterMap.put("year", year); parameterMap.put("isWork", isWork); */String[] paramNames = {"orgAcconutID","year","isWork"};Object[] values = {orgAccountID,Integer.toString(year),isWork};List<WorkTimeCurrency> workTimeCurrencies = this.getHibernateTemplate().findByNamedParam(hql,paramNames, values);

2.？号占位符查询：

String hql = "from WorkTimeSpecial as workTimeSpecial " + "where workTimeSpecial.orgAcconutID = ? " + "and workTimeSpecial.year = ? " ;Object[] values = {orgAcconutID,Integer.toString(year)};List<WorkTimeSpecial> workTimeSpecials = getHibernateTemplate().find(hql, values);

恩，最近常用，先记在这里吧。