如何在Java中自定义解析二维JSON数组并拆分存储为指定格式？

可行性说明 #

完全可行，我们可以借助Java的JSON解析库（如Jackson或Gson）先将JSON字符串解析为二维字符串数组，再遍历拆分到目标数组中。

实现方案（以Jackson为例） #

1. 引入Jackson依赖（Maven项目在pom.xml中添加）：

<dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-databind</artifactId>
    <version>2.15.2</version>
</dependency>

2. 编写解析代码：

import com.fasterxml.jackson.databind.ObjectMapper;

public class JsonSplitParser {
    public static void main(String[] args) throws Exception {
        // 原始二维JSON字符串
        String rawJson = "[[\"1234\",\"OS\",\"01/31/2023\",\"02/01/2023\",\"First Day\"],[\"1245\",\"OS\",\"01/23/2023\",\"01/24/2023\",\"Last Day\"],[\"3411\",\"OS\",\"09/21/2022\",\"09/21/2022\",\"Second Day\"]]";
        
        // 解析为二维字符串数组
        ObjectMapper mapper = new ObjectMapper();
        String[][] dataMatrix = mapper.readValue(rawJson, String[][].class);
        
        // 初始化目标数组
        int rowCount = dataMatrix.length;
        String[] firstElements = new String[rowCount];
        String[] secondElements = new String[rowCount];
        String[] thirdElements = new String[rowCount];
        String[] fourthElements = new String[rowCount];
        String[] fifthElements = new String[rowCount];
        
        // 遍历拆分数据
        for (int i = 0; i < rowCount; i++) {
            String[] currentRow = dataMatrix[i];
            firstElements[i] = currentRow[0];
            secondElements[i] = currentRow[1];
            thirdElements[i] = currentRow[2];
            fourthElements[i] = currentRow[3];
            fifthElements[i] = currentRow[4];
        }
        
        // 验证输出（可选）
        System.out.println("第一列数据：");
        for (String item : firstElements) {
            System.out.println(item);
        }
    }
}

替代方案（Gson实现） #

如果项目已使用Gson，可采用以下方式：

1. 引入Gson依赖：

<dependency>
    <groupId>com.google.code.gson</groupId>
    <artifactId>gson</artifactId>
    <version>2.10.1</version>
</dependency>

2. 解析代码：

import com.google.gson.Gson;

public class GsonSplitParser {
    public static void main(String[] args) {
        String rawJson = "[[\"1234\",\"OS\",\"01/31/2023\",\"02/01/2023\",\"First Day\"],[\"1245\",\"OS\",\"01/23/2023\",\"01/24/2023\",\"Last Day\"],[\"3411\",\"OS\",\"09/21/2022\",\"09/21/2022\",\"Second Day\"]]";
        
        Gson gson = new Gson();
        String[][] dataMatrix = gson.fromJson(rawJson, String[][].class);
        
        int rowCount = dataMatrix.length;
        String[] firstElements = new String[rowCount];
        String[] secondElements = new String[rowCount];
        String[] thirdElements = new String[rowCount];
        String[] fourthElements = new String[rowCount];
        String[] fifthElements = new String[rowCount];
        
        for (int i = 0; i < rowCount; i++) {
            String[] currentRow = dataMatrix[i];
            firstElements[i] = currentRow[0];
            secondElements[i] = currentRow[1];
            thirdElements[i] = currentRow[2];
            fourthElements[i] = currentRow[3];
            fifthElements[i] = currentRow[4];
        }
    }
}

注意事项 #

• 确保原始JSON的每一行都包含5个元素，避免数组越界；若存在数据长度不确定的情况，需在遍历前添加长度校验逻辑。
• 优先选择项目已引入的JSON库，避免冗余依赖。

内容的提问来源于stack exchange，提问作者Haris Qureshi