java Clob 大字段Clob转String

创建Clob对象

Clob clob = (Clob) list.get(0).get("COORDINATE");

Clob转为String方法

public static String clobToString(final Clob clob) {
    String reString = "";
    try (Reader is = clob.getCharacterStream(); BufferedReader br = new BufferedReader(is);) {
        String s = br.readLine();
        final StringBuffer sb = new StringBuffer();
        while (s != null) {
            sb.append(s);
            s = br.readLine();
        }
        reString = sb.toString();
    } catch (final Exception e) {
        e.printStackTrace();
    }
    return reString;
}