<div class="iteye-blog-content-contain" style="font-size: 14px"> @Override
public List<Map<String, Object>> getListMapByCommonNativeNamedQuery(
String sql, int start, int length, Map pars) {
Query query = this.entityManager.createNativeQuery(sql);
if (pars != null) {
Iterator<Map.Entry> it = pars.entrySet().iterator();
Entry en = null;
while (it.hasNext()) {
en = it.next();
query.setParameter(en.getKey().toString(), en.getValue());
}
}
// 使用hibernate特性设置Transformers为Map
query.unwrap(SQLQuery.class).setResultTransformer(
Transformers.ALIAS_TO_ENTITY_MAP);
if (length > 0) {
query.setFirstResult(start);
query.setMaxResults(length);
}
return query.getResultList();
}</div>
public List<Map<String, Object>> getListMapByCommonNativeNamedQuery(
String sql, int start, int length, Map pars) {
Query query = this.entityManager.createNativeQuery(sql);
if (pars != null) {
Iterator<Map.Entry> it = pars.entrySet().iterator();
Entry en = null;
while (it.hasNext()) {
en = it.next();
query.setParameter(en.getKey().toString(), en.getValue());
}
}
// 使用hibernate特性设置Transformers为Map
query.unwrap(SQLQuery.class).setResultTransformer(
Transformers.ALIAS_TO_ENTITY_MAP);
if (length > 0) {
query.setFirstResult(start);
query.setMaxResults(length);
}
return query.getResultList();
}</div>