shujuju/boman-modules/boman-file/src/main/java/com/boman/file/controller/ExcelController.java

package com.boman.file.controller;

import com.alibaba.fastjson.JSONObject;
import com.boman.common.core.web.domain.AjaxResult;
import com.boman.domain.dto.ImportExcelDto;
import com.boman.file.service.ISysFileService;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author shiqian
 * @date 2021年06月07日 16:24
 **/
@RestController
@RequestMapping("/common/file")
public class ExcelController {

    @Resource
    private ISysFileService fileService;

    /**
     * 功能描述:
     *
     * @param multipartFile multipartFile
     * @return void
     */
//    @PostMapping("/import")
//    public static AjaxResult importExcel(MultipartFile multipartFile) {
//        File file = FileUploadUtils.multipartFile2File(multipartFile);
//        EasyExcel.read(file, JSONObject.class, new ExcelListener<JSONObject>()).sheet().headRowNumber(1).doRead();
//        FileUploadUtils.delete(file);
//        return AjaxResult.success();
//    }


    /**
     * 功能描述: 通用的导入接口
     *
     * @param dto MultipartFile 和 tableName
     * @return void
     */
    @PostMapping("/import")
    public AjaxResult importExcelCommon(@RequestBody ImportExcelDto dto) {
        MultipartFile multipartFile = dto.getMultipartFile();
        String tableName = dto.getTableName();
        List<JSONObject> result = null;
        try {
            result = fileService.importExcelCommon(multipartFile, tableName);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return AjaxResult.success(result);
    }



}