有关csv文件上传及其对象批量入库-超详细

public void uploadFile1(MultipartFile file) throws Exception {

对文件进行校验，可根据自身业务需求设置强/弱校验，很多博客都会有

boolean flag = CommonUtils.checkFile(file);
if (flag == false) {
    throw new Exception("文件格式有误");
}

List<ApiXetZhiboUsers> result = new ArrayList<ApiXetZhiboUsers>();//list对象集
int count = 0;
try {
//将文件转换成字节流，并设置编译格式
    byte[] byteArr = file.getBytes();
    InputStream inputStream = new ByteArrayInputStream(byteArr);
    CsvReader csvReader = new CsvReader(inputStream, Charset.forName("UTF-8"));
    List splitTitle = new ArrayList<>();
    List<String> splitTitle1 = new ArrayList<>();

//对csv文件进行读取

while (csvReader.readRecord()) {
    count++;
//每行读取之后的对象
    ApiXetZhiboUsers users = new ApiXetZhiboUsers();
    String rawRecord = csvReader.getRawRecord();

//防止某些字段存在分隔符，csv是已逗号为分割，多以要对逗