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

最新推荐文章于 2021-04-10 11:19:55 发布

Run_LeoCat

最新推荐文章于 2021-04-10 11:19:55 发布

阅读量3.3k

点赞数

分类专栏： Java小议文章标签： spring object string

本文链接：https://blog.csdn.net/len126/article/details/5962711

版权

Java小议专栏收录该内容

4 篇文章 0 订阅

订阅专栏

比较白；

用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);

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