浏览 1497 次
锁定老帖子 主题:JSPWiki 支持附件文件内容搜索
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
|
|
---|---|
作者 | 正文 |
发表时间:2012-09-08
最近项目组要搭一个wiki,经过筛选我们决定使用JSPWiki(网上有大量的分析),待搭完以后,发现他不支持附件文件内容搜索,也就是说,如果这篇wiki中上传了一些doc,xls等文件是不能被搜索到的,但是在jspwiki.properties配置中有如下配置:
jspwiki.searchProvider =LuceneSearchProvider jspwiki.lucene.analyzer = org.apache.lucene.analysis.standard.StandardAnalyzer
也就是JSPWiki也是用lucene来做检索的,于是下了他的源码,看了下这个类com.ecyrd.jspwiki.search.LuceneSearchProvider,发现了如下方法:
protected String getAttachmentContent( Attachment att ) { AttachmentManager mgr = m_engine.getAttachmentManager(); //FIXME: Add attachment plugin structure String filename = att.getFileName(); if(filename.endsWith(".txt") || filename.endsWith(".xml") || filename.endsWith(".ini") || filename.endsWith(".html")) { InputStream attStream; try { attStream = mgr.getAttachmentStream( att ); StringWriter sout = new StringWriter(); FileUtil.copyContents( new InputStreamReader(attStream), sout ); attStream.close(); sout.close(); return sout.toString(); } catch (ProviderException e) { log.error("Attachment cannot be loaded", e); return null; } catch (IOException e) { log.error("Attachment cannot be loaded", e); return null; } } ......
就是说支持文本文件附件(txt,xml,ini,html)的内容搜索,试了一下,上传了一个txt文件,果然是可以被查出来,。
于是决定给这个类动动手术,添加点功能让它可以支持doc和xls, 添加了如下代码在下面(office 2003到2007,文件格式不同,分开来写了),然后重新打包(打好的jar,我放在附件里),启动JSPWiki, 实验了一下,word 和 excel的文件可以被查出来了。
注意的是,这个类的作用是,在附件文件上传,用lucene建立了索引,所以实验的话,一定要重新上传文件,在改这个class之前上传的文件时没有用的。
...... else if(filename.endsWith(".doc")){ InputStream attStream = null; try { attStream = mgr.getAttachmentStream(att); WordExtractor extractor = new WordExtractor(attStream); String s = extractor.getText(); log.debug("Extracted text: " + s + " from attachment: " + filename); return s; } catch (Exception e) { log.error("Attachment cannot be loaded", e); return null; } finally { if(attStream != null){ try { attStream.close(); } catch (IOException e) { log.warn("Couldn't close attachment stream for " + filename, e); } } } } else if(filename.endsWith(".docx")){ InputStream attStream = null; try { attStream = mgr.getAttachmentStream(att); XWPFWordExtractor extractor = new XWPFWordExtractor(new XWPFDocument(attStream)); String s = extractor.getText(); log.debug("Extracted text: " + s + " from attachment: " + filename); return s; } catch (Exception e) { log.error("Attachment cannot be loaded", e); return null; } finally { if(attStream != null){ try { attStream.close(); } catch (IOException e) { log.warn("Couldn't close attachment stream for " + filename, e); } } } } else if(filename.endsWith(".xls")){ InputStream attStream = null; try { attStream = mgr.getAttachmentStream(att); HSSFWorkbook workbook=new HSSFWorkbook(attStream); HSSFSheet sheet=null; StringBuffer sb = new StringBuffer(); for(int i = 0; i < workbook.getNumberOfSheets(); i++) { sheet=workbook.getSheetAt(i); if(sheet == null){ continue; } for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) { HSSFRow row=sheet.getRow(j); if(row == null){ continue; } for (int k = 0; k < row.getLastCellNum(); k++) { sb.append(row.getCell(k)); sb.append(" "); } } } String s = sb.toString(); log.debug("Extracted text: " + s + " from attachment: " + filename); return s; } catch (Exception e) { log.error("Attachment cannot be loaded", e); return null; } finally { if(attStream != null){ try { attStream.close(); } catch (IOException e) { log.warn("Couldn't close attachment stream for " + filename, e); } } } } else if(filename.endsWith(".xlsx")){ InputStream attStream = null; try { attStream = mgr.getAttachmentStream(att); XSSFWorkbook workbook = new XSSFWorkbook(attStream); XSSFSheet sheet=null; StringBuffer sb = new StringBuffer(); for(int i = 0; i < workbook.getNumberOfSheets(); i++) { sheet = workbook.getSheetAt(i); if(sheet == null){ continue; } for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) { XSSFRow row=sheet.getRow(j); if(row == null){ continue; } for (int k = 0; k < row.getLastCellNum(); k++) { sb.append(row.getCell(k)); sb.append(" "); } } } String s = sb.toString(); log.debug("Extracted text: " + s + " from attachment: " + filename); return s; } catch (Exception e) { log.error("Attachment cannot be loaded", e); return null; } finally { if(attStream != null){ try { attStream.close(); } catch (IOException e) { log.warn("Couldn't close attachment stream for " + filename, e); } } } } ......
声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |