Clob类型与String类型的相互转换

// Clob类型转换成String类型
public String ClobToString(final Clob clob) {

if (clob == null) {
return null;
}

Reader is = null;
try {
is = clob.getCharacterStream();
} catch (Exception e) {
e.printStackTrace();
}
BufferedReader br = new BufferedReader(is);

String str = null;
try {
str = br.readLine();    // 读取第一行
} catch (Exception e) {
e.printStackTrace();
}

StringBuffer sb = new StringBuffer();
while (str != null) {    // 如果没有到达流的末尾，则继续读取下一行
sb.append(str);
try {
str = br.readLine();
} catch (Exception e) {
e.printStackTrace();
}
}

String returnString = sb.toString();

return returnString;
}

// String类型转换成Clob类型
public Clob StringToClob(final String string) {

if(null == string || string.trim().length() == 0){
return null;
}
return new org.hibernate.lob.ClobImpl(string);
}