//oracle.sql.Clob类型转换成String类型

public static String ClobToString(Clob clob) {

String reString = "";

Reader is = null;

try {

is = clob.getCharacterStream();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

// 得到流

BufferedReader br = new BufferedReader(is);

String s = null;

try {

s = br.readLine();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

StringBuffer sb = new StringBuffer();

while (s != null) {

//执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING

sb.append(s);

try {

s = br.readLine();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

reString = sb.toString();

return reString;

}