Tomcat设置JNDI

1、拷贝数据库驱动到tomcat的lib目录
2、打开conf/context.xml
加入

<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();