//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());