利用Java代码把oracle的blob字段内容解析成XML格式的字符串

利用Java代码把oracle的blob字段内容解析成XML格式的字符串.

Java代码  

1. Statement statement = conn.createStatement();  
2.                 sql = " select b.fjbh,b.ws_template_id,b.multimedia from a,b_blob b where "+condition ;  
3.                 ResultSet resultSet = statement.executeQuery(sql) ;  
4.                   
5.                 while (resultSet.next()) {  
6.                     String fjbh = resultSet.getString(1);  
7.                     Blob blob = null;  
8.                     InputStream is = null;  
9.                     String distFile = "d:\\xml\\"+fjbh+".xml";  
10.                     OutputStream os = new FileOutputStream(distFile);  
11.                     blob = (Blob) resultSet.getBlob(3);  
12.                     is = blob.getBinaryStream();  
13.   
14.                     byte[] b = new byte[1024] ;  
15.                     int len = is.read(b);  
16.                     String newStr = "" ;  
17.                     while (len != -1) {  
18.                         os.write(b, 0, len);  
19.                         newStr = newStr+new String(b,"UTF-8");  
20.                         len = is.read(b);  
21.                     }  
22.                     int idx = newStr.indexOf("</PRINTDATA>");  
23.                     newStr = newStr.substring(0, idx+12);  
24.                     //newStr.replaceAll("[?]", "[ ]");  
25.                     System.out.println(newStr);  
26.                     os.flush();  
27.                     os.close();  
28.                     is.close();  
29.                 }