配置MySQL数据源在tomcat5中

d:mywebomcat5in;d:mywebjdk1.4;d:myweb 
jdk1.4in; 
d:mywebomcat5commonlibservlet-api.jar;C:Program Files 
MySQL(和PHP搭配之最佳组合)MySQL(和PHP搭配之最佳组合) Server4.1in 
CLASSPATH:d:mywebomcat5commonlibservlet-api.jar;d:myweb 
tomcat(一个很好用的JSP运行平台)5commonlibjsp(SUN企业级应用的首选)-api.jar 
JAVA_HOME:d:mywebjdk1.4 
CATALINA_HOME:d:mywebomcat5 

create database forumdb; 
create table member 
( 
id int, 
name varchar(6) 
); 

insert into member values(1,"zhang"); 
insert into member values(2,"wang"); 

reloadable="true" > 
auth="Container" 
type="javax.sql.DataSource" /> 
 
 
factory 
org.apache(Unix平台最流行的WEB服务器平台).commons.dbcp.BasicDataSourceFactory 
 
 configure your MySQL(和PHP搭配之最佳组合)d max_connections large enough to handle 
 all of your db connections. Set to 0 for no limit. 
 --> 
 
maxActive 
10 
 
 Set to 0 for no limit. 
 --> 
 
maxIdle 
3 
 
 in ms, in this example 10 seconds. An Exception is thrown if 
 this timeout is exceeded.Set to -1 to wait indefinitely. 
Maximum time to wait for a dB connection to become available 
 in ms, in this example 10 seconds. An Exception is thrown if 
 this timeout is exceeded.Set to -1 to wait indefinitely. 
 --> 
 
maxWait 
10000 
 
 
 
 username 
 root 
 
 
 password 
 1234 
 
 
 
 driverClassName 
 com.MySQL(和PHP搭配之最佳组合).jdbc.Driver 
 
 The autoReconnect=true argument to the url makes sure that the 
 mm.MySQL(和PHP搭配之最佳组合) JDBC Driver will automatically reconnect if MySQL(和PHP搭配之最佳组合)d closed the 
 connection.MySQL(和PHP搭配之最佳组合)d by default closes idle connections after 8 hours. 
 --> 
 
url 
jdbc:MySQL(和PHP搭配之最佳组合)://localhost:3306/forumdb?autoReconnect=true 
 
 
 

 
DB Connection 
jdbc/DBConnection 
javax.sql.DataSource 
Container 
 

<%@ page import="java.io.*,java.util.*,java.sql.*,javax.sql.*,javax.naming.*"%> 
<%@ page contentType="text/html;charset=GB2312"%> 
 
 
 
<% 
try{ 
java.sql.Connection con; 
Statement stmt; 
ResultSet rs; 
Context ctx = new InitialContext(); 
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/DBConnection"); 
con=ds.getConnection(); 
stmt=con.createStatement(); 
rs=stmt.executeQuery("select * from member"); 
while(rs.next()){ 
out.print(rs.getInt(1); 
out.print(rs.getString(2)); 
} 
rs.close(); 
stmt.close(); 
con.close(); 
}catch(Exception e){ 
out.print(e.getMessage()); 
} 
%>