Tomcat中配置MySQL连接池

hongblue

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.gif  Results
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