'初始化'

admin

2021-06-29 0a03971cf8b1ca89f171946ecce8e8e6435b9ec5

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
package org.yeshi.utils;
 
import java.io.InputStreamReader;
import java.util.List;
 
import org.springframework.web.multipart.MultipartFile;
 
import com.opencsv.bean.CsvToBean;
import com.opencsv.bean.CsvToBeanBuilder;
import com.opencsv.bean.HeaderColumnNameMappingStrategy;
 
public class CsvUtil {
 
    /**
     * 解析csv文件并转成bean
     * 
     * @param file  csv文件
     * @param clazz 类
     * @param       <T> 泛型
     * @return 泛型bean集合
     */
    public static <T> List<T> getCsvData(MultipartFile file, Class<T> clazz) {
        InputStreamReader in = null;
        try {
            in = new InputStreamReader(file.getInputStream(), "gbk");
        } catch (Exception e) {
            e.printStackTrace();
        }
 
        HeaderColumnNameMappingStrategy<T> strategy = new HeaderColumnNameMappingStrategy<>();
        strategy.setType(clazz);
 
        CsvToBean<T> csvToBean = new CsvToBeanBuilder<T>(in).withSeparator(',').withQuoteChar('\'')
                .withMappingStrategy(strategy).build();
        return csvToBean.parse();
    }
}