tomcat连接池的配置

1 首先，在server.xml中需要添加如下代码
  <Context path="/qxt" reloadable="true" docBase="F:/Web/webroot" workDir="F:/Web/work" >
          <Resource name="jdbc/esmpDB"
                    type="javax.sql.DataSource"
                    driverClassName="oracle.jdbc.driver.OracleDriver"
                    url="jdbc:oracle:thin:@192.168.168.201:1521:gdqxt"
                    username="qxt"
                    password="dbms_lock"
                    maxIdle="2"
                    maxWait="5000"
                    maxActive="100" />
   <Logger className="org.apache.catalina.logger.SystemOutLogger" verbosity="4" timestamp="true"/>
</Context>

2 在Connection的连接类中如下调用
  import java.sql.*;
  import javax.naming.Context;
  import javax.naming.InitialContext;
  import javax.naming.NamingException;
 
  public static Connection getConnection() {
 Connection conn=null;
 try {
   Context initCtx = new InitialContext();
   Context ctx = (Context) initCtx.lookup("java:comp/env");
   Object obj = (Object) ctx.lookup("jdbc/esmpDB");
   javax.sql.DataSource ds = (javax.sql.DataSource)obj;
   if (ds != null) {
      conn = ds.getConnection();
   }
 
 } catch (Exception e) {
    e.printStackTrace();
    return conn;
 }
 
 return conn;
  }
 
ok这样就配好了，调用和直连的jdbc没有什么两样。记住用完了要关哦。