CSV阅读器空值java

Question

我有这个CSV:

0,102000082,,2,125,'Battery location','Left-hand drive',2,2
0,300000029,102000082,3,895,'Behind the cab','Left',2,-7
0,102000082,,4,127,'Battery location','Right-hand drive',4,4
            ^-----

我使用csvReader映射到bean

    public static List<BatteryBean> loadAndRead{
    File csvFilename = new File("C:\my.csv");
    CSVReader csvReader = new CSVReader(new FileReader(csvFilename));
    ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy();
    strat.setType(BatteryBean.class);
    String[] columns = new String[] { "ktypnr","sentenceId","parentId","sortOrder", "adjItemNoteId","sentText","itemNoteText","parentSortOrder1","parentSortOrder10" };
    strat.setColumnMapping(columns);
    CsvToBean csv = new CsvToBean();
    List<BatteryBean> list = csv.parse(strat, csvReader);
    return list;
}

public static void main(String[] args) {
    try {
        List<BatteryBean> list = loadAndRead("C:\work\battery_report_raw.csv");
        for (Object object : list) {
            BatteryBean bb = (BatteryBean) object;
            System.out.println(bb.getKtypnr());
        }
   }

所以问题是文件包含，之间的空字符串，我在解析时得到一个异常:

由:java.lang.NumberFormatException: For input string: "

我解决。我还有一个问题

Csv file
ktypnr  sentence_id    parent_id    sort_order  adj_item_note_id      sent_text              iem_note_text
0         102000082                  2                  125             Battery location'   Left-hand drive'
0         300000029    102000082     3                  895             Behind the cab'        Left'
0         102000082                  4                  127             Battery location'       Right-hand drive'
0         300000029    102000082     5                  898             Behind the cab'        Right'

如果one sentence_id = one parent_id我应该把这两个组合起来，就像这样(第一行和第二行)我还应该考虑sort_order:

0, Battery location, Left-hand drive, Behind the cab, Left

我不知道如何继续

Answer 1

将BatteryBean中的parentId数据类型更改为String。