Oracle数据库中clob字段页面展示

方式一：sql语句处理select DBMS_LOB.SUBSTR(content,4000,1) ||DBMS_LOB.SUBSTR(content,4000,4001) ||DBMS_LOB.SUBSTR(content,4000,8001) ||DBMS_LOB.SUBSTR(content,4000,12001)from xxx;方式二：java转String//oracle.sql.Cl

清水

2563人浏览 · 2021-09-10 22:07:56

清水 · 2021-09-10 22:07:56 发布

方式一：sql语句处理

select DBMS_LOB.SUBSTR(content,4000,1) ||   

       DBMS_LOB.SUBSTR(content,4000,4001) ||   

       DBMS_LOB.SUBSTR(content,4000,8001) ||   

       DBMS_LOB.SUBSTR(content,4000,12001)   

from xxx;

方式二：java转String

//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;
}