将csv文件的特定列映射到特定的POJO字段开发者社区

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

体贴的木耳 · 分享照片或视频 | 领英学习帮助中心· 4 月前 ·

豪爽的金针菇 · Google Chrome浏览器 ...· 4 月前 ·

气宇轩昂的自行车 · 刚刚发布！合肥高考重大变化！_考区· 9 月前 ·

苦恼的冲锋衣 · 苏州机场，真的要来了？_建设_规划_运输机· 9 月前 ·

风流倜傥的乒乓球 · 一键解锁消博会逛展攻略_商务动态_海南省商务厅· 11 月前 ·

腾讯云

开发者社区

文档意见反馈控制台

首页 TVP

文章/答案/技术大牛

发布

public static List<BaseDataModel> readCSVFile(String filePath,List<String> columnListBasedOnIndex) {
        List<BaseDataModel> csvDataModels = null;
        File myFile = new File(filePath);
        try (FileInputStream fis = new FileInputStream(myFile)) {
            final ColumnPositionMappingStrategy<BaseDataModel> strategy = new ColumnPositionMappingStrategy<BaseDataModel>();
            strategy.setType(BaseDataModel.class);
            strategy.setColumnMapping(columnListBasedOnIndex.toArray(new String[0]));
            final CsvToBeanBuilder<BaseDataModel> beanBuilder = new CsvToBeanBuilder<>(new InputStreamReader(fis));
            beanBuilder.withMappingStrategy(strategy);
            csvDataModels = beanBuilder.build().parse();
        } catch (Exception e) {
            e.printStackTrace();
List<ColumnIndexMapping> columnIndexMappingList = dataSourceModel.getColumnMappingStrategy();
                    List<String> columnNameList = columnIndexMappingList.stream().map(ColumnIndexMapping::getColumnname)
                            .collect(Collectors.toList());
List<BaseDataModel> DataModels = Utility
                                    .readCSVFile(file.getAbsolutePath() + File.separator + fileName, columnNameList);

CsvParserSettings settings = new CsvParserSettings();
        settings.detectFormatAutomatically(); //detects the format 
        settings.getFormat().setLineSeparator("\n");
        //extracts the headers from the input
        settings.setHeaderExtractionEnabled(true);
        settings.selectIndexes(0, 2); //rows will contain only values of columns at position 0 and 2
        CsvRoutines routines = new CsvRoutines(settings); // Can also use TSV and Fixed-width routines
        routines.parseAll(BaseDataModel.class, new File("/path/to/your.csv"));
        List<String[]> rows = new CsvParser(settings).parseAll(new File("/path/to/your.csv"), "UTF-8");

public class BaseDataModel {
    private String a;
    private int b;
    private String c;

回答 1

Stack Overflow用户