springboot+mybatis上传图片保存到数据库，以及读取并在页面显示

最新推荐文章于 2023-02-24 18:20:30 发布

anjingjingg

最新推荐文章于 2023-02-24 18:20:30 发布

阅读量7.3k

点赞数 7

分类专栏： SpringBoot

本文链接：https://blog.csdn.net/anjingjingg/article/details/103204250

版权

SpringBoot 专栏收录该内容

16 篇文章 1 订阅

订阅专栏

1、mapper.xml文件

<insert id="insertOne" parameterType="java.util.Map">
    insert into imgtest (img)
    values (#{img, jdbcType=BLOB})
</insert>

2、pojo里，类型为byte[]

3、controller

存数据库

    @RequestMapping(value = "/addImg", method = RequestMethod.POST)
    @ResponseBody
    public Map<String,Object> addImg(HttpServletRequest request,
                                     @RequestParam("file") MultipartFile file){

        Map<String, Object> result = new HashMap<>();
        Map<String ,Object> params = new HashMap<>();
       
        try {
            byte[] data;
            data = file.getBytes();
            params.put("img", data);
            //插入数据库
        }catch (Exception e){
            e.printStackTrace();
        }
        result.put("message", "上传成功");
        return result;
    }

读取

    @RequestMapping(value = "/getImgById", method = RequestMethod.GET)
    public void getImgById(@RequestParam(value = "id")Long id,
                           HttpServletResponse response){
        try {
            ImgTest imgTest = imgService.getImgById(id);
            byte[] data = imgTest.getImg();
            response.setContentType("image/jpeg");
            response.setCharacterEncoding("UTF-8");
            OutputStream outputSream = response.getOutputStream();
            outputSream.write(data);
            outputSream.flush();
        }catch (IOException e){
            e.printStackTrace();
        }
    }

4、页面：

        <form action="/addImg" enctype="multipart/form-data" method="post">
            <input type="file" name="file">
            <input type="submit" value="上传">
        </form>

        <br>
        <img src = "/getImgById?id=1">