Tomcat连接池配置

/------------------------------------连接池配置(tomcat/wed.xml)-----------------------------------------------------/
<Context path="/yuxingshop" docBase="G:/J2EE/yuxing/workspace/yuxingshop/WebRoot">
<Resource auth="Container" name="jdbc/tcpdb1" type="javax.sql.DataSource"
maxWait="10000" maxIdle="20" maxActive="20"  username="yuxing" password="yuxing" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@127.0.0.1:1521:NAME"/>
</Context>

/------------------------------------获得链接池中的一个连接对象-----------------------------------------------------/
public static Connection getConnection(){
  Connection con = null;
  try {
   InitialContext context = new InitialContext();
   DataSource ds= (DataSource)context.lookup("java:comp/env/jdbc/tcpdb1");
   con = ds.getConnection();
  } catch (NamingException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return con;
 
  
 }