这里写自定义目录标题
JPA EntityManager采用原生SQL语句执行后,返回LIst自定义对象的方法
1、注入 EntityManager 对象
@PersistenceContext
protected EntityManager entityManager;
2、返回List
Query nativeQuery = entityManager.createNativeQuery("select column1,column2 from table");
nativeQuery.unwrap(NativeQueryImpl.class).setTupleTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
List<Map<String,Object>> resultList = nativeQuery.getResultList();
3、返回List类型
@Data
public class ResultBean {
private String column1;
private String column2;
}
Query nativeQuery = entityManager.createNativeQuery("select column1,column2 from table");
nativeQuery.unwrap(NativeQueryImpl.class).setTupleTransformer(Transformers.aliasToBean(ResultBean.class));
List<ResultBean> resultList = nativeQuery.getResultList();
在此记录一下,避免忘记!