处理blob和clob的通用类

1. public class LobUtil {
3.     private static final int BUFFER_SIZE = 4096;
5.     private LobUtil() {
6.     }
8.     public static synchronized void writeBLOB(ResultSet rs, String fieldName,
9.             byte[] buf) throws SQLException, IOException {
10.         if (buf == null) {
11.             return;
12.         }
13.         OutputStream os = null;
14.         Blob b = rs.getBlob(fieldName);
15.         if (b == null) {
16.             throw new SQLException("刚刚插入或更新的BLOB指针为空！");
17.         } else {
18.             // if (Conn.isUseConnectionPool()){
19.             // os =
20.             // ((weblogic.jdbc.vendor.oracle.OracleThinBlob)b).getBinaryOutputStream();
21.             // }
22.             // else{
23.             // os = ((oracle.sql.BLOB)b).getBinaryOutputStream();
24.             // }
25.             /**
26.              * @todo 需要最终改造为通用数据库处理接口
27.              */
28.             // <modify author="jdyao" time="2005-07-26">
29.             try {
30.                 Method methodToInvoke = b.getClass().getMethod(
31.                         "getBinaryOutputStream", (Class[]) null);
32.                 os = (OutputStream) methodToInvoke.invoke(b, (Object[]) null);
33.             } catch (Exception e) {
34.                 throw new SQLException(e.getMessage());
35.             }
36.             // os = ( (oracle.sql.BLOB) b).getBinaryOutputStream();
37.             // </modify>
39.             BufferedOutputStream bos = new BufferedOutputStream(os);
40.             bos.write(buf);
41.             bos.flush();
42.             bos.close();
43.         }
44.     }
46.     public static synchronized void writeBLOB(ResultSet rs, String fieldName,
47.             InputStream in) throws SQLException, IOException {
48.         if (in == null) {
49.             return;
50.         }
51.         OutputStream os = null;
52.         Blob b = rs.getBlob(fieldName);
53.         if (b == null) {
54.             throw new SQLException("刚刚插入或更新的BLOB指针为空！");
55.         } else {
56.             // if (Conn.isUseConnectionPool()){
57.             // os =
58.             // ((weblogic.jdbc.vendor.oracle.OracleThinBlob)b).getBinaryOutputStream();
59.             // }
60.             // else{
61.             // os = ((oracle.sql.BLOB)b).getBinaryOutputStream();
62.             // }
63.             // <modify author="jdyao" time="2005-07-26">
64.             try {
65.                 Method methodToInvoke = b.getClass().getMethod(
66.                         "getBinaryOutputStream", (Class[]) null);
67.                 os = (OutputStream) methodToInvoke.invoke(b, (Object[]) null);
68.             } catch (Exception e) {
69.                 throw new SQLException(e.getMessage());
70.             }
71.             // os = ( (oracle.sql.BLOB) b).getBinaryOutputStream();
72.             // </modify>
74.             BufferedOutputStream bos = new BufferedOutputStream(os);
75.             BufferedInputStream bis = new BufferedInputStream(in);
76.             byte buf[] = new byte[BUFFER_SIZE];
77.             int len = -1;
78.             while ((len = bis.read(buf)) != -1) {
79.                 bos.write(buf, 0, len);
80.             }
81.             bis.close();
82.             bos.flush();
83.             bos.close();
84.         }
85.     }
87.     public static synchronized void writeCLOB(ResultSet rs, String fieldName,
88.             String buf) throws SQLException, IOException {
90.         if (buf == null) {
91.             return;
92.         }
93.         Writer wr = null;
94.         Clob c = rs.getClob(fieldName);
95.         if (c == null) {
96.             throw new SQLException("刚刚插入或更新的CLOB指针为空！");
97.         } else {
98.             // <modify author="jdyao" time="2005-07-26">
99.             try {
100.                 Method methodToInvoke = c.getClass().getMethod(
101.                         "getCharacterOutputStream", (Class[]) null);
102.                 wr = (Writer) methodToInvoke.invoke(c, (Object[]) null);
103.             } catch (Exception e) {
104.                 throw new SQLException(e.getMessage());
105.             }
106.             // wr = ((oracle.sql.CLOB) c).getCharacterOutputStream();
107.             // </modify>
108.             BufferedWriter bw = new BufferedWriter(wr);
109.             bw.write(buf);
110.             bw.flush();
111.             bw.close();
112.         }
113.     }
115.     public static synchronized void writeCLOB(ResultSet rs, String fieldName,
116.             InputStream in) throws SQLException, IOException {
118.         if (in == null) {
119.             return;
120.         }
121.         Writer wr = null;
122.         Clob c = rs.getClob(fieldName);
123.         if (c == null) {
124.             throw new SQLException("刚刚插入或更新的CLOB指针为空！");
125.         } else {
126.             //<modify author="jdyao" time="2005-07-26">
127.             try {
128.               Method methodToInvoke = c.getClass().getMethod(
129.                   "getCharacterOutputStream", (Class[]) null);
130.               wr = (Writer) methodToInvoke.invoke(c, (Object[]) null);
131.             } catch (Exception e) {
132.               throw new SQLException(e.getMessage());
133.             }
134.             //wr = ((oracle.sql.CLOB) c).getCharacterOutputStream();
135.             //</modify>
136.             
137.             BufferedWriter bw = new BufferedWriter(wr);
138.             BufferedReader br = new BufferedReader(new InputStreamReader(in));
139.             char buf[] = new char[BUFFER_SIZE];
140.             int len = -1;
141.             while ( (len = br.read(buf)) != -1) {
142.               bw.write(buf, 0, len);
143.             }
144.             br.close();
145.             bw.flush();
146.             bw.close();
147.         }
148.     }
149. }