img显示从数据库取出blob字段

最新推荐文章于 2024-12-30 17:11:02 发布

weixin_33849942

最新推荐文章于 2024-12-30 17:11:02 发布

阅读量891

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 javascript php ViewUI

原文链接：http://www.cnblogs.com/zhanchigaofei/p/6952389.html

本文介绍了一种通过Java Web应用从数据库中获取特定用户的头像，并将其展示在网页上的方法。具体实现包括使用JDBC连接数据库、执行SQL查询获取Blob类型的数据、将图片数据转换为字节流并通过HTTP响应返回给前端。

@RequestMapping("/getPictureForpeople")
public void getPictureForpeople(HttpServletRequest request, HttpServletResponse response) throws IOException, SQLException {
    Connection conn = null;
    conn = GetJDBCConnection.getJDBCConnection();
    Statement stmt = conn.createStatement();
    String getPicSQL = "select header from lc0039999.idmidentityinfo where code = 'houzt'";
    ResultSet rs = stmt.executeQuery(getPicSQL);
    Blob img=null;
    if(rs.next()) {
        img = rs.getBlob("header");
    }
    long size=img.length();
    byte[] bs=img.getBytes(1, (int)size);
   // response.setContentType("image/jpeg");
    ServletOutputStream outs=response.getOutputStream();
    outs.write(bs);
    outs.flush();
}

<img src="${ctx}/PersonPages/getPictureForpeople" style="width: 100px;height:120px;border:5px solid #104365;clear: both; display: block; margin:auto; "/>

转载于:https://www.cnblogs.com/zhanchigaofei/p/6952389.html