[/code]1、拷贝数据库驱动到tomcat的lib目录
2、打开conf/context.xml
加入
[code="java"]
<Resource name="jdbc/test"
auth="Container"
type="javax.sql.DataSource"
username="jtzt" password="jtzt"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:xe"
maxActive="100"
maxIdle="30"
maxWait="10000"/>
3、打开web.xml
加入
<resource-ref>
<description>OracleDataSource</description>
<res-ref-name>jdbc/test</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
4、程序访问JDBC数据源
// Obtain our environment naming context
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up our data source
DataSource ds = (DataSource)
envCtx.lookup("jdbc/test");
// Allocate and use a connection from the pool
Connection conn = ds.getConnection();
... use this connection to access the database ...
conn.close();
或者
// Obtain our environment naming context
Context initCtx = new InitialContext();
// Look up our data source
DataSource ds = (DataSource)
envCtx.lookup("java:comp/env/jdbc/test");
// Allocate and use a connection from the pool
Connection conn = ds.getConnection();
... use this connection to access the database ...
conn.close();