HibernateDAO总结.doc

protected int queryBySQLNameParamsCount(final String sql,final String paramnames,final Object... params){ return hibernateTemplate.execute(new HibernateCallback(){ //返回个数非List时候必须用execute 非 executeFind @Override public Object doInHibernate(Session session) throws HibernateException, SQLException { Query query=session.createSQLQuery(sql); String[] names = StringUtils.split(paramnames, ,); for (int i=0,length=names.length; i length; i++) { if(params[i] instanceof Collection){ query.setParameterList(names[i], (Collection)params[i]); }else{ query.setParameter(names[i], params[i]); } } return ((BigInteger)query.uniqueResult()).intValue(); } }); } 异常： a different object with the same identifier value was already associated with 如果必须两次操作可以用： 两次操作中间用户 hibernateTemplate.flush(); hibernateTemplate.clear(); 如： for (MapString, Object map : qryMapList) { RecordMap data = new RecordMap(map); appsourceDayStat = new AppSourceDayStat(); BindUtils.bindData(appsourceDayStat, data); appsourceDayStat.setStatstime(DateUtil.currentTimestamp()); hibernateTemplate.saveOrUpdate(appsourceDayStat); succount++; } dbLogger.warn(msg); } hibernateTemplate.flush(); hibernateTemplate.clear(); //订单更新，重新统计 int succountorder=0 ListMapString, Object orderMapList = jdbcTemplate.queryForList(ordernumSql,starttime); if(orderMapList!=null!orderMapList.isEmpty()){ for (MapString, Object map : orderMapList) { RecordMap data = new RecordMap(map); appsourceDayStat = new AppSourceDayStat(); BindUtils.bindData(appsourceDayStat, data); appsourceDayStat.setStatstime(DateUtil.currentTimestamp()); hibernateTemplate.saveOrUpdate(appsourceDayStat); succountorder++; } } JdbcTemplate query.list() 转换为返回Map query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); return (Integer) getHibernateTemplate().execute(new HibernateCallbackObject(){