将clob数据类型转化为String类型（在json字符串赋值时候）

最新推荐文章于 2024-01-04 15:42:11 发布

wqbala

最新推荐文章于 2024-01-04 15:42:11 发布

阅读量5k

点赞数

 1 public  String ClobToString(Clob clob) throws SQLException, IOException { 
 2 
 3         String reString = ""; 
 4         Reader is = clob.getCharacterStream();// 得到流 
 5         BufferedReader br = new BufferedReader(is); 
 6         String s = br.readLine(); 
 7         StringBuffer sb = new StringBuffer(); 
 8         while (s != null) {// 执行循环将字符串全部取出付值给 StringBuffer由StringBuffer转成STRING 
 9         sb.append(s); 
10         s = br.readLine(); 
11         } 
12         reString = sb.toString(); 
13         return reString; 
14         }
15     
16 }