spring使用JdbcTemplate 读取clob属性字段

public static List queryListBlob(String sql,JdbcTemplate sjt){
  List list=null;

 list = sjt.query(sql, new RowMapper(){
   public Object mapRow(ResultSet rs, int i) throws SQLException {
           Map results = new HashMap();//存放对像的hashmap
           CLOB clob = null;
           String str = "";
           try {
            T_CASESTUDY bean=new T_CASESTUDY();//表对应的javaBean
            clob = (oracle.sql.CLOB) rs.getClob("content");//content字段属性为clob,转成clob对象
            str = clobToString(clob);将clob对象转为String
            bean.setId(rs.getString("id"));
            bean.setName(rs.getString("name"));
            bean.setWebsite(rs.getString("website"));
            bean.setImgpath(rs.getString("imgpath"));
            bean.setContent(str);
            bean.setCrdt(rs.getDate("crdt"));
            bean.setCrusr(rs.getString("crusr"));
            bean.setOrderid(rs.getInt("orderid"));
            bean.setState(rs.getString("state"));
            results.put(rs.getString("id"),bean);
     } catch (Exception e) {
      logger.error(e.getMessage());
      results.put("content", "");
     }           
           return results;
    }

    //此方法将clob转为String
    public String clobToString(CLOB clob) throws SQLException, IOException {
     String reString = "";
     if( clob == null || clob.getCharacterOutputStream() == null )
      return "";
     Reader is = clob.getCharacterStream();// 得到流
     BufferedReader br = new BufferedReader(is);
     String s = br.readLine();
     StringBuffer sb = new StringBuffer();
     while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING
      sb.append(s);
      s = br.readLine();
     }
     reString = sb.toString();
     return reString;
    }
  });

}