java.lang.String和java.util.NClob互相转换
//NClob或Clob转String类型
public String clob2Str(NClob nclob) throws Exception { String content = ""; try { Reader is = nclob.getCharacterStream(); BufferedReader buff = new BufferedReader(is);// 得到流 String line = buff.readLine(); StringBuffer sb = new StringBuffer(); while (line != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING sb.append(line); line = buff.readLine(); } content = sb.toString(); } catch (Exception e) { log.error("java.sql.NClob类型转java.lang.String类型出错..."+e.getCause()); e.printStackTrace(); } return content; }
/** * String转Clob类型 */ String s="字符串"; Clob clob=new javax.sql.rowset.serial.SerialClob(s.toCharArray());