自定义ResultTransformer，JPA ，自定义SQL ，CLOB处理、DATE处理

1、自定义ResultTransformer

public class xxxxCustomResultTransformer implements ResultTransformer {
    @Override
    public List transformList(List collection) {
        return collection;
    }

    @Override
    public Object transformTuple(Object[] tuple, String[] aliases) {
        Map<String, Object> result = new HashMap<>();
        for (int i = 0; i < aliases.length; i++) {
            String alias = aliases[i].toLowerCase();
            Object value = tuple[i];
            if(value instanceof Date){
                result.put(alias, processDate(value));
            }else if (value instanceof Clob) {
                // 处理Clob类型数据
                result.put(alias, processClob((Clob) value));
            } else {
                // 处理其他数据类型
                result.put(alias, value);
            }
        }
        return result;
    }
    private String processDate(Object value){
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        return df.format(value);
    }
    private String processClob(Clob clob) {
        try {
            // 从Clob中读取数据并返回字符串
            StringBuilder sb = new StringBuilder();
            String line;
            java.io.Reader reader = clob.getCharacterStream();
            java.io.BufferedReader br = new java.io.BufferedReader(reader);
            while ((line = br.readLine()) != null) {
                sb.append(line);
            }
            br.close();
            return sb.toString();
        } catch (SQLException | IOException e) {
            // 处理异常情况

            return null;
        }
    }
}

2、调用

    EntityManager entityManager = SpringUtils.getBean(EntityManager.class);

public List<Map<String, Object>> querySql(String sql, List<Object> list)   {
        Query query = entityManager.createNativeQuery(sql)
                .unwrap(NativeQuery.class)
                .setResultTransformer(new xxxxCustomResultTransformer());
                //.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
        for(int i=0;i<list.size();i++){
            query.setParameter(i+1,  list.get(i));
        }
        List<Map<String, Object>> resultList = query.getResultList();
        if (CollectionUtils.isEmpty(resultList)){
            //throw new CustomRuntimeException("未找到相关数据");
            resultList =new ArrayList<>();
        }
        return resultList;
    }