csv文件直接读取数据转bean

糕手慕辰

于 2024-02-23 12:03:06 发布

阅读量152

点赞数 3

分类专栏：问题记录文章标签： java

本文链接：https://blog.csdn.net/weixin_44928129/article/details/136252545

版权

问题记录专栏收录该内容

36 篇文章 8 订阅

订阅专栏

1.首先引入依赖

        <dependency>
            <groupId>com.opencsv</groupId>
            <artifactId>opencsv</artifactId>
            <version>5.3</version>
        </dependency>

2.创建实体类用@CsvBindByName(column = "Lat")去映射读取的列的名称

@Data
public class MinuteCimissTem implements Serializable {
    @CsvBindByName(column = "Station_Id_C")
    private String stationIdC;
    @CsvBindByName(column = "Station_Name")
    private String stationName;
    @CsvBindByName(column = "Lat")
    private String lat;
    @CsvBindByName(column = "Lon")
    private String lon;
    @CsvBindByName(column = "TEM")
    private String obsValue;
    @CsvBindByName(column = "Q_TEM")
    private String qTem;
    @CsvBindByName(column = "Station_levl")
    private String stationLevel;

}

3.读取文件数据为list

        File file = new File("D:\\ybn\\常用项目\\常用项目文件\\SURF\\aaa.csv");
        BufferedReader bufferedReader = new BufferedReader(new FileReader(file));
        CsvToBean<MinuteCimissTem> csvToBean = new CsvToBeanBuilder<MinuteCimissTem>(bufferedReader)
                .withType(MinuteCimissTem.class)
                .withIgnoreLeadingWhiteSpace(true)
                .withSeparator(',')
                .build();
        List<MinuteCimissTem> parse = csvToBean.parse();