根据url获取文件流MultipartFile

最新推荐文章于 2024-08-16 10:30:42 发布

一直入门没有精通过

最新推荐文章于 2024-08-16 10:30:42 发布

阅读量2.2k

点赞数

文章标签： java 数据库 mysql

本文链接：https://blog.csdn.net/leibaoxue/article/details/130746096

版权

本文详细介绍了如何在Java中从URL获取文件流并转换为MultipartFile对象，适用于上传文件到数据库如MySQL的需求。

摘要由CSDN通过智能技术生成

1.pom文件添加
<dependency>
    <groupId>commons-fileupload</groupId>
    <artifactId>commons-fileupload</artifactId>
    <version>1.3.3</version>
</dependency>

2.详细代码

 @GetMapping({"upload"})
    @ApiOperation("上传文件")
    public com.uniedp.core.utils.Result<Map<String, Object>> upload() throws Exception {
        Map<String, Object> params = new HashMap<>();
        ExcelReader excelReader = ExcelUtil.getReader(new File("C:\\Users\\20011709\\Desktop\\新建 Microsoft Excel 工作表.xlsx"));
        //读取为Map列表，默认第一行为标题行，Map中的key为标题，value为标题对应的单元格值。
        List<Map<String, Object>> c = excelReader.readAll();
        System.out.println("数据解析完成----");
        List<MultipartFile> multipartFiles = new ArrayList<>();
        ArrayList<Object> objects = new ArrayList<>();
        for (int i = 0; i < c.size(); i++) {

            String a2 = String.valueOf(c.get(i).get("重点领域"));
            MultipartFile multipartFile = createFileItem(a2);
            multipartFiles.add(multipartFile);
            System.out.println("---"+a2);

        }
        SysOssDTO dto = new SysOssDTO();
        ConvertUtils.register(new DateConverter((Object)null), Date.class);
        BeanUtils.populate(dto, params);
        List<Map> datas = new ArrayList<>();
        List<SysIconImgEntity> list = new ArrayList<>();
        for(int i = 0; i < multipartFiles.size(); i++) {
            FileResult r = FileUtils.upLoad(dto, multipartFiles.get(i));
            Map<String, Object> data = new HashMap(1);
            data.put("id", r.getId());
            data.put("name", r.getName());
            data.put("url", r.getUrl());
            SysIconImgEntity sysIconImgEntity = new SysIconImgEntity();
            sysIconImgEntity.setName(r.getName());
            sysIconImgEntity.setUrl(r.getUrl());
            list.add(sysIconImgEntity);
            datas.add(data);
        }
        int num = sysIconImgService.batchInsertIconImg(list);
        System.out.println(num);
        return (new com.uniedp.core.utils.Result()).ok(datas);
//        }
    }



    public MultipartFile createFileItem(String url) throws Exception{
        FileItem item = null;
        HttpURLConnection conn = (HttpURLConnection) new URL(url).openConnection();
        conn.setReadTimeout(30000);
        conn.setConnectTimeout(30000);

        // 设置应用程序要从网络连接读取数据
        conn.setDoInput(true);
        conn.setRequestMethod("GET");
        String fileName = "";

        if (conn.getResponseCode() =&