tomcat下面配置外部连接池

在tomcat 安装目录下面 conf下面的 context.xml

<!-- The contents of this file will be loaded for each web application -->
<Context>

    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <!--
    <Manager pathname="" />
    -->
	<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30"  maxWait="10000" username="scott" password="tiger" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:MYORACLE" />
</Context>

后台java

package com.crm.datasource;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

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


/*
 * 获得数据源
 * */
public final class CRMDataSource {

	//私有构造方法
	private CRMDataSource(){		
	}
	//获得数据源对象
	private static DataSource getDataSource(){
		DataSource ds = null;
		try {
			ds = (DataSource)new InitialContext().lookup("java:comp/env/jdbc/oracle");
		} catch (NamingException e) {
			//LogFactory.getLogger("CRMDataSource").error("创建数据源失败");
		}
		return ds;
	}

	/**获得链接对象
	 * @param null
	 * @return Connection
	 * */
	public static Connection getConn(){
		Connection conn = null;
		try {
			ConnectionPools cp = ConnectionPools.getInstance();
			conn = cp.getConnection();

		} catch (Exception e) {
			//LogFactory.getLogger("CRMDataSource").error("创建链接失败");
		}
		return conn;
	}
}