润乾报表在Tomcat6.0中的配置

点点博客该篇文章地址:http://zhidanfeng.diandian.com/post/2013-07-10/40050920898

说明:我使用的是Tomcat6.0,润乾报表的版本是3.5,有4.5的,下载地址在最下面。

经过一天的蛋疼配置之后,总结如下:

1. 需要配置的地方好像只有两处:①Tomcat 6.0目录下面的conf文件夹下面的server.xml,在<Host></Host>之间加入如下配置:【网上说Tomcat5.0及其之前的配置不是这样,自己搜一下应该就知道了,相关关键值不变就是方法变了--><value>......</value>这种的】

1
2
3
4
5
6
7
8
9
< Context  path = "/runqian"  docBase = "runqian" >
     < Resource
     name = "JK_DB"
     auth = "Container"
     type = "javax.sql.DataSource"
     username = "JK_DB"
     password = "JK_DB"             driverClassName = "oracle.jdbc.driver.OracleDriver"        url = "jdbc:oracle:thin:@202.101.208.218:1521:JKDB" 
     />  
</ Context >

配置说明:path="/renqian" 是你发布的工程的名称,docBase="runqian"是你的工程在Tomcat中的放置位置,可以写成绝对路径,也可以写成上面这样,默认是在webapp中寻找,

name="JK_DB" 是你在设计器里面配置的数据源名称,username和password之后的配置也是和你在设计器里面配置的数据源一致。顺便说一下,当你在设计器里面配置数据源的时候,在填写url的时候不要加 "/",加了就错了,连不上的。

在网上查找资料的时候说可以在【Catalina/localhost/】目录下面创建一个和工程名称相同的.xml文件,比如我的工程名为runqian,那么你应该创建一个名为runqian.xml的文件,然后配置,但是我试过,貌似没用,最好还是配成我这样吧,别到时候出了错,郁闷的死

②之后在自己工程下面的【/WEB-INF/web.xml】中添加你安装设计器时的例子中的web.xml中的内容,复制进去就可以了:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
<? xml  version = "1.0"  encoding = "UTF-8" ?>
< web-app  version = "2.5"
     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
   < welcome-file-list >
     < welcome-file >index.jsp</ welcome-file >
   </ welcome-file-list >
                             
   < servlet >
     < servlet-name >com.runqian.report.view.DataServlet</ servlet-name >
     < servlet-class >com.runqian.report.view.DataServlet</ servlet-class >
     < init-param >
       < param-name >reportFileHome</ param-name >
       < param-value >/reportFiles</ param-value >
     </ init-param >
     < 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 >JK_DB,oracle,gb2312</ param-value >
     </ init-param >
     < init-param >
       < param-name >cachedParamsTimeout</ param-name >
       < param-value >10</ param-value >
     </ init-param >
     < init-param >
       < param-name >cachedReportSourceTimeout</ param-name >
       < param-value >30</ 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 >certFile</ param-name >
       < param-value >/keystore</ param-value >
     </ init-param >
     < load-on-startup >2</ load-on-startup >
   </ servlet >
                           
   < servlet >
     < servlet-name >com.runqian.report.cache.CachedReportServlet</ servlet-name >
     < servlet-class >com.runqian.report.cache.CachedReportServlet</ servlet-class >
     < init-param >
       < param-name >directory</ param-name >
       < param-value >/cached</ param-value >
     </ init-param >
     < init-param >
       < param-name >cachedTimeout</ param-name >
       < param-value >2</ param-value >
     </ init-param >
     < init-param >
       < param-name >needCacheReports</ param-name >
       < param-value >aaa.raq,bbb.raq</ param-value >
     </ init-param >
     < load-on-startup >2</ 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.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-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.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 >
                           
< jsp-config >
   < taglib >
     < taglib-uri >/WEB-INF/runqianReport.tld</ taglib-uri >
     < taglib-location >/WEB-INF/runqianReport.tld</ taglib-location >
   </ taglib >
   </ jsp-config >
</ web-app >

注意了:这里面的打他Source中的JK_DB和你在上面配置的数据源名称name=".."中的一致,不要配错了。

好了相关的配置就完成了,下面开始复制相关的文件:

第一步:(导包)

将润乾报表中的包导入到自己的web工程中

  1. 、将runqianReportApplet.jar放到自己工程的WebRoot下;

  2. 、将runqianReport.tld,runqianReportLog.properties,xrq_license.dat放到WEB-INF下;

、将润乾报表WEB-INF下的lib目录下的包全部放到自己工程的WEB-INF下的lib目录下,然后将oracle数据库的jdbc驱动包也放到该目录下;

其他文件自己看demo就知道了,就不一一列出来了,这些文件你可以在你安装润乾报表之后给出的例子中找到


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值