天天看點

jpa傳回List<Map<String, Object>>相當于jdbctemplate的queryForlist

public class Test(){
@PersistenceContext(unitName = "manageFactory")
protected EntityManager em;
public List<Map<String, Object>>getListMap(String sql){
        Query nativeQuery=em.createNativeQuery(sql);
        nativeQuery.unwrap(NativeQueryImpl.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
        List resultList=nativeQuery.getResultList();
        return resultList;
        }

        }