/**
* input about.
*/
public List<?> getInputResultBySql(String sql) {
Query query = entityManager.createNativeQuery(sql);
query.unwrap(NativeQueryImpl.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
List<Map> resultList = query.getResultList();
//遍历resultList
for (Map map : resultList) {
//遍历map
for (Object key : map.keySet()) {
//输出key和value
System.out.println("key=" + key + " value=" + map.get(key));
}
}
return null;
}
Spring JPA实现动态SQL查询,并无实体映射,返回map
最新推荐文章于 2024-05-01 16:49:56 发布