mybatis 将二进制文件写入数据库保存，和文件下载

最新推荐文章于 2023-03-09 23:23:43 发布

java_陈序猿

最新推荐文章于 2023-03-09 23:23:43 发布

阅读量3.5k

点赞数

分类专栏： Springboot 二进制文件保存

本文链接：https://blog.csdn.net/maple980326/article/details/104269465

版权

Springboot 同时被 2 个专栏收录

6 篇文章 1 订阅

订阅专栏

二进制文件保存

1 篇文章 0 订阅

订阅专栏

上传
public AjaxResult up(MultipartFile file) throws Exception {
    if (null == file) {
        return AjaxResult.error("文件为空");
    }
    byte[] imgbytes = file.getBytes();
 
    String filename = file.getOriginalFilename();
  
    logger.info("===filename===" + filename);
    Attachment attachment = new Attachment();
    attachment.setData(imgbytes);
    attachment.setFilename(filename);
    yqSelfService.addAttachment(attachment);
    return AjaxResult.success("成功", attachment.getId());

}

 <insert id="addAttachment" useGeneratedKeys="true" keyProperty="id" parameterType="Attachment">
insert into  attachment (filename,`data`) values (#{filename},#{data,typeHandler=org.apache.ibatis.type.BlobTypeHandler})
 </insert>

文件下载

 @GetMapping(value = "/down/file")
    public AjaxResult importData(Long id, HttpServletResponse response) throws Exception {
        byte[] imgbytes = yqSelfService.findAttachment(id);
        if (null != imgbytes) {
            OutputStream out = response.getOutputStream();
            out.write(imgbytes);
        }
        return null;
    }

   public byte[] findAttachment(Long id) {
        try {
            Map<String, Object> map = yqSelfMapper.findAttachment(id);
            return (byte[]) map.get("data");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    <resultMap type="java.util.Map" id="imgResultMap" >
        <result  property="data" column="data" jdbcType="BLOB"  typeHandler="org.apache.ibatis.type.BlobTypeHandler"/>
    </resultMap>

    <select id="findAttachment" parameterType="map" resultMap="imgResultMap">
        SELECT   a.`data`   FROM attachment  a WHERE a.id= #{id}
    </select>

前端展示