oracle.sql.Clob類型轉換成String類型

標籤：

方法一：

public String ClobToString(Clob clob) throws SQLException, IOException {    String reString = "";    Reader is = clob.getCharacterStream();// 得到流    BufferedReader br = new BufferedReader(is);    String s = br.readLine();    StringBuffer sb = new StringBuffer();    while (s != null) {// 執行迴圈將字串全部取出付值給StringBuffer由StringBuffer轉成STRING        sb.append(s);        s = br.readLine();    }    reString = sb.toString();    return reString;}

方法二：

/** * Oracle的Clob轉成String * @param clob * @return */public String oracleClobToString(CLOB clob){    try {        return (clob == null ? null : clob.getSubString(1, (int)clob.length()));    } catch (SQLException e) {        e.printStackTrace();    }    return null;}

 

oracle.sql.Clob類型轉換成String類型