/------------------------------------连接池配置(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;
}