ibatis中 oracle的 clob 类型转换为string
1.在resultmap中加入
<result property="content" column="PRN_TPL_CONTENT" typeHandler="org.springframework.orm.ibatis.support.ClobStringTypeHandler" />
2.使用方法转换
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转成stringsb.append(s);s = br.readLine();}reString = sb.toString();return reString;}