Config Tomcat 数据库连接池 for Mysql

[Setup Mysql JDBC driver]
1.copy mysql-connector-java-3.0.15-ga-bin.jar复制到%TOMCAT_HOME%\common\lib

 

[Config Tomcat 数据库连接池 for Mysql]
1.create Mysql DB:study
2.create Mysql user:test password:test
3.，进入tomcat页，用tomcat的Tomcat Administration--->Resources--->Data Sources页面添加，参数如下：
 Name: jdbc/mysql
 Data Source URL: jdbc:mysql://localhost:3306/flea?autoReconnect=true&useUnicode=true&characterEncoding=GBK
 JDBC Driver Class: com.mysql.jdbc.Driver
 ser Name:test
 Password:test
 Max. Active Connections:4
 Max. Idle Connections:2
 Max. Wait for Connection:5000
 Validation Query ：//不添