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转成string
			sb.append(s);
			s = br.readLine();
		}
		reString = sb.toString();
		return reString;
	}