本文以目前最流行的mysql为例，讲解通过tomcat连接池连接mysql数据库的基本步骤，如果你了解mysql可跳过第一步。
在进行tomcat连接池配置前，先解压缩mysql-connector-java-xxx.zip，将其中的mysql-connector-java-3.x.x-xxx.jar取出，置于<%tomcat_home%>\common\lib中。
接下来，让我们一起进入精彩的tomcat配置之旅。
一.新建用户及数据库
操作步骤如下：
c:\documents and settings\administrator>d:
d:\>cd mysql\bin
d:\mysql\bin>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 on jcc.* to jcc@localhost identified by 'jsp.com.cn'
with grant option;
query ok, 0 rows affected (0.01 sec)
mysql> use mysql;
database changed
mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
host user password
+-----------+------+-------------------------------------------+
localhost root *60d5b730382ec2170ca366de181767e4c5343de8
% jsp *c22ab0fd8a289c7d337c9998b63b8ea8335e5f35
localhost jcc *c22ab0fd8a289c7d337c9998b63b8ea8335e5f35
+-----------+------+-------------------------------------------+
3 rows in set (0.01 sec)
mysql> exit
bye
d:\mysql\bin>mysql -u jcc -p
enter password: **********
welcome to the mysql monitor. commands end with ; or \g.
your mysql connection id is 57 to server version: 4.1.12a-nt
type 'help;' or '\h' for help. type '\c' to clear the buffer.
mysql> create database jcc;
query ok, 1 row affected (0.02 sec)
mysql> use jcc;
database changed
mysql> create table user(
-> id int not null auto_increment primary key,
-> name varchar(8) not null
-> );
query ok, 0 rows affected (0.08 sec)
mysql> insert into user (name) values ('corebit');
query ok, 1 row affected (0.03 sec)
mysql> insert into user (name) values ('ivan');
query ok, 1 row affected (0.03 sec)
mysql> select * from user;
+----+---------+
id name
+----+---------+
1 corebit
2 ivan
+----+---------+
2 rows in set (0.00 sec)
mysql>
二.配置tomcat连接池
tomcat5.0进行如下配置：
在<%tomcat_home%>\conf\server.xml的<host>...</host>之间加入以下代码：
<context path="" docbase="d:/jcc"
debug="5" reloadable="true" crosscontext="true">
<logger classname="org.apache.catalina.logger.filelogger"
prefix="localhost_dbtest_log." suffix=".txt"
timestamp="true"/>
<resource name="jdbc/jcc"
auth="container"
type="javax.sql.datasource"/>
<resourceparams name="jdbc/jcc">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.basicdatasourcefactory</value>
</parameter>
<parameter>
<name>maxactive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxidle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxwait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>jcc</value>
</parameter>
<parameter>
<name>password</name>
<value>jsp.com.cn</value>
</parameter>
<parameter>
<name>driverclassname</name>
<value>com.mysql.jdbc.driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/jcc</value>
</parameter>
</resourceparams>
</context>
context path="" docbase="d:/jcc"
debug="5" reloadable="true" crosscontext="true">
<resource name="jdbc/jcc" auth="container" type="javax.sql.datasource"
maxactive="100" maxidle="30" maxwait="10000"
username="jcc" password="jsp.com.cn" driverclassname="com.mysql.jdbc.driver"
url="jdbc:mysql://localhost/jcc"/>
</context>
<%@page contenttype="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="javax.sql.datasource"%>
<%@page import="javax.naming.*"%>
<html>
<body>
<%
try{
context initctx=new 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.println("user-list"+"<br>");
while(rs.next()){
out.print(rs.getstring(1)+" ");
out.print(rs.getstring(2)+"<br>");
}
rs.close();
stmt.close();
conn.close();
}
catch(exception e){
out.print(e);
}
%>
</body>
</html>
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器
