java - 以对象为参数导出到 CSV

Question

public class ExportFileDTO {

    private String user;
    private String id;
    private String date;
    private double humidity;
    private double pressure;
    private double temperature;

    private QuestionDTO question_1;
    private QuestionDTO question_2;
    private QuestionDTO question_3;
    private QuestionDTO question_4;
    private QuestionDTO question_5;
    private QuestionDTO question_6;
    private QuestionDTO question_7;
    private QuestionDTO question_8;

public class QuestionDTO {

    private String dt001;
    private String dt002;
    private String dt003;
    private String dt004;
    private String dt005;
    private String dt006;
    private String dt007;
    private String dt008;
    private String dt009;
    private String dt010;
}

邮递员结果：

[
    {
        "user": "",
        "id": "USER_ONE / USER_TWO",
        "date": "09/19/2021",
        "humidity": 20.0,
        "pressure": 1000.0,
        "temperature": 20.0,
        "question_1": {
            "dt001": "a1_dt1_q1",
            "dt002": "a1_dt2_q1",
            "dt003": "a1_dt3_q1",
            "dt004": "a1_dt4_q1",
            "dt005": "a1_dt5_q1",
            "dt006": "a1_dt6_q1",
            "dt007": "a1_dt7_q1",
            "dt008": "a1_dt8_q1",
            "dt009": "a1_dt9_q1",
            "dt010": "a1_dt10_q1"
        },
        "question_2": {
            "dt001": "a1_dt1_q2",
            "dt002": "a1_dt2_q2",
            "dt003": "a1_dt3_q2",
            "dt004": "a1_dt4_q2",
            "dt005": "a1_dt5_q2",
            "dt006": "a1_dt6_q2",
            "dt007": "a1_dt7_q2",
            "dt008": "a1_dt8_q2",
            "dt009": "a1_dt9_q2",
            "dt010": "a1_dt10_q2"
        },
        "question_3": {
            "dt001": "a1_dt1_q3",
            "dt002": "a1_dt2_q3",
            "dt003": "a1_dt3_q3",
            "dt004": "a1_dt4_q3",
            "dt005": "a1_dt5_q3",
            "dt006": "a1_dt6_q3",
            "dt007": "a1_dt7_q3",
            "dt008": "a1_dt8_q3",
            "dt009": "a1_dt9_q3",
            "dt010": "a1_dt10_q3"
        },

// etc ect
   }
]

我怎样才能导出这个文件并实现这个结果？我仍然有csv generator does not support object values for properties并且@JsonUnwrapped给了我错误的 csv 数据格式。是否可以将此数据导出到 csv 并实现此结果或类似结果？我需要将“question_1，question_2”作为一列..而不是作为行：/

我知道来自 POSTMAN 的数据与照片中的数据不一致，但例如缩写“a1_dt1_q3”表示（“a”）投票编号 1、（“dt1”）用户 dt001 和（“q”）问题 3。

我需要将用户作为行，将问题作为列。我已经坐了很多天了，无法解决:(

有可能吗？以前有没有人做过这样的事情并且可以帮助我做到这一点？我将非常感谢您帮助解决此任务。

标签： javaspring-bootcsv