Tomcat中的配置DBCP

woxio770

　　一 首先我们在Tomcat中容器中引入相应的jdbc
　　首先我们应该拥有这个jdbc,如果找不到,就去相应的官网download.

　　mysql-connector-java-3.1.13-bin.jar
　　将上面的这个jdbc copy到tomcat/lib中去
　　

　　二 修改tomcat/conf中server.xml
　　在server.xml中的<GlobalNamingResources>里面配置相应的数据库信息
　　

　　server.xml：

　　<GlobalNamingResources>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users
-->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />

<!-- maxActive: Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->

<!-- maxIdle: Maximum number of idle dB connections to retain in pool.
Set to -1 for no limit. See also the DBCP documentation on this
and the minEvictableIdleTimeMillis configuration parameter.
-->

<!-- maxWait: 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.
-->

<!-- username and password: MySQL dB username and password for dB connections -->

<!-- driverClassName: Class name for the old mm.mysql JDBC driver is
org.gjt.mm.mysql.Driver - we recommend using Connector/J though.
Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.
-->

<!-- url: The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->

<Resource name="jdbc/test" auth="Container" type="javax.sql.DataSource"
maxActive="20" maxIdle="10" maxWait="50"
username="root" password="root" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/softrc"/>

</GlobalNamingResources>
　　

　　三 配置tomcat中的context.xml
　　在context.xml中的<Context>里面配置下面的信息
　　

　　context.xml：
　　
<Context>
<ResourceLink global="jdbc/test" name="jdbc/test" type="javax.sql.DataSource" />
</Context>
　　

　　四 写个类测试下
　　package com.shaoguan.test;

import java.sql.Connection;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DBCPConn {
public static Connection getConn() throws Exception{
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/test");
return ds.getConnection();  
}
}
　　

　　五 在jsp中显示写数据来看看数据

　　这里我测试的jsp名称为：testdbcp.jsp
　　

　　testdbcp.jsp:

　　

　　<%
Connection conn = DBCPConn.getConn();
String sql = "select * from user";
PreparedStatement pstmt = DBUtil.prepareStatement(conn, sql );
ResultSet rs = pstmt.executeQuery();

while(rs.next()){
System.out.println(rs.getInt(1));
}




%>库是不是真的连接通了