oracle中读取blob字段

《oracle中读取blob字段》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle中blob类型的读取虽然用blob的情况不多，但是还是得了解一下，网上看得有点乱，而且没有看到从数据读blob的。在此总结一下：数据库中的建表语句如下：Sql代码1createtableblogtest(idnumberprimarykey,namevarchar2(20),pictureblob);Java代码2packageAugust;34importjava.io.FileInputStream;5importjava.io.FileOutputStream;6importjava.io.InputStream;7importjava.

2、io.OutputStream;8importjava.sql.Connection;9importjava.sql.DriverManager;10importjava.sql.PreparedStatement;11importjava.sql.ResultSet;12importjava.sql.SQLException;13importjava.sql.Statement;1415publicclassOracleBlobTest{16publicstaticvoidmain(String[]args){1718}19publicstaticvoi

3、dreadBlob(){20try{21Class.forName("oracle.jdbc.driver.OracleDriver");22Connectionconn=DriverManager.getConnection(23"jdbc:oracle:thin:@127.0.0.1:1521/july","scott",24"snaillocke");25Statementst=conn.createStatement();26PreparedStatementps=conn.prepareStatement("select*fromBLOBTEST

4、whereid=?");27ps.setInt(1,1);28ResultSetrs=ps.executeQuery();29rs.next();30oracle.sql.BLOBimgBlob=(oracle.sql.BLOB)rs.getBlob(3);3132//将二进制数据写入BLOB1try{2FileOutputStreamoutStream=newFileOutputStream("D:/oracleback.png");3InputStreaminStream=imgBlob.getBinaryStream();4byte[]buf=new

5、byte[10240];5intlen;6while((len=inStream.read(buf))>0){7outStream.write(buf,0,len);8}9inStream.close();10outStream.close();11}catch(Exceptione){12e.printStackTrace();13}141516}catch(ClassNotFoundExceptione){17e.printStackTrace();18}catch(SQLExceptione){19e.printStackTrace();20}21}

6、22publicstaticvoidwriteBlob(){23try{24Class.forName("oracle.jdbc.driver.OracleDriver");25Connectionconn=DriverManager.getConnection(26"jdbc:oracle:thin:@127.0.0.1:1521/july","scott",27"snaillocke");28Statementst=conn.createStatement();29//插入一个空对象empty_blob()30//锁定数据行进行更新，注意“forupd

7、ate”语句31PreparedStatementps=conn.prepareStatement("insertintoBLOBTEST(ID,NAME,PICTURE)values(1,'fang.jpg',?)");32//通过ORALCE.SQL.BLOB/CLOB.EMPTY_LOB()构造空BLOB/CLOB对象33ps.setBlob(1,oracle.sql.BLOB.empty_lob());34ps.execute();35ps.close();3637//再次对读出BLOB/CLOB句柄38ps=conn39.prepareState

8、ment("SELECT*FROMBLOBTESTWHEREID=