Clob转化String
/**通过jdbc查出clob类型字段
public Object[] qyzfxxView(String qymc,String qyid){
Connection c = null;
PreparedStatement pstmt = null;
ResultSet rset = null;
Object[] obj = new Object[14];
Long id =Long.parseLong(qyid);
String sql="select e.qy_mc,e.fddbr,e.dsr_dwdz,e.xzzfjg,e.rdyj,e.xzcfyj,e.xzcfjd,e.cfje,e.zfrqzsj,e.zfr1,e.qy_cffz,e.wscjsj," +
" e.hzgkf,e.wfms from Process_qyzfxx e where e.qy_mc ='"+qymc+"' and e.id ="+id;
try {
c=SessionFactoryUtils.getDataSource(getSessionFactory()).getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
try {
pstmt=c.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
try {
rset = pstmt.executeQuery();
while (rset.next()) {
for(int i=0;i<13;i++){
obj[i]=rset.getString(i+1);
}
CLOB clob = (CLOB)rset.getClob(14);
obj[13]=Clob2String(clob);
}
} catch (SQLException e) {
e.printStackTrace();
}
return obj;
}
/**
* clob to string
* 大字符串格式转换STRING
* @param clob
* @return 大字符串
*
*/
public String Clob2String(CLOB clob) {// Clob转换成String 的方法
String content = null;
StringBuffer stringBuf = new StringBuffer();
try {
int length = 0;
if(clob!=null){
Reader inStream = clob.getCharacterStream(); // 取得大字侧段对象数据输出流
char[] buffer = new char[50];
while ((length = inStream.read(buffer)) != -1) // 读取数据库 //每50个10个读取
{ for (int i = 0; i < length; i++) {
stringBuf.append(buffer[i]);
}
}
inStream.close();
content = stringBuf.toString();
return content;
}else{
return null;
}
} catch (Exception ex) {
ex.printStackTrace();
return null;
}
}