Java CsvUtil 工具类

Jokes-T

已于 2023-02-28 09:07:27 修改

阅读量465

点赞数

文章标签： java

于 2023-02-28 09:05:29 首次发布

本文链接：https://blog.csdn.net/qq_44785726/article/details/129254410

版权


import com.opencsv.bean.CsvToBean;
import com.opencsv.bean.CsvToBeanBuilder;
import com.opencsv.bean.HeaderColumnNameMappingStrategy;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.util.List;
import org.apache.commons.io.input.BOMInputStream;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class CsvUtil {

    private static final Logger LOGGER = LoggerFactory.getLogger(CsvUtil.class);

    public static <T> List<T> read(File file, Class<T> clazz) {
        try (InputStreamReader reader = new InputStreamReader(new BOMInputStream(new FileInputStream(file)), "UTF-8")) {
            HeaderColumnNameMappingStrategy<T> strategy = new HeaderColumnNameMappingStrategy<>();
            strategy.setType(clazz);
            CsvToBean<T> csvToBean = new CsvToBeanBuilder<T>(reader).withMappingStrategy(strategy).build();
            return csvToBean.parse();
        } catch (Exception e) {
            LOGGER.error("读取数据失败", e);
            return null;
        }
    }
}