java 处理 BLOB OutputStream(插入空的Blob字段到表中)-技术博客集

java 处理 BLOB OutputStream(插入空的Blob字段到表中)
编程技术 / houtizong 发布于 3年前 53

1.插入占位数据：

insert into TEST_CUICF(t1,t2) values(12,empty_blob())

2.获得占位数据：

select t1,t2 from TEST_CUICF t for update

BLOB oracleBlobMockIn = oracleBlobMockIn = control.createMock(BLOB.class);

...

oracleBlobMockIn.getBinaryStream();
expectLastCall().andReturn(new FileInputStream(inPdfFile)).times(1);

...

  ResultSet rs = st.executeQuery(sql);
  BLOB oracleBlobMockOut = null;
  if (rs.next()) {
   rs.getString("t1");
   oracleBlobMockOut = (BLOB) rs.getBlob("t2");
  }
...

  control.replay();
  Watermark.addPdfWatermark(oracleBlobMockIn, oracleBlobMockOut, markImagePath);
  control.verify();
  control.reset();

3.应用输出流 (增加水印处理)

public static void addPdfWatermark(BLOB inputPdfFileBlob, BLOB outPdfFileBlob, String markImagePath) throws Exception {
  if (null == WATERMARK_IMAGE) {
   logger.info("watermark_image inital~~");
   WATERMARK_IMAGE = Image.getInstance(markImagePath);
   WATERMARK_IMAGE.setAbsolutePosition(10, 250);
  }

  PdfReader reader = null;
  PdfStamper stamp = null;
  try {
   reader = new PdfReader(inputPdfFileBlob.getBinaryStream(), "PDF".getBytes());
   stamp = new PdfStamper(reader, outPdfFileBlob.getBinaryOutputStream()); //获得输出流

int numberOfPages = reader.getNumberOfPages();
 for (int i = 1; i <= numberOfPages; i++) {
 PdfContentByte under = stamp.getUnderContent(i);
 under.addImage(WATERMARK_IMAGE);
 }

  } finally {
   stamp.close();
  }
}

4.关闭连接

con.commit();

con.close();

上一篇：getResourceAsStream Returning Null

下一篇：XML的命名空间

请勿发布不友善或者负能量的内容。与人为善，比聪明更重要！

<div style="font-size: 14px;" > 1.插入占位数据： insert into TEST_CUICF(t1,t2) values(12,empty_blob()) 2.获得占位数据： select t1,t2 from TEST_CUICF t for update &nbsp; BLOB oracleBlobMockIn = oracleBlobMockIn = control.createMock(BLOB.class); ... &nbsp;&nbsp;oracleBlobMockIn.getBinaryStream(); &nbsp;&nbsp;expectLastCall().andReturn(new FileInputStream(inPdfFile)).times(1); ... &nbsp;&nbsp;ResultSet rs = st.executeQuery(sql); &nbsp;&nbsp;BLOB oracleBlobMockOut = null; &nbsp;&nbsp;if (rs.next()) { &nbsp;&nbsp;&nbsp;rs.getString(&quot;t1&quot;); &nbsp;&nbsp;&nbsp;oracleBlobMockOut = (BLOB) rs.getBlob(&quot;t2&quot;); &nbsp;&nbsp;} ... &nbsp;&nbsp;control.replay(); &nbsp;&nbsp;Watermark.addPdfWatermark(oracleBlobMockIn, oracleBlobMockOut, markImagePath); &nbsp;&nbsp;control.verify(); &nbsp;&nbsp;control.reset(); &nbsp; 3.应用 输出流 (增加水印处理) &nbsp;public static void addPdfWatermark(BLOB inputPdfFileBlob, BLOB outPdfFileBlob, String markImagePath) throws Exception { &nbsp;&nbsp;if (null == WATERMARK_IMAGE) { &nbsp;&nbsp;&nbsp;logger.info(&quot;watermark_image inital~~&quot;); &nbsp;&nbsp;&nbsp;WATERMARK_IMAGE = Image.getInstance(markImagePath); &nbsp;&nbsp;&nbsp;WATERMARK_IMAGE.setAbsolutePosition(10, 250); &nbsp;&nbsp;} &nbsp;&nbsp;PdfReader reader = null; &nbsp;&nbsp;PdfStamper stamp = null; &nbsp;&nbsp;try { &nbsp;&nbsp;&nbsp;reader = new PdfReader(inputPdfFileBlob.getBinaryStream(), &quot;PDF&quot;.getBytes()); &nbsp;&nbsp;&nbsp;stamp = new PdfStamper(reader, outPdfFileBlob.getBinaryOutputStream()); //获得输出流 &nbsp;&nbsp;&nbsp;int numberOfPages = reader.getNumberOfPages(); &nbsp;&nbsp;&nbsp;for (int i = 1; i &lt;= numberOfPages; i++) { &nbsp;&nbsp;&nbsp;&nbsp;PdfContentByte under = stamp.getUnderContent(i); &nbsp;&nbsp;&nbsp;&nbsp;under.addImage(WATERMARK_IMAGE); &nbsp;&nbsp;&nbsp;} &nbsp;&nbsp;} finally { &nbsp;&nbsp;&nbsp;stamp.close(); &nbsp;&nbsp;} &nbsp;} 4.关闭连接 &nbsp;&nbsp;con.commit(); &nbsp;&nbsp;con.close(); &nbsp; </div>

留言需要登陆哦

技术博客集 - 网站简介：
前后端技术：
后端基于Hyperf2.1框架开发,前端使用Bootstrap可视化布局系统生成
网站主要作用：
1.编程技术分享及讨论交流，内置聊天系统;
2.测试交流框架问题，比如：Hyperf、Laravel、TP、beego;
3.本站数据是基于大数据采集等爬虫技术为基础助力分享知识，如有侵权请发邮件到站长邮箱，站长会尽快处理;
4.站长邮箱：[email protected];

文章归档

文章标签

友情链接

首页
关于我们

Auther ·HouTiZong: 侯体宗的博客