- //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;
- }
转载于:https://blog.51cto.com/dreamboy/1154877
本文介绍了一种使用Oracle SQL将Clob类型转换为String类型的实用方法,包括获取字符流、读取并拼接字符串的过程。
2486

被折叠的 条评论
为什么被折叠?



