Tomcat连接池配置

配置文件：project name.xml

<?xml version='1.0' encoding='utf-8'?>
<Context docBase="project path" path="/project name" workDir="work/Catalina/localhost/project name">

<!-- "jdbc/TestDB"是JNDI的名字-->
<!-- 配置资源能够正常引用到的资源名称-->
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"/>
<!-- 配置了所使用的资源工厂运行的类的名称或者用来配置那个资源工厂的-->
<ResourceParams name="jdbc/mysql">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<!-- 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.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>

<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>

<!-- 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.
-->
<parameter>
<name>maxWait</name>
<value>90000</value>
</parameter>

<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value></value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>

<!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next
if you want to use this driver - we recommend using Connector/J though
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
-->

<!-- Class name for the official MySQL Connector/J driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>

<!-- 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.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/elearning?useUnicode=true&amp;characterEncoding=GB2312</value>
</parameter>
</ResourceParam

 

/**
通过连接池连接数据库，

*/
  Connection conn           = null;
   Statement stmt  = null;
   ResultSet rs    = null;
   try {
           Context initCtx  = new InitialContext();

            /**The java:comp/env name is bound to the environment naming context of the ConverterClient component.

     */
           DataSource ds    = (DataSource)initCtx.lookup("java:comp/env/jdbc/mysql");
           if(conn==null){
              conn  = ds.getConnection();
    }
    stmt        = conn.createStatement();
    rs.executeUpdate("select * from tablename");  

  rs.close();
    stmt.close();
    //Conn.close();
   } catch (Exception e) {
   
      if(conn!=null){
          conn.close();
          }
    out.print(e.toString());
   }

  %>