- //oracle.sql.Clob类型转换成String类型
- public 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;
- }