Blob,Clob类型转换String

houlei0505

Blob,Clob类型转换String2010-06-13 13:421.写入Blob字段CsOaMail mail = new CsOaMail(from, to[0], 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();}