å¦æè¦åæ°æ®åºçè¯ï¼æ°æ®åºåå¾çå段ç¨blobå½¢å¼ç(ç
§ç:zp为ä¾ï¼ã
èä¸ä¸è½ç´æ¥åï¼å¨åä¹åzpå段å
æå
¥ä¸ä¸ªempty.BLOB(),
ç¶åselect ZP from 表 for updateãåç¨è¾å
¥æµçå½¢å¼åè¿å»ã
// å
æ£ç´¢åºæ¥å段,å¿
须使ç¨oracleçç±»ï¼oracle.sql.BLOB
oracle.sql.BLOB blob = null;
if (rs.next())
{
blob = (oracle.sql.BLOB) rs.getBlob("ZP");
// å°æ°æ®åºçè¾åºæµ
OutputStream outStream = blob.getBinaryOutputStream();
// å°è¾å
¥æµåå°è¾åºæµ
byte[] b = new byte[blob.getBufferSize()];
int len = 0;
while ((len = is.read(b)) != -1)
{
outStream.write(b, 0, len);
// blob.putBytes(1,b);
}
is.close();
outStream.flush();
outStream.close();
}
åç
§ççè¯ï¼ååºæ¥è½¬åææµçå½¢å¼ç´æ¥å建jpgæ件就è¡äºã
Blob b = rs.getBlob("ZP");
File f = null;
if (b != null) {
is = b.getBinaryStream();
f = new File( "c:\\zp.jpg");
if (!f.exists()) {
f.createNewFile();
}
os = new FileOutputStream(f);
int len;
byte buf[] = new byte[2048];
while ((len = is.read(buf)) != -1) {
os.write(buf, 0, len);
}
is.close();
os.flush();
os.close();
}
强ç建议åªååç
§çè·¯å¾ï¼è¿æ ·æ¹ä¾¿ã
温馨提示:答案为网友推荐,仅供参考