oracle 手机壁纸,从ORACLE 生成图片

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();

}

}

catch (Exception ex) {

ex.printStackTrace();

}

finally{

//rs.close();

stmt.close();

conn.close();

}

}[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9879835/viewspace-1000180/，如需转载，请注明出处，否则将追究法律责任。