本文以目前最流行MySQL为例讲解通过Tomcat连接池连接MySQL数据库基本步骤如果你了解MySQL可跳过第步

　　在进行Tomcat连接池配置前先解压缩mysql-connector-java-xxx.zip将其中mysql-connector-java-3.x.x-xxx.jar取出置于<%TOMCAT_HOME%>commonlib中

　　接下来让我们起进入精彩Tomcat配置的旅

.新建用户及数据库

操作步骤如下:

C:Documents and SettingsAdministrator>d:

D:>cd mysqlin

D:MySQLin>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 51 to server version: 4.1.12a-nt

Type \'help;\' or \'h\' for help. Type \'c\' to clear the buffer.

mysql> GRANT ALL PRIVILEGES _disibledevent=> debug=\"5\" reloadable=\"true\" crossContext=\"true\">

Name=\"org.apache.catalina.logger.FileLogger\"
prefix=\"localhost_DBTest_log.\" suffix=\".txt\"
timestamp=\"true\"/>

auth=\"Container\"
type=\"javax.sql.DataSource\"/>


factory
org.apache.commons.dbcp.BasicDataSourceFactory
</parameter>


maxActive
100
</parameter>


maxIdle
30
</parameter>


maxWait
10000
</parameter>


username
jcc
</parameter>

password
jsp.com.cn
</parameter>


driverClassName
com.mysql.jdbc.Driver
</parameter>


url
jdbc:mysql://localhost/jcc
</parameter>
</ResourceParams>
</Context>

Tomcat5.5进行如下配置:

在<%TOMCAT_HOME%>confserver.xml...</Host>的间加入以下代码:

debug=\"5\" reloadable=\"true\" crossContext=\"true\">

maxActive=\"100\" maxIdle=\"30\" maxWait=\"10000\"
username=\"jcc\" password=\"jsp.com.cn\" driverClassName=\"com.mysql.jdbc.Driver\"
url=\"jdbc:mysql://localhost/jcc\"/>

</Context>

3.在<%wwwroot%>/下新建MySQL数据库连接文件Select.jsp

　　Select.jsp源码如下:

<%@page contentType=\"text/html;char=gb2312\"%>
<%@page import=\"java.sql.*\"%>
<%@page import=\"javax.sql.DataSource\"%>


<%@page import=\"javax.naming.*\"%>


<%
try{
Context initCtx= InitialContext;
DataSource db = (DataSource)initCtx.lookup(\"java:comp/env/jdbc/JCC\");
Connection conn = db.getConnection;
Statement stmt = conn.createStatement;
ResultSet rs = stmt.executeQuery(\"SELECT * FROM user\");
out.prln(\"User-list\"+\"
\");
while(rs.next){
out.pr(rs.getString(1)+\" \");
out.pr(rs.getString(2)+\"
\");
}
rs.close;
stmt.close;
conn.close;
}
catch(Exception e){
out.pr(e);
}
%>
</body>
</html>

4.运行http://localhost/Select.jsp显示结果如下:

User-list
1 Corebit
2 Ivan

　　则表示数据库连接成功！恭喜！恭喜！

　　否则请检查数据库连接器版本出错可能性比较高！

　　＊注:

　　Tomcat连接池中部分参数介绍说明如下:

　　maxActive=\"100\"