===========================================================
Oracle显示BFile
===========================================================
作者: junsheng(http://junsheng.itpub.net)
发表于: 2004.12.02 21:05
分类: 工作
出处: http://junsheng.itpub.net/post/860/8218
---------------------------------------------------------------
发表于: 2004.12.02 21:05
分类: 工作
出处: http://junsheng.itpub.net/post/860/8218
---------------------------------------------------------------
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@orcl","system","manager");
Statement stmt=conn.createStatement();
ResultSet rset=stmt.executeQuery("select * from bfiletable");
while(rset.next()){
//获取bfile
BFILE bfile=((OracleResultSet)rset).getBFILE("pic");
//打开bfile
bfile.openFile();
int length=(int)bfile.length();
InputStream instream=bfile.getBinaryStream();
byte[] buffer=new byte[lengh];
//从instream中读到buffer中
instream.read(buffer);
//把buffer中的数据显示在button上
button =new JButton(new ImageIcon(buffer));
instream.close();
bfile.close();
}
//关闭数据库的连接
rset.close();
stmt.close();
conn.close();
