oracle中查询出的clob字段转化为string

来源:互联网 发布:jenkins 卸载 windows 编辑:程序博客网 时间:2024/03/28 18:59

oracle中查询出的clob字段转化为string:

 

/** *oracle.sql.Clob类型转换成String类型 */public String ClobToString(Clob clob) throws SQLException, IOException { String reString = ""; Reader is = clob.getCharacterStream();// 得到流 BufferedReader br = new BufferedReader(is); String s = br.readLine(); StringBuffer sb = new StringBuffer(); while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING  sb.append(s);  s = br.readLine(); } reString = sb.toString(); return reString;}


 

原创粉丝点击