csv导入

导入需要用到的依赖

		<!-- csv读写-->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-csv</artifactId>
            <version>1.8</version>
        </dependency>

controller层

	@PostMapping("/import")
    @Operation(summary = "导入个人会员")
    public JSONResult importCsv(@RequestParam(value = "file") MultipartFile file, Long orgId) throws Exception {
        return this.logic.importCsv(file, orgId);
    }

impl层

@Override
    public JSONResult importCsv(MultipartFile file, Long orgId) throws Exception {
        JSONResult jsonResult = new JSONResult();
        InputStreamReader input = new InputStreamReader(file.getInputStream(), "GBK");
        CSVParser records = CSVFormat.RFC4180.withSkipHeaderRecord().withHeader(HeadPersonal.class).parse(input);
        for (CSVRecord csvRecord : records) {
            MemberPersonal personal = new MemberPersonal();
            personal.setPersonalName(csvRecord.get(HeadPersonal.personalName));
            }
        }

注：HeadPersonal.class为定义的枚举的自定义标题

public enum HeadPersonal {
    personalName, gender
}