使用java库将CSV数据转换为嵌套的json对象。

import org.apache.commons.csv.CSVFormat;
import org.apache.commons.csv.CSVParser;
import org.apache.commons.csv.CSVRecord;
import com.fasterxml.jackson.databind.ObjectMapper;

import java.io.FileReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class CSVtoJSONConverter {
    public static void main(String[] args) {
        try {
            // 读取CSV文件
            CSVParser parser = CSVFormat.DEFAULT.withHeader().parse(new FileReader("data.csv"));

            // 构建嵌套的JSON对象
            List<Map<String, Object>> jsonData = new ArrayList<>();
            for (CSVRecord record : parser) {
                Map<String, Object> data = new HashMap<>();
                data.put("id", record.get("id"));
                data.put("name", record.get("name"));
                data.put("age", Integer.parseInt(record.get("age")));
                jsonData.add(data);
            }

            // 将数据转换为JSON格式
            ObjectMapper mapper = new ObjectMapper();
            String json = mapper.writeValueAsString(jsonData);
            System.out.println(json);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}