Spring轻松读取文件方法

最新推荐文章于 2023-08-30 16:16:16 发布

琴仙咩豆丁

最新推荐文章于 2023-08-30 16:16:16 发布

阅读量1.3k

点赞数

分类专栏： mybatis 文章标签： q'w

本文链接：https://blog.csdn.net/bc_aptx4869/article/details/80521443

版权

mybatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

<!--自己实现上传逻辑，用来返回进度条-->
    <bean id="multipartResolver" 
        class="com.jssh.credit.infrastructure.multipart.resolver.CommonsMultipartResolverExt">
        <!-- 设置上传文件的最大尺寸为10MB 10*1024*1024 -->
        <property name="maxUploadSize">
            <value>524288000</value>
        </property>
        <property name="defaultEncoding">
            <value>UTF-8</value>
        </property>
    </bean>

@RequestMapping("/addBrokersByFile")
    @ResponseBody
    public ResponseMessage addBrokersByFile(HttpServletRequest request, MultipartHttpServletRequest multipartRequest){

        UserRequestDTO user = WebHelper.getUser(request);
        if (user==null)
            return new ResponseMessage(ResponseConstants.登录失效,"登录已失效");


        // 先实例化一个文件解析器
        CommonsMultipartResolver commonsMultipartResolver = new CommonsMultipartResolver(request.getSession()
                .getServletContext());

        // 判断request请求中是否有文件上传
        if (commonsMultipartResolver.isMultipart(request)) {

            MultipartFile multipartFile = multipartRequest.getFile("file");//文件

            String _fileName = multipartFile.getOriginalFilename();//原始文件名
            String suffix = _fileName.substring(_fileName.lastIndexOf("."));//后缀名

            //判断文件的格式
            if (".xls".equals(suffix)){
                String localPath = MyConfigProperty.getProperty("uploads_local_path");
                if (StringUtils.isNotBlank(localPath)&&localPath.startsWith("file:"))
                    localPath = localPath.substring(5);
                String fileName = localPath+"\\excel\\"+user.getUserAccount()+"\\"+ DateUtils.dfYMDHM.format(new Date())+"\\";

                //上传后记录的文件...
                File excelFile = new File(fileName+_fileName);
                if (!excelFile.exists()){
                    new File(fileName).mkdirs();
                    try {
                        excelFile.createNewFile();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
                try {
                    multipartFile.transferTo(excelFile);
                } catch (IOException e) {
                    e.printStackTrace();
                    return new ResponseMessage(ResponseConstants.ERROR,"文件解析失败");
                }

                try{

                    return new ResponseMessage(ResponseConstants.OK,"Excel文件导入成功");
                }catch(Exception e){
                    return new ResponseMessage(ResponseConstants.ERROR,e.getMessage());
                }




            }else{
                return new ResponseMessage(ResponseConstants.ERROR,"文件格式不正确，请使用下载的模版填写");
            }
        }
        return null;
    }