List<Map<String, String>>数据行转列

报表需求改动需要对接口返回结果List<Map<String, String>>进行行转列,以下为测试demo:

package com.gykjit.spd.system.service.impl;


import java.util.*;

public class RowToColumn {

    public static void main(String[] args) {
        List<Map<String, String>> rows = new ArrayList<>();
        Map<String, String> row1 = new HashMap<>();
        row1.put("Name", "Alice");
        row1.put("Age", "30");
        row1.put("sex", "1");

        Map<String, String> row2 = new HashMap<>();
        row2.put("Name", "Bob");
        row2.put("Age", "25");
        row2.put("sex", "0");
        rows.add(row1);
        rows.add(row2);

        List<Map<String, String>> columns = new ArrayList<>();

        Set<String> keySet = row1.keySet();
        for (String oldKey : keySet) {
            Map<String, String> columnMap = new HashMap<>();
            for (int i = 0; i < rows.size(); i++) {
                final int index = i;
                String columnName = "row_" + index;
                String columnValue = rows.get(index).get(oldKey);
                columnMap.put(columnName, columnValue);
            }
            columns.add(columnMap);
        }
        System.out.println(rows);
        System.out.println(columns);
    }
}


这个转换过程比较复杂,需要按照字符串的格式进行解析。以下是一个可能的实现方式: ```java public static List<Map<String, List<Map<String, List<Map<String, String>>>>>> convert(String input) { List<Map<String, List<Map<String, List<Map<String, String>>>>>> result = new ArrayList<>(); // 先按照大括号和逗号分割字符串 String[] parts = input.split("[{},]"); int level = 0; Map<String, List<Map<String, List<Map<String, String>>>>> currentMap = null; List<Map<String, List<Map<String, String>>>> currentList = null; Map<String, List<Map<String, String>>> innerMap = null; List<Map<String, String>> innerList = null; for (String part : parts) { part = part.trim(); if (part.isEmpty()) { continue; } if (part.equals("[")) { if (level == 0) { currentMap = new LinkedHashMap<>(); result.add(currentMap); } else if (level == 1) { currentList = new ArrayList<>(); currentMap.put(currentList.size() + "", currentList); } else if (level == 2) { innerMap = new LinkedHashMap<>(); currentList.add(innerMap); } else if (level == 3) { innerList = new ArrayList<>(); innerMap.put(innerList.size() + "", innerList); } level++; } else if (part.equals("]")) { level--; if (level == 1) { currentList = null; } else if (level == 2) { innerMap = null; } else if (level == 3) { innerList = null; } } else { // 解析每个元素的 key 和 value String[] kv = part.split(":"); String key = kv[0].trim().replaceAll("\"", ""); String value = kv[1].trim().replaceAll("\"", ""); if (level == 1) { currentMap.put(key, new ArrayList<>()); } else if (level == 2) { innerMap.put(key, new ArrayList<>()); } else if (level == 3) { innerList.add(new LinkedHashMap<>()); } else if (level == 4) { Map<String, String> innerInnerMap = new LinkedHashMap<>(); innerList.add(innerInnerMap); String[] innerKv = value.split(","); for (String innerPart : innerKv) { String[] innerKv2 = innerPart.split(":"); String innerKey = innerKv2[0].trim().replaceAll("\"", ""); String innerValue = innerKv2[1].trim().replaceAll("\"", ""); innerInnerMap.put(innerKey, innerValue); } } } } return result; } ``` 这个方法先按照大括号和逗号分割字符串,然后使用一个 `level` 变量记录当前解析到哪一层。对于每个元素,根据 `level` 的值来判断它是一个列表还是一个映射,然后递归解析。最后返回一个 `List<Map<String, List<Map<String, List<Map<String, String>>>>>>` 类型的结果。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值