oracle clob字段处理

Connection conn = session.connection();
   ResultSet rs = null;
   PreparedStatement ps = null;
   sql.append("SELECT PACKINFO.OTHERS_REQ  REQTEXT ");
   sql.append("FROM MTG_CUST_PACK_INFO PACKINFO ");
   sql.append("WHERE PACKINFO.INST_TYPE='PKG' ");
   sql.append("AND PACKINFO.PKEY= :packPtr ");
   ps = conn.prepareStatement(sql.toString());
   ps.setString(1,packPtr);
   rs = ps.executeQuery();
   Clob clob = null;
   String reqText = "";
   if(rs.next()){
    clob = (oracle.sql.CLOB) rs.getClob("REQTEXT"); // 获得CLOB字段信息
    reqText = resolveClob(clob);
   }
   ps.close();
   conn.close();

 

 public String resolveClob(Clob clob) {
  String str = "";
  try{
   if(clob!=null){
    Reader is = clob.getCharacterStream();// 得到流
    BufferedReader br = new BufferedReader(is);
    String s = br.readLine();
    StringBuffer sb = new StringBuffer();
    while (s != null) {//
     sb.append(s);
     s = br.readLine();
    }
    str = sb.toString();
   }
  }catch(Exception e){
   e.printStackTrace();
  }
  return str;
 }