springboot项目实现CSV文件百万数据入库

最新推荐文章于 2024-12-23 16:42:55 发布

翻出乱世

最新推荐文章于 2024-12-23 16:42:55 发布

阅读量1.4k

点赞数 1

本文链接：https://blog.youkuaiyun.com/zhongyuan_p/article/details/127642815

版权

需要先引入解析工具

		<!--cvs 解析工具-->
		<dependency>
			<groupId>com.opencsv</groupId>
			<artifactId>opencsv</artifactId>
			<version>4.3.2</version>
		</dependency>

抽取出工具类

package io.renren.utils;

import com.opencsv.bean.CsvToBean;
import com.opencsv.bean.CsvToBeanBuilder;
import com.opencsv.bean.HeaderColumnNameMappingStrategy;
import org.springframework.web.multipart.MultipartFile;

import java.io.InputStreamReader;
import java.util.List;

public class cvsUtils {
    public static <T> List<T> getCsvData(MultipartFile file, Class<T> clazz) {
        InputStreamReader in = null;
        try {
            in = new InputStreamReader(file.getInputStream(), "gbk");
        } catch (Exception e) {
            System.out.println("读取文件失败");
        }

        HeaderColumnNameMappingStrategy<T> strategy = new HeaderColumnNameMappingStrategy<