Oracle數(shù)據(jù)庫中有一個(gè)字段是CLOB類型，使用java 解析.

1.使用java解析clob類型內(nèi)容

public String clobToString(Clob c) { StringBuffer sb = new StringBuffer(1024); Reader instream = null; try { instream = c.getCharacterStream(); char[] buffer = new char[(int) c.length()]; int length = 0; while ((length = instream.read(buffer)) != -1) {sb.append(buffer, 0, length); } } catch (Exception ex) { ex.printStackTrace(); return null; } finally { try {if (instream != null) instream.close(); } catch (Exception dx) {instream = null; } } return sb.toString(); }

if(pageObject.getResultList() != null && pageObject.getResultList().size() > 0){ for(int i=0,j=pageObject.getResultList().size(); i < j;i++){Map<String,Object> maps = (Map<String, Object>) pageObject.getResultList().get(i);maps.put('DISPATCHINGRULESNAME',this.clobToString((Clob) maps.get('DISPATCHINGRULESNAME'))); //這里將Clob類型轉(zhuǎn)化成字符串,調(diào)用clobToString((Clob)方法 } }

2.使用oracle函數(shù) to_char(字段)

select to_char(t.billName) as billName from T_CC_SHARE_DISPATCH_RULE t

以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持好吧啦網(wǎng)。