tomcat 5.5 tomcat6.0配置连接池

huazhi

本文章是针对mysql数据库的,如果更换其他数据库,可以修改相应的
url,username,password,driverClassName.
1.
在tomcat5.5中,需要修改server.xml,在<Host></Host>之间加入如下代码:

<Context path="/test_pool"  debug="0" reloadable="true" crossContext="true">   
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_quality_log." suffix=".txt" timestamp="true"/>   
<Resource   
name="jdbc/connectDB"           
type="javax.sql.DataSource"   
password="root"      
driverClassName="com.mysql.jdbc.Driver"  
maxIdle="2"   
maxWait="5000"   
username="root"  
url="jdbc:mysql://localhost:3306/limits"   
maxActive="4" />        
<ResourceParams name="jdbc/test">   
<parameter>   
<name>removeAbandoned</name>   
<!-- Abandoned DB connections are removed and recycled -->   
<value>true</value>   
</parameter>   
<parameter>   
<name>removeAbandonedTimeout</name>   
<!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned.  -->   
<value>60</value>   
</parameter>   
<parameter>   
<name>logAbandoned</name>   
<!-- Log a stack trace of the code which abandoned -->   
<value>false</value>   
</parameter>   
<parameter>   
<name>factory</name>   
<!--DBCP Basic Datasource Factory -->   
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>   
</parameter>   
</ResourceParams>
</Context>

然后将mysql-connector-java.jar复制到tomcat5.5目录 /common/lib中
重启tomcat即可.
2.tomcat6.0 在tomcat6.0中貌似不能使用<ResourceParams>的形式,我尝试了一下,总是失败,如果说的不对,还请大家指正.
也是在server.xml中修改  
在<Host></Host>标签之间加入如下代码:
<Context   path="/test_pool"     reloadable="true"   crossContext="true">
<Resource
name="jdbc/connectDB"
type="javax.sql.DataSource"
password="root"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="5"
maxWait="5000"
removeAbandoned="true"
username="root"
url="jdbc:mysql://localhost:3306/limits"
maxActive="10"/>
</Context>   


注:path="/test_pool"是要访问的工程名
name="jdbc/connectDB"是要访问的jndi名.
3.然后就可以测试了.
写如下的DBUtil类:

import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class DBUtil {
static Connection conn;
public static Connection getConnection(){
Context ctx = null;
Connection conn = null;
try {
ctx = new InitialContext();
if(ctx == null){
throw new Exception("没有匹配的数据库环境.");
}
System.out.println("*******************************");
System.out.println(ctx);
//DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/connectDB");
System.out.println("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^");
ctx = (Context)ctx.lookup("java:/comp/env");
DataSource ds = (DataSource)ctx.lookup("jdbc/connectDB");
if(ds == null){
throw new Exception("没有合适的数据源");
}
System.out.println(ds);
conn = ds.getConnection();
System.out.println(conn == null);
if(conn == null){
throw new Exception("创建连接失败");
}
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
}


当然,这个类只是用来测试的,可能写的不是很完善.
然后在jsp页面上调用:

Connection conn = DBUtil.getConnection();
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
PreparedStatement pstmt = conn.prepareStatement(" insert into users(userId,userName , password , email) values (" +
"? , ? , ? , ? )");
pstmt.setString(1, "jackeysion");
pstmt.setString(2,"张杰");
pstmt.setString(3, "19871223");
pstmt.setString(4, "jackeysion@126.com");
int i = pstmt.executeUpdate();
conn.commit();
ResultSet rs = stmt.executeQuery("select * from users");
pstmt.close();
while(rs.next()){
out.println(rs.getString(3) + "<br>");
}
conn.close();
//if(i == 0){
//throw new Exception("操作数据错误!!!");
//}

上面是jsp页面中嵌入的代码.
另外 ,本人数据库名叫limits, 里面用到了个表叫users.
users中有这么几个字段: id(主键,自动增长),userId(varchar(50)),userName(varchar(500)),password(varchar(50)) , email(varchar(50),address(varchar(500)等.
测试的时候可以自己做一下.

附件中是mysql连接数据库的驱动包.