public static void printPic()throws SQLException{
ResultSet rs=null;
Connection conn=null;
Statement stmt=null;
try {
//从ORACLE 生成图片
conn=getConn();
stmt=conn.createStatement();
rs=stmt.executeQuery("select zp from jczhxxgl.rk_zzrk where dbms_lob.getlength(zp)>0 and rownum<6");
int i=0;
while(rs.next()){
InputStream fi=null;
Blob blob = rs.getBlob("zp");
FileOutputStream outSTr = new FileOutputStream(new File("c:lll"+i+".jpg"));
i+=1;
BufferedOutputStream Buff=new BufferedOutputStream(outSTr);
Buff.write(blob.getBytes(1, (int)blob.length()));
Buff.flush();
Buff.close();
ResultSet rs=null;
Connection conn=null;
Statement stmt=null;
try {
//从ORACLE 生成图片
conn=getConn();
stmt=conn.createStatement();
rs=stmt.executeQuery("select zp from jczhxxgl.rk_zzrk where dbms_lob.getlength(zp)>0 and rownum<6");
int i=0;
while(rs.next()){
InputStream fi=null;
Blob blob = rs.getBlob("zp");
FileOutputStream outSTr = new FileOutputStream(new File("c:lll"+i+".jpg"));
i+=1;
BufferedOutputStream Buff=new BufferedOutputStream(outSTr);
Buff.write(blob.getBytes(1, (int)blob.length()));
Buff.flush();
Buff.close();
}
}
catch (Exception ex) {
ex.printStackTrace();
}
finally{
//rs.close();
stmt.close();
conn.close();
}
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9879835/viewspace-1000180/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9879835/viewspace-1000180/