1，首先建一個(gè)足夠簡(jiǎn)單的表imageTable
id varchar（20）
image blob
2，blob入庫
拷貝Sunset.jpg圖片在C盤根目錄下
1
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
2 Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:beyondduke","duke","duke");
3 conn.setAutoCommit(false);
4 BLOB blob = null;
5 PreparedStatement pstmt = conn.prepareStatement("insert into imageTable(id,image) values(?,empty_blob())");
6 pstmt.setString(1,"10001");
7 pstmt.executeUpdate();
8 pstmt.close();
9 pstmt = conn.prepareStatement("select content from imageTable where id= ? for update");
10 pstmt.setString(1,"10001");
11 ResultSet rs = pstmt.executeQuery();
12 if (rs.next()) blob = (BLOB) rs.getBlob(1);
13 String fileName = "c://Sunset.jpg";
14 File f = new File(fileName);
15 FileInputStream fin = new FileInputStream(f);
16 System.out.println("file size = " + fin.available());
17 pstmt = conn.prepareStatement("update imageTable set image=? where id=?");
18 OutputStream out = blob.getBinaryOutputStream();
19 byte[] data = new byte[(int)fin.available()];
20 fin.read(data);
21 out.write(data);
22 out.close();
23 fin.close();
24
25 pstmt.setBlob(1,blob);
26 pstmt.setString(2,"fankai");
27
28 pstmt.executeUpdate();
29 pstmt.close();
30
31 conn.commit();
32 conn.close(); 瀏覽數(shù)據(jù)庫的數(shù)據(jù)，發(fā)現(xiàn)image項(xiàng)中數(shù)據(jù)大小與圖片大小一致，說明入庫了！
3，blob出庫
1 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
2 Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:beyondduke", "duke","duke");
conn.setAutoCommit(false);
3 Statement stmt = conn.createStatement();
4
/**//* 查詢BLOB對(duì)象 */
5 ResultSet rs = stmt.executeQuery("SELECT content FROM javatest WHERE id='1001'");
6while (rs.next()) 
{
7
/**//* 取出此BLOB對(duì)象 */
8
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob("image");
9 BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream("d://Sunset.jpg"));
BufferedInputStream in = new BufferedInputStream(blob .getBinaryStream());
10 int c;
11while ((c = in.read()) != -1) { out.write(c);
12
}
13 in.close();
14 out.close();
15 rs.close();
16 stmt.close();
17 conn.close();
18 檢查D盤根目錄，會(huì)發(fā)現(xiàn)Sunset.jpg文件，跟C盤下是一樣的，說明入庫出庫成功！