基于SSM 的 Office 在线编辑

Office在线编辑功能在OA系统中经常被使用。本文主要介绍在SSM框架下利用Java整合Office Online Server 2016 （OOS） 进行office 在线编辑。OOS的环境搭建之前文章有过介绍，在这里不进行过多的阐述。具体的代码实现如下：

Java 实现WOPI协议：

package com.officeonline;import java.io.BufferedInputStream;import java.io.BufferedOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.OutputStream;import java.io.PrintWriter;import java.net.URLDecoder;import javax.servlet.FilterChain;import javax.servlet.ServletException;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;import javax.servlet.annotation.WebFilter;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.Filter;import javax.servlet.FilterConfig;/** * Servlet implementation class wopi */@WebFilter("/wopi/*")public class OfficeFilter implements Filter {public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)throws IOException, ServletException {// System.out.println("权限"+request.getParameterValues("power"));HttpServletRequest httpRequest = (HttpServletRequest) request;HttpServletResponse httpResponse = (HttpServletResponse) response;String power = httpRequest.getParameter("power");String uri = httpRequest.getRequestURI(); //获取完整的Url请求路径// 解决中文乱码问题String fileUri = URLDecoder.decode(uri.substring(uri.indexOf("/wopi/") + 1, uri.length()), "UTF-8");String filePath = request.getServletContext().getRealPath("/") + fileUri;if (fileUri.endsWith("/contents")) { // GetFile ：返回文件流filePath = filePath.substring(0, filePath.indexOf("/contents"));String method = httpRequest.getMethod();if (method.equals("GET")) {getFile(filePath, httpResponse);}if (method.equals("POST")) {postFile(filePath, httpRequest);}} else { // CheckFileInfo ：返回jsonresponse.setCharacterEncoding("UTF-8");response.setContentType("application/json;charset=UTF-8");PrintWriter out = null;try {out = response.getWriter();out.write(FileUtils.checkFileInfo(filePath, power));} catch (IOException e) {e.printStackTrace();} finally {if (out != null) {out.close();}}}return;}private HttpServletResponse getFile(String path, HttpServletResponse response) {try {// path是指欲下载的文件的路径。File file = new File(path);// 取得文件名。String filename = file.getName();String contentType = "application/octet-stream";// 以流的形式下载文件。InputStream fis = new BufferedInputStream(new FileInputStream(path));byte[] buffer = new byte[fis.available()];fis.read(buffer);fis.close();// 清空responseresponse.reset();// 设置response的Headerresponse.addHeader("Content-Disposition","attachment;filename=" + new String(filename.getBytes("utf-8"), "ISO-8859-1"));response.addHeader("Content-Length", "" + file.length());OutputStream toClient = new BufferedOutputStream(response.getOutputStream());response.setContentType(contentType);toClient.write(buffer);toClient.flush();toClient.close();} catch (IOException ex) {ex.printStackTrace();}return response;}public static byte[] getRequestPostBytes(HttpServletRequest request) throws IOException {int contentLength = request.getContentLength();if (contentLength < 0) {return null;}byte buffer[] = new byte[contentLength];for (int i = 0; i < contentLength;) {int readlen = request.getInputStream().read(buffer, i, contentLength - i);if (readlen == -1) {break;}i += readlen;}return buffer;}public void postFile(String path, HttpServletRequest request) {// 文件的路径File file = new File(path);try {if (!file.exists()) {file.createNewFile();// 构建文件}String submitMehtod = request.getMethod();if (submitMehtod.equalsIgnoreCase("post")) {byte[] bytes = getRequestPostBytes(request);FileOutputStream fop = new FileOutputStream(file);fop.write(bytes);fop.flush();fop.close();}} catch (IOException e) {e.printStackTrace();}}@Overridepublic void destroy() {// TODO Auto-generated method stub}@Overridepublic void init(FilterConfig arg0) throws ServletException {// TODO Auto-generated method stub}}

OfficeFilter 中引用的FileUtils类：

package com.officeonline;import java.io.File;public class FileUtils {/** * 获取文件基本信息 *  * @param filePath *            文件路径 * @return */public static String checkFileInfo(String filePath, String power) {File file = new File(filePath);// String hash=null;String baseFileName = null; // 文件名String ownerId = null; // 文件所有者的唯一编号long size = 0; // 文件大小，以bytes为单位String sha256 = null; // 文件的256位bit的SHA-2编码散列内容long version = 0; // 文件版本号，文件如果被编辑，版本号也要跟着改变boolean Write = false;boolean Print = true;// 在网页中获取用户是否有权限编辑和打印，根据获取的参数设置office的功能if (power == null) {Write = false;Print = true;} else {if (power.equals("write")) {Write = true;}if (power.equals("print")) {Print = false;}if (power.equals("writeprint") || power.equals("printwrite")) {Write = true;Print = false;}}if (file.exists()) {// 取得文件名。baseFileName = file.getName();size = file.length();// 取得文件的后缀名。ownerId = "admin";version = file.lastModified();sha256 = new Encrypt().SHA256(baseFileName);}return "{\"DisablePrint\":\"" + Print + "\",\"SupportsLocks\":\"" + true + "\",\"Sha256\":\"" + sha256+ "\",\"SupportsUpdate\":\"" + true + "\",\"UserCanWrite\":\"" + Write + "\",\"BaseFileName\":\""+ baseFileName + "\",\"OwnerId\":\"" + ownerId + "\",\"Size\":\"" + size+ "\",\"AllowExternalMarketplace\":\"" + true + "\",\"Version\":\"" + version + "\"}";}}

FileUtils类中的Encrypt类：

package com.officeonline;import java.security.MessageDigest;  import java.security.NoSuchAlgorithmException;    public class Encrypt  {      /**    * 传入文本内容，返回 SHA-256 串    *     * @param strText    * @return    */    public String SHA256(final String strText)    {      return SHA(strText, "SHA-256");    }      /**    * 传入文本内容，返回 SHA-512 串    *     * @param strText    * @return    */    public String SHA512(final String strText)    {      return SHA(strText, "SHA-512");    }      /**    * 字符串 SHA 加密    *     * @param strSourceText    * @return    */    private String SHA(final String strText, final String strType)    {      // 返回值      String strResult = null;        // 是否是有效字符串      if (strText != null && strText.length() > 0)      {        try        {          // SHA 加密开始          // 创建加密对象 并傳入加密類型          MessageDigest messageDigest = MessageDigest.getInstance(strType);          // 传入要加密的字符串          messageDigest.update(strText.getBytes());          // 得到 byte 類型结果          byte byteBuffer[] = messageDigest.digest();            // 將 byte 轉換爲 string          StringBuffer strHexString = new StringBuffer();          // 遍歷 byte buffer          for (int i = 0; i < byteBuffer.length; i++)          {            String hex = Integer.toHexString(0xff & byteBuffer[i]);            if (hex.length() == 1)            {              strHexString.append('0');            }            strHexString.append(hex);          }          // 得到返回結果          strResult = strHexString.toString();        }        catch (NoSuchAlgorithmException e)        {          e.printStackTrace();        }      }        return strResult;    }  }  

controller层实现对word（模板）的复制和对复制后文件的修改：

import java.io.BufferedInputStream;import java.io.BufferedOutputStream;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import util.UrlCode;@Controllerpublic class OfficeController {@RequestMapping(value = "/openmodle.do")@ResponseBodypublic String openmodel(HttpServletRequest request, HttpServletResponse response) throws IOException {String filePath = request.getServletContext().getRealPath("/");FileInputStream fis = new FileInputStream(filePath + "wopi/files/fs/t1.docx");//t1.docx为模板文件FileOutputStream fos = new FileOutputStream(filePath + "wopi/files/fs/t2.docx");//t2.docx为按照末班新建的文件BufferedInputStream bis = new BufferedInputStream(fis);BufferedOutputStream bos = new BufferedOutputStream(fos);int by = 0;byte[] buf = new byte[104857600];//默认上传最大文件为100Mwhile ((by = bis.read(buf)) != -1) {bos.write(buf, 0, by);}fis.close();fos.close();bis.close();bos.close();String Wopisrc=UrlCode.url("http://xx.xx.xx.xx:8080/SmartSchool/wopi/files/fs/t2.docx?power=write");return "http://xx.xx.xx.xx/we/wordeditorframe.aspx?WOPISrc="+Wopisrc;}}

Html页面的实现：

<!DOCTYPE html><html><head><meta charset="UTF-8"><title>Office 在线</title><script type="text/javascript" src="js/jquery.min.js"></script><script type="text/javascript">function openmodle() {filename = prompt("请输入新建文件名:","新建文件");if (filename != null){alert(">>>>>>>>>>>>>>>>>>>>>"+filename+">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>");$.ajax({url : "openmodle.do",data : JSON.stringify(filename),//用户新建文件的文件名传到前台type : "POST",success : function(msg) {console.log("成功");console.log(msg);window.open(msg);},error : function(data, textStatus, errorThrown) {console.log("失败");},});}else{alert("你按了[取消]按钮");}}</script></head><body><a href="#"onclick="openmodle()">通过模板发布文件</a><table><tr><td>Word<td><td><a href="http://xx.xx.xx.xx/wv/wordviewerframe.aspx?WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.docx">预览</a><td><td><a href="http://xx.xx.xx.xx/we/wordeditorframe.aspx?WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.docx%3Fpower%3Dwrite">编辑</a><td></tr><tr><td>Excel<td><td><a href="http://xx.xx.xx.xx/x/_layouts/xlviewerinternal.aspx?WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.xlsx">预览</a><td><td><a href="http://xx.xx.xx.xx/x/_layouts/xlviewerinternal.aspx?edit=1&WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.xlsx%3Fpower%3Dwrite">编辑</a><td></tr><tr><td>Ppt<td><td><a href="http://xx.xx.xx.xx/p/PowerPointFrame.aspx?WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.pptx">预览</a><td><td><a href="http://xx.xx.xx.xx/p/PowerPointFrame.aspx?PowerPointView=EditView&WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.pptx%3Fpower%3Dwrite">编辑</a><td></tr><tr><td>Pdf<td><td><a href="http://xx.xx.xx.xx/wv/wordviewerframe.aspx?PdfMode=1&WOPISrc=http%3A%2F%2Fxx.xx.xx.xx%3A8080%2FSmartSchool%2Fwopi%2Ffiles%2F1.pdf">预览</a><td><td></tr></table></body></html>