如果Oracle中varchar2长度不够用的话,就是用CLOB类型字段。
接口中Java处理CLOB类型字段的方式:
//Clob类型 转String
public String ClobToString(Clob clob) throws Exception {
String ret = "";
Reader read= clob.getCharacterStream();
BufferedReader br = new BufferedReader(read);
String s = br.readLine();
StringBuffer sb = new StringBuffer();
while (s != null) {
sb.append(s);
s = br.readLine();
}
ret = sb.toString();
if(br != null){
br.close();
}
if(read != null){
read.close();
}
return ret;
}