Oracle数据库直连取BLOB类型的图片流展示在前端

J1nEmber

于 2023-11-23 20:36:01 发布

阅读量168

点赞数 1

文章标签：数据库 oracle 前端

本文链接：https://blog.csdn.net/qq_30400717/article/details/134585914

版权

   Connection connection = null;
           PreparedStatement prepareStatement = null;
           ResultSet resultSet = null;
           String Sql = "select TO_BLOB(PHOTO) PHOTO from SY_USER where ID=?";
           try {

connection = KstarOracleDruidDSUtil.getConnection();

               prepareStatement = connection.prepareStatement(Sql);
               prepareStatement.setObject(1, aoiList.get(0).get("ID").toString());
               resultSet = prepareStatement.executeQuery();
//
               if (resultSet.next()) {
                   Blob blob = resultSet.getBlob("PHOTO");

                   byte[] bytes = blob.getBytes(1, (int) blob.length());

                   text = "data:image/jpeg;base64," + Base64.getEncoder().encodeToString(bytes);
               }

           } catch (Exception e) {
               // TODO: handle exception
           } finally {
               KstarOracleDruidDSUtil.close(prepareStatement, connection);
           }