Tomcat中配置MySQL连接池
1.把驱动拷贝到%TOMCAT_HOME%/common/lib目录下2.新建数据库表，并向表中添加记录
1http://www.blogjava.net/Images/OutliningIndicators/None.gif use test;
2http://www.blogjava.net/Images/OutliningIndicators/None.gif create table testdata (
3http://www.blogjava.net/Images/OutliningIndicators/None.gif id int not null auto_increment primary key,
4http://www.blogjava.net/Images/OutliningIndicators/None.gif foo varchar(25),
5http://www.blogjava.net/Images/OutliningIndicators/None.gif bar int);
6http://www.blogjava.net/Images/OutliningIndicators/None.gifinsert into testdata values(null, 'hello', 12345);
7http://www.blogjava.net/Images/OutliningIndicators/None.gif
3.在%TOMCAT_HOME%/config/server.xml文件中加入如下一段配置信息(在之前)
1http://www.blogjava.net/Images/OutliningIndicators/None.gif
2http://www.blogjava.net/Images/OutliningIndicators/None.gif
3http://www.blogjava.net/Images/OutliningIndicators/None.gif
5http://www.blogjava.net/Images/OutliningIndicators/None.gif
6http://www.blogjava.net/Images/OutliningIndicators/None.gif
10http://www.blogjava.net/Images/OutliningIndicators/None.gif
11http://www.blogjava.net/Images/OutliningIndicators/None.gif
15http://www.blogjava.net/Images/OutliningIndicators/None.gif
16http://www.blogjava.net/Images/OutliningIndicators/None.gif
20http://www.blogjava.net/Images/OutliningIndicators/None.gif
21http://www.blogjava.net/Images/OutliningIndicators/None.gif
22http://www.blogjava.net/Images/OutliningIndicators/None.gif
23http://www.blogjava.net/Images/OutliningIndicators/None.gif
27http://www.blogjava.net/Images/OutliningIndicators/None.gif
28http://www.blogjava.net/Images/OutliningIndicators/None.gif
33http://www.blogjava.net/Images/OutliningIndicators/None.gif
34http://www.blogjava.net/Images/OutliningIndicators/None.gif
38http://www.blogjava.net/Images/OutliningIndicators/None.gif
39http://www.blogjava.net/Images/OutliningIndicators/None.gif
40http://www.blogjava.net/Images/OutliningIndicators/None.gif
41http://www.blogjava.net/Images/OutliningIndicators/None.gif
4.写个简单程序测试下：
1http://www.blogjava.net/Images/OutliningIndicators/None.gif
2http://www.blogjava.net/Images/OutliningIndicators/None.gif
3http://www.blogjava.net/Images/OutliningIndicators/None.gif
4http://www.blogjava.net/Images/OutliningIndicators/None.gif
5http://www.blogjava.net/Images/OutliningIndicators/None.gifselect id, foo, bar from testdata
6http://www.blogjava.net/Images/OutliningIndicators/None.gif
7http://www.blogjava.net/Images/OutliningIndicators/None.gif
8http://www.blogjava.net/Images/OutliningIndicators/None.gif
9http://www.blogjava.net/Images/OutliningIndicators/None.gif
10http://www.blogjava.net/Images/OutliningIndicators/None.gif DB Test
11http://www.blogjava.net/Images/OutliningIndicators/None.gif
12http://www.blogjava.net/Images/OutliningIndicators/None.gif
13http://www.blogjava.net/Images/OutliningIndicators/None.gif
14http://www.blogjava.net/Images/OutliningIndicators/None.gifResults
15http://www.blogjava.net/Images/OutliningIndicators/None.gif
16http://www.blogjava.net/Images/OutliningIndicators/None.gif
17http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif Foo $http://www.blogjava.net/Images/dot.gif{row.foo}
18http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif Bar $http://www.blogjava.net/Images/dot.gif{row.bar}
19http://www.blogjava.net/Images/OutliningIndicators/None.gif
20http://www.blogjava.net/Images/OutliningIndicators/None.gif
21http://www.blogjava.net/Images/OutliningIndicators/None.gif
22http://www.blogjava.net/Images/OutliningIndicators/None.gif
23http://www.blogjava.net/Images/OutliningIndicators/None.gif
页:
[1]