oracle中添加、读取clob大对象

Posted on 2009-07-04 15:04  saibei101  阅读(257)  评论(0)    收藏  举报

读取CLob:

         Clob clob = rs.getClob("news_content");
         String  content=clob.getSubString((long)1,(int)clob.length());

将string类型存入CLob:

         PreparedStatement pstmt=conn.prepareStatement(sql);         

         String content=news.getNewsContent();
         java.io.Reader  clobReader  =  new  java.io.StringReader(content);  
         pstmt.setCharacterStream(5,  clobReader,  content.length());

       

博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3