Blob,Clob类型转换String
Blob,Clob类型转换String2010-06-13 13:421.写入Blob字段CsOaMail mail = new CsOaMail(from, to, null, null, subject,new Date(), null, "0", sentFolderId);mail.setContent(Hibernate.createBlob(content.getBytes("UTF-8"))); cm = (CsOaMail) emailDAO.save(mail);//保存入库2.BLob to StringcsMail = (CsOaMail) emailDAO.get(CsOaMail.class, id); // 取出邮件信息 // 处理邮件内容信息 BLOB to string Blob blob=csMail.getContent(); InputStream ins = blob.getBinaryStream(); byte[] c = new byte[(int) blob.length()]; ins.read(c); String contentString = new String(c); csMail.setContentString(contentString); ins.close();1.写入Clobmail.setContent(Hibernate.createBlob(content);2.string to Clobjava.sql.Clob c = new javax.sql.rowset.serial.SerialClob("abc".toCharArray());3./*** Clob数据转为String* * @param clob* @return*/public String doClobToString(Clob clob) { if (null == clob) return null; Reader reader = null; StringBuffer sb = new StringBuffer(); BufferedReader bfReader = null; try { reader = clob.getCharacterStream(); // 得到流 bfReader = new BufferedReader(reader); String s = bfReader.readLine(); while (null != s) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING sb.append(s); s = bfReader.readLine(); } } catch (Exception e) { e.getCause(); } finally { try { if (null != reader) reader.close(); if (null != bfReader) bfReader.close(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if (sb.toString().equals("")) return null; else return sb.toString();}
页:
[1]