Reading Blob data from Oracle-using JDBC

Read Blob data through JDBC to demonstrate code

2. ImportJava. io. File;
3. ImportJava. io. FileOutputStream;
4. ImportJava. io. IOException;
5. ImportJava. io. InputStream;
6. ImportJava. io. OutputStream;
7. ImportJava. SQL. Connection;
8. ImportJava. SQL. DriverManager;
9. ImportJava. SQL. ResultSet;
10. ImportJava. SQL. Statement;
12. Public ClassJDBC {
13. // Public static void main (String [] args) throws Exception {
14. //// Write BLOB Data
15. //
16. /// Obtain the database connection
17. // Class. forName ("Oracle. jdbc. driver. OracleDriver ");
18. //
19. // Connection con = DriverManager. getConnection (
20. //
21. // "Jdbc: oracle: thin: @ 192.168.0.68: 1521: myOracle", "my", "123 ");
22. //
23. //// Process the transaction
24. //
25. // Con. setAutoCommit (false );
26. //
27. // Statement st = con. createStatement ();
28. //
29. /// Use the for update method to lock data rows
30. //
31. // ResultSet rs = st.exe cuteQuery (
32. //
33. // "Select content from user_content where id = 2 for update ");
34. //
35. // If (rs. next ()){
36. //
37. //// Obtain the java. SQL. Blob Object, and Cast is oracle. SQL. BLOB.
38. //
39. // Oracle. SQL. BLOB blob = (oracle. SQL. BLOB) rs. getBlob (1 );
40. //
41. //// Output stream to the database
42. //
43. // OutputStream outStream = blob. getBinaryOutputStream ();
44. //
45. //// Here, a file is used to simulate the input stream.
46. //
47. // File file = new File ("d: \ proxy.txt ");
48. //
49. // InputStream fin = new FileInputStream (file );
50. //
51. //// Write the input stream to the output stream
52. //
53. // Byte [] B = new byte [blob. getBufferSize ()];
54. //
55. // Int len = 0;
56. //
57. // While (len = fin. read (B ))! =-1 ){
58. //
59. // OutStream. write (B, 0, len );
60. //
61. //// Blob. putBytes (1, B );
62. //
63. //}
64. //
65. //// Close (pay attention to the Order)
66. //
67. // Fin. close ();
68. //
69. // OutStream. flush ();
70. //
71. // OutStream. close ();
72. //
73. // Con. commit ();
74. //
75. // Con. close ();
76. //}
77. //}
79. Public Static VoidMain (String [] args)ThrowsException {
80. // Read BLOB Data
82. Class. forName ("Oracle. jdbc. driver. OracleDriver");
84. Connection con = DriverManager. getConnection (
86. "Jdbc: oracle: thin: @ 192.168.0.68: 1521: myOracle","My","123");
88. Con. setAutoCommit (False);
90. Statement st = con. createStatement ();
92. // The SQL statement here does not need "for update"
94. ResultSet rs = st.exe cuteQuery (
96. "Select content from user_content where id = 2");
98. If(Rs. next ()){
100. Java. SQL. Blob blob = rs. getBlob (1);
102. InputStream ins = blob. getBinaryStream ();
104. // Simulate the output stream with a file
106. File file =NewFile ("D: \ output.txt");
108. OutputStream fout =NewFileOutputStream (file );
110. // Write BLOB data to the file below
112. Byte[] B =New Byte[1024];
114. IntLen =0;
116. While(Len = ins. read (B ))! =-1){
118. Fout. write (B,0, Len );
120. }
122. // Close in sequence
124. Fout. close ();
126. Ins. close ();
128. Con. commit ();
130. Con. close ();
131. }
132. }
133. }