当前位置: 代码迷 >> Web前端 >> 润乾表格web相关配置
  详细解决方案

润乾表格web相关配置

热度:355   发布时间:2012-10-25 10:58:57.0
润乾报表web相关配置

1、<!-- 润乾报表 satrt -->
?<servlet>
??<servlet-name>com.runqian.report.view.DataServlet</servlet-name>
??<servlet-class>com.runqian.report.view.DataServletExt</servlet-class>
??<init-param>
???<param-name>license</param-name>
???<param-value>runqianReportLicenseForWindows.dat</param-value>
??</init-param>
??<init-param>
???<param-name>reportFileHome</param-name>
???<param-value>/runqianReport</param-value>
??</init-param>
??<!-- Tomcat需要加JNDI前缀java:comp/env? Weblogic的JNDI前缀为空 -->
??<init-param>
???<param-name>JNDIPrefix</param-name>
???<param-value>java:comp/env</param-value>
??</init-param>
??<init-param>
???<param-name>dataSource</param-name>
???<!-- 数据源的声明之间用分号分隔 -->
???<param-value>pcmdb,oracle,GBK</param-value>
??</init-param>
??<init-param>
???<param-name>cachedParamsTimeout</param-name>
???<param-value>120</param-value>
??</init-param>
??<init-param>
???<!--? 缓存报表保存时间(分)? -->
???<param-name>cachedReportTimeout</param-name>
???<param-value>120</param-value>
??</init-param>
??<init-param>
???<!--? 报表只缓存到硬盘上,不在内存中保留? -->
???<param-name>cachedToDiskOnly</param-name>
???<param-value>no</param-value>
??</init-param>
??<init-param>
???<!--? 可同时计算的大报表个数? -->
???<param-name>maxConcurrentForBigReport</param-name>
???<param-value>2</param-value>
??</init-param>
??<init-param>
???<!--? 等待计算的大报表个数? -->
???<param-name>maxWaitForBigReport</param-name>
???<param-value>1</param-value>
??</init-param>
??<init-param>
???<!--? 可同时计算的普通报表个数? -->
???<param-name>maxConcurrentForReport</param-name>
???<param-value>9999</param-value>
??</init-param>
??<init-param>
???<!--? 等待计算的普通报表个数? -->
???<param-name>maxWaitForReport</param-name>
???<param-value>9999</param-value>
??</init-param>
??<init-param>
???<param-name>logConfig</param-name>
???<param-value>/WEB-INF/runqianReportLog.properties</param-value>
??</init-param>
??<init-param>
???<param-name>appUrlPrefix</param-name>
???<param-value></param-value>
??</init-param>
??<load-on-startup>2</load-on-startup>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.SetDefaultTagProps</servlet-name>
??<servlet-class>com.runqian.report.view.SetDefaultTagProps</servlet-class>
??<init-param>
???<param-name>printLabel</param-name>
???<param-value>
????<![CDATA[<img src="{appmap}/images/print.gif" border=no>]]>
???</param-value>
??</init-param>
??<init-param>
???<param-name>submit</param-name>
???<param-value>保存数据</param-value>
??</init-param>
??<load-on-startup>10</load-on-startup>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.excel.ExcelReportServlet</servlet-name>
??<servlet-class>com.runqian.report.view.excel.ExcelReportServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.excel.ConfigExcelServlet</servlet-name>
??<servlet-class>com.runqian.report.view.excel.ConfigExcelServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.excel.SaveAsExcelServlet</servlet-name>
??<servlet-class>com.runqian.report.view.excel.SaveAsExcelServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.pdf.PdfReportServlet</servlet-name>
??<servlet-class>com.runqian.report.view.pdf.PdfReportServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.word.WordReportServlet</servlet-name>
??<servlet-class>com.runqian.report.view.word.WordReportServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.control.PostAppletDataServlet</servlet-name>
??<servlet-class>com.runqian.report.control.PostAppletDataServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.control.SaveAsExcelServlet</servlet-name>
??<servlet-class>com.runqian.report.control.SaveAsExcelServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.SetReportParamsServlet</servlet-name>
??<servlet-class>com.runqian.report.view.SetReportParamsServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.html.GraphServlet</servlet-name>
??<servlet-class>com.runqian.report.view.html.GraphServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.html.PrintServlet</servlet-name>
??<servlet-class>com.runqian.report.view.html.PrintServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.base.util.ReadJavaScriptServlet</servlet-name>
??<servlet-class>com.runqian.base.util.ReadJavaScriptServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.SaveDataServlet</servlet-name>
??<servlet-class>com.runqian.report.input.SaveDataServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.SaveToLocalServlet</servlet-name>
??<servlet-class>com.runqian.report.input.SaveToLocalServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.SelectUploadFile</servlet-name>
??<servlet-class>com.runqian.report.input.SelectUploadFile</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.UploadFile2DBServlet</servlet-name>
??<servlet-class>com.runqian.report.input.UploadFile2DBServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.SaveSheetsServlet</servlet-name>
??<servlet-class>com.runqian.report.input.SaveSheetsServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.UploadExcelServlet</servlet-name>
??<servlet-class>com.runqian.report.input.UploadExcelServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.input.SelectExcelFileServlet</servlet-name>
??<servlet-class>com.runqian.report.input.SelectExcelFileServlet</servlet-class>
?</servlet>
?<servlet>
??<servlet-name>com.runqian.report.view.text.TextFileServlet</servlet-name>
??<servlet-class>com.runqian.report.view.text.TextFileServlet</servlet-class>
?</servlet>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.excel.ExcelReportServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.excel.ExcelReportServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.excel.ConfigExcelServlet
??</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.excel.ConfigExcelServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.excel.SaveAsExcelServlet
??</servlet-name>
??<url-pattern>/servlet/SaveAsExcel</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.pdf.PdfReportServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.pdf.PdfReportServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.word.WordReportServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.word.WordReportServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.DataServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.DataServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.SetReportParamsServlet</servlet-name>
??<url-pattern>/setReportParams</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.control.SaveAsExcelServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.control.SaveAsExcelServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.control.PostAppletDataServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.control.PostAppletDataServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.html.GraphServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.html.GraphServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.html.PrintServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.html.PrintServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.base.util.ReadJavaScriptServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.base.util.ReadJavaScriptServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.SaveDataServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.SaveDataServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.SaveToLocalServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.SaveToLocalServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.SelectUploadFile</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.SelectUploadFile</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.UploadFile2DBServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.UploadFile2DBServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.SaveSheetsServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.SaveSheetsServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.UploadExcelServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.UploadExcelServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.input.SelectExcelFileServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.input.SelectExcelFileServlet</url-pattern>
?</servlet-mapping>
?<servlet-mapping>
??<servlet-name>com.runqian.report.view.text.TextFileServlet</servlet-name>
??<url-pattern>/servlet/com.runqian.report.view.text.TextFileServlet</url-pattern>
?</servlet-mapping>
?<!-- 润乾报表 end -->
?
?<!-- taglib -->
?<jsp-config>
???<taglib>
???<taglib-uri>http://www.runqian.com.cn/report</taglib-uri>
???<taglib-location>/WEB-INF/taglib/runqianReport.tld</taglib-location>
??</taglib>
?</jsp-config>

2、tomcat下设置数据源

<Context docBase="E:\work\Workspaces\test\WebRoot" path="/s" reloadable="true">
?????? ?<Resource name="pcmdb" auth="Container" type="javax.sql.DataSource" />
???<ResourceParams name="pcmdb">
????<parameter>
?????<name>username</name>
?????<value>devv2</value>
????</parameter>
????<parameter>
?????<name>password</name>
?????<value>v2</value>
????</parameter>
????<parameter>
?????<name>driverClassName</name>
?????<value>oracle.jdbc.OracleDriver</value>
????</parameter>
????<parameter>
?????<name>url</name>
?????<value>jdbc:oracle:thin:@locahost:1521:pcmdb</value>
????</parameter>
???</ResourceParams>????????
</Context>
  相关解决方案