java 自定义查询StringBuffer Sql

一、背景

二、实现

@Autowired
private EntityManager entityManager;

Query query = entityManager.createNativeQuery(sql);
query.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);

List<Map<String, Object>> reportWaterTota = query.getResultList();
List<SewageVolumeDto> createSmsDtos = JacksonUtils.listMapToListBean(reportWaterTota, 							SewageVolumeDto.class
);  // 数据


public static <R> List<R> listMapToListBean(List<Map<String, Object>> info, Class<R> clazz){
	try {
		return jsonToList(MAPPER.writeValueAsString(info), clazz);
	} catch (JsonProcessingException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
		return null;
	}
}

三、遇到的报错

四、参考博客