67,550
社区成员




conn = jdbctemplate.getDataSource().getConnection();
conn.setAutoCommit(false);
ps = conn.prepareStatement("UPDATE ZP SET ZP = EMPTY_BLOB() " + sql.toString());
ps.execute();
ps = null;
ps = conn.prepareStatement("SELECT ZP FROM ZP " + sql.toString() + " FOR UPDATE");
rs = ps.executeQuery();
if(rs.next()){
blob = (oracle.sql.BLOB)rs.getBlob(1);
os = blob.getBinaryOutputStream();
byte [] b = decoder.decodeBuffer(photo);
InputStream is = new ByteArrayInputStream(b);
byte [] data = new byte[1024];
int len=-1;
while((len = is.read(data)) > -1){
os.write(data, 0, len);
}
}else{
msgInfo = "无对应记录。";
}
os.flush();
os.close();
conn.commit();
Map map = jdbctemplate.queryForMap(sql.toString());
// oracle.sql.BLOB blob = (oracle.sql.BLOB)map.get("ZP");
BASE64Encoder encoder = new BASE64Encoder();
photo = encoder.encode((byte[])map.get("ZP"));