金格科技-iWebOffice2015智能文档中间件示例程序

<%@ page contentType="text/html; charset=gb2312" %> <%@ page import="java.io.*,java.text.*,java.util.*,java.sql.*,java.text.SimpleDateFormat,java.text.DateFormat,java.util.Date,javax.servlet.*,javax.servlet.http.*,DBstep.iDBManager2000.*" %> <%@page import="java.net.URLDecoder"%> <% ResultSet result=null; String mStatus=null; String mAuthor=null; String mFileName=null; String mFileDate=null; String mHTMLPath=""; String mDisabled=""; String mDisabledSave=""; String mWord=""; String mExcel=""; //自动获取OfficeServer和OCX文件完整URL路径 String mHttpUrlName=request.getRequestURI(); String mScriptName=request.getServletPath(); String mServerName="OfficeServer"; String mServerUrl="http://"+request.getServerName()+":"+request.getServerPort()+mHttpUrlName.substring(0,mHttpUrlName.lastIndexOf(mScriptName))+"/"+mServerName;//取得OfficeServer文件的完整URL String mHttpUrl="http://"+request.getServerName()+":"+request.getServerPort()+mHttpUrlName.substring(0,mHttpUrlName.lastIndexOf(mScriptName))+"/"; String mRecordID=request.getParameter("RecordID"); String mTemplate=request.getParameter("Template"); String mFileType=request.getParameter("FileType"); String mEditType=request.getParameter("EditType"); System.out.println(mEditType); String mSubject= ""; String mUserName=URLDecoder.decode( request.getParameter("UserName") ,"utf-8"); // new String(request.getParameter("UserName").getBytes("utf-8")); boolean isNewDocument = false; //设置编号初始值 if (mRecordID==null){ mRecordID=""; } //设置编辑状态初始值 if (mEditType==null || mEditType==""){ mEditType="1"; } //设置文档类型初始值 if (mFileType==null || mFileType==""){ mFileType=".doc"; } //设置用户名初始值 if (mUserName==null || mUserName==""){ mUserName="金格科技"; } //设置模板初始值 if (mTemplate==null){ mTemplate=""; } //打开数据库 DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000(); if (DbaObj.OpenConnection()){ String mSql="Select * From Document Where RecordID='"+ mRecordID + "'"; try{ result=DbaObj.ExecuteQuery(mSql); if (result.next()){ mRecordID=result.getString("RecordID"); mTemplate=result.getString("Template"); mSubject=result.getString("Subject"); mAuthor=result.getString("Author"); mFileDate= DbaObj.getDateString(result.getString("FileDate")); mStatus=result.getString("Status"); mFileType=result.getString("FileType"); mHTMLPath=result.getString("HTMLPath"); isNewDocument = false; } else{ //取得唯一值(mRecordID) java.util.Date dt=new java.util.Date(); long lg=dt.getTime(); Long ld=new Long(lg); //初始化值 mRecordID=ld.toString();//保存的是文档的编号，通过该编号，可以在里找到所有属于这条纪录的文档 mTemplate=mTemplate; mSubject="请输入主题"; mAuthor=mUserName; mFileDate=DbaObj.GetDateTime(); mStatus="DERF"; mFileType=mFileType; mHTMLPath=""; isNewDocument = true; } result.close(); } catch(SQLException e){ System.out.println(e.toString()); } DbaObj.CloseConnection() ; } String mWPS=""; if (mEditType.equalsIgnoreCase("0")){ mDisabled="disabled"; mDisabledSave="disabled"; }else{ if (mFileType.equalsIgnoreCase(".doc") || mFileType.equalsIgnoreCase(".docx")){ mWPS =""; mWord=""; mExcel = "disabled"; }else if(mFileType.equalsIgnoreCase(".wps")){ mWPS ="disabled"; mWord=""; mExcel = "disabled"; } else if (mFileType.equalsIgnoreCase(".xls")||mFileType.equalsIgnoreCase(".xlsx")){ mWord="disabled"; mWPS =""; mExcel = ""; } else{ mDisabled="disabled"; } } mFileName=mRecordID + mFileType; //取得完整的文档名称 %> 金格科技-iWebOffice2015智能文档中间件示例程序