blob、clob字段小结（五）

最后一个问题就是更新了，对于blob没什么好讲的，但是clob倒是有点需要注意的，问题是这样的，如果clob原来插入的数据内容为： 123456789，现在你update为：ABC，等你查看数据库的插入结果时你会发现更新后的数据其实是：ABC456789，相信你已经知道原因了，那么看看以下的具体处理方法吧：

            int k = 0;
            for (int i=9; i >=0; i--) {
                // 选择并锁定该记录
                LargeObject large = (LargeObject)session.load(LargeObject.class, k+"", LockMode.UPGRADE);
                large.setName("第" + k + "个改动");

                // 插入图片数据
                String fileName = "E:/AAA/" + i + ".jpg";
                SerializableBlob sb = (SerializableBlob)large.getImage();
                java.sql.Blob wrapBlob = sb.getWrappedBlob();
                // 通过非weblogic容器中数据源获得连接的情况
                if(wrapBlob instanceof oracle.sql.BLOB){
                    oracle.sql.BLOB blob = (oracle.sql.BLOB) wrapBlob;
                    OutputStream out = blob.getBinaryOutputStream();
                    out.write(getData(fileName));
                    out.close();
                }
                // 使用weblogic的Oracle Thin driver类型连接池，驱动类名：oracle.jdbc.OracleDriver
                else if(wrapBlob instanceof weblogic.jdbc.vendor.oracle.OracleThinBlob){
                    OracleThinBlob blob = (OracleThinBlob)wrapBlob;
                    OutputStream out = blob.getBinaryOutputStream();
                    out.write(getData(fileName));
                    out.close();
                }


                // 插入文章数据
                fileName = "E:/AAA/" + i + ".java";
                SerializableClob cb = (SerializableClob)large.getArticle();
                java.sql.Clob wrapClob = cb.getWrappedClob();
                System.out.println(wrapClob.getClass());

                //调用存储过程截断Clob字段内容
                System.out.println("准备截断长度：" + wrapClob.length());
                Connection conn = session.connection();
                CallableStatement cstmt = conn.prepareCall("{call dbms_lob.trim(?,?)}");
                cstmt.setClob(1, wrapClob);
                cstmt.setLong(2, 0);
                cstmt.execute();
                cstmt.close();

                // 通过非weblogic容器中数据源获得连接的情况
                if(wrapClob instanceof oracle.sql.CLOB){
                    oracle.sql.CLOB clob = (oracle.sql.CLOB) wrapClob;
                    Writer writer = clob.getCharacterOutputStream();
                    String article = new String(getData(fileName));
                    writer.write(article);
                    writer.close();
                }
                // 使用weblogic的Oracle Thin driver类型连接池，驱动类名：oracle.jdbc.OracleDriver
                else if(wrapClob instanceof weblogic.jdbc.vendor.oracle.OracleThinClob){
                    OracleThinClob clob = (OracleThinClob)wrapClob;
                    Writer writer = clob.getCharacterOutputStream();
                    String article = new String(getData(fileName));
                    writer.write(article);
                    writer.close();
                }
                k++;
            }