return  "<a href='javascript:show(" + result['ID'] + ")'>"+ data.substring(0,20) +"......</a>";

 

 

 try {  
        option.setCONTENT(UtilTool.ClobToString((oracle.sql.CLOB)rs.getClob("CONTENT")));
        
       } catch (Exception e) {
        e.printStackTrace();
       }

 

 

 

// 将字CLOB转成STRING类型 
 public static String ClobToString(CLOB clob) throws SQLException, IOException {

  String reString = ""; 
  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; 
 }