oracle使用java操作clob类型的字段

插入

public static void insert(String id, String name,String clob_content) {
        Writer outStream = null;
        // 通过JDBC获得数据库连接
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection(
                            "jdbc:oracle:thin:192.168.50.18/test",
                            "root", "123456");
            con.setAutoCommit(false);
            Statement st = con.createStatement();
            // 插入一个空对象empty_clob()，这个是必须的
            // insert into EMS_CUST_JS(cust_code, js_name,
            // js_content)values('','', empty_clob())
            st.executeUpdate("insert into text(id, name, clob_content)values"
                            + "('"+ id + "','" + name + "', empty_clob())");
            // 锁定数据行进行更新，注意“for update”语句,这里不用for update锁定不可以插入clob
            ResultSet rs = st.executeQuery("select clob_content from text where id='"+ id+ 
                            "' and name='"+ name+ 
                            "' for update");
            if (rs.next()) {
                // 得到java.sql.Clob对象后强制转换为oracle.sql.CLOB
                oracle.sql.CLOB clob = (oracle.sql.CLOB) rs.getClob("clob_content");
                outStream = clob.getCharacterOutputStream();
                // clob_content是传入的字符串
                char[] c = clob_content.toCharArray();
                outStream.write(c, 0, c.length);
            }
            outStream.flush();
            outStream.close();
            con.commit();
            con.close();
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

读取

public static String read() throws Exception {
        String data = null;
        Reader inStream = null;
        // 获得数据库连接
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection con = DriverManager.getConnection(
                        "jdbc:oracle:thin:192.168.50.18/test",
                        "root", "123456");
        con.setAutoCommit(false);
        Statement st = con.createStatement();
        // 不需要“for update”
        ResultSet rs = st.executeQuery("select CLOB_CONTENT from TEXT where ID=1");
        if (rs.next()) {
            java.sql.Clob clob = rs.getClob("CLOB_CONTENT");
            inStream = clob.getCharacterStream();
            char[] c = new char[(int) clob.length()];
            inStream.read(c);
            // data是读出并需要返回的数据，类型是String
            data = new String(c);
            inStream.close();
        }
        inStream.close();
        con.commit();
        con.close();

        return data;
    }