hibernate 4+spring 处理mysql blob类型

最新推荐文章于 2022-05-06 15:24:24 发布

Absurd_my

最新推荐文章于 2022-05-06 15:24:24 发布

阅读量865

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/absurd1350/article/details/46501549

版权

java 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

model

    @Lob
    @Column(name = "HEADICON",updatable=true,insertable=true)
    private byte[] headIcon;

dao

        User rtUser =   getHibernateTemplate().get(User.class, user.getUserid());
        if(rtUser ==null) return false;
        InputStream is;
        try {
              is=new FileInputStream(new File(iconImg));
            byte[]  b = new byte[is.available()];
               is.read(b);
               is.close();
               rtUser.setHeadIcon(b);
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        getHibernateTemplate().update(rtUser);
        getHibernateTemplate().flush();

读取

    User rtUser = userService.getUser(user.getUserid());
        InputStream in =new ByteArrayInputStream(rtUser.getHeadIcon());
     HttpServletResponse response=ServletActionContext.getResponse();
     response.setContentType("image/jpeg");
     ServletOutputStream out = response.getOutputStream();
     byte[] buffer=new byte[500];
     int length = 0;
     while(-1 != (length = in.read(buffer, 0, buffer.length)))
     {
         out.write(buffer);
     }
     in.close();
     out.close();