一 首先我們在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));?? ?
?? ??? ?}
?? ??? ??? ?



%>庫是不是真的連接通了

?

Tomcat中的配置DBCP