毕业设计Day14--SpringBoot添加导入导出功能_springboot中export()写在哪里-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_46434074/article/details/130226968

该博客围绕Spring Boot课程设计展开，介绍了数据导出和导入操作。在controller添加代码，通过特定网址实现数据导出，以下载表格为成功标志；还进行了PostMan测试，控制台有相应反应则表示数据插入成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文章目录

导出

在controller中添加代码

 @GetMapping("/export")
    public void export(HttpServletResponse response) throws Exception{
        List<User> list = userService.list();
        //通过工具类创建writer 写出到磁盘路径
//        ExcelWriter writer = ExcelUtil.getWriter(filesUploadPath + "/用户信息.xlsx");
        //在内存操作，写出到浏览器
        ExcelWriter writer = ExcelUtil.getWriter("true");

        writer.addHeaderAlias("username","车主姓名");
        writer.addHeaderAlias("password","密码");
        writer.addHeaderAlias("nickname","昵称");
        writer.addHeaderAlias("email","邮箱");
        writer.addHeaderAlias("phone","电话");
        writer.addHeaderAlias("address","地址");
        writer.addHeaderAlias("carnum","车牌号");
        writer.addHeaderAlias("createTime","创建时间");

        writer.write(list,true);
        //浏览器响应格式
        response.setContentType("application/vnd.openxmlformates-officedocument.spreadsheetml.sheet;charset=utf-8");
        String filename = URLEncoder.encode("用户信息","UTF-8");
        response.setHeader("Content-Disposition","attachment;filename="+filename+".xlsx");

        ServletOutputStream out = response.getOutputStream();
        writer.flush(out,true);
        out.close();
        writer.close();
    }

在地址栏输入如下网址，看到下载的表格即为成功

localhost:9090/user/export

导入

@PostMapping("/import")
    public boolean imp(MultipartFile file) throws Exception{
        InputStream inputStream = file.getInputStream();
        ExcelReader reader = ExcelUtil.getReader(inputStream);
        List<User> list = reader.readAll(User.class);
        userService.saveBatch(list);
        System.out.println(list);
        return true;
    }