HAN_789的博客

最近遇到行转列的问题需要将同一个id下面的数据组装起来 与另一张主表中的数据组成一一条数据 sql代码如下 SELECT * FROM SE_REQ_ITEM_INFO srii LEFT JOIN ( SELECT ENTITY_ID, CASE WHEN attr_id = '201' THEN value END "201", CASE WHEN attr_id = 202 THEN value END "202", CASE WHEN attr_id = 203 THEN v

public static Map<String, Object> clobToStringByMap(Map<String, Object> map) { if (map == null) { return map; } for (Map.Entry<String, Object> entry : map.entrySet()) { Object t1 = entry.getValue(); if (t1 instanceof Clob) {// 将所有Clob类型的字